by Federico Razzoli | Jul 29, 2016 | MariaDB, MySQL
In this blog post, we’ll look at the MariaDB 10.2 CHECK and DEFAULT clauses. MariaDB 10.2 includes some long-awaited features. In this blog, we are going to discuss the improvements to some table definitions: the DEFAULT clause and the CHECK constraints. These...
by Dave Avery | Jul 28, 2016 | MySQL, Webinars
Join Brent Compton, Kyle Bader and Yves Trudeau on August 2, 2016 at 10 am PDT (UTC-7) for a MySQL and Ceph webinar. Many operators select OpenStack as their control plane of choice for providing both internal and external IT services. The OpenStack user survey...
by Peter Zaitsev | Jul 20, 2016 | MongoDB, MySQL, Percona Services
In this post, I’ll discuss how database support is good for your enterprise. Years ago when I worked for the MySQL Support organization at the original MySQL AB, we spoke about MySQL Support as insurance and focused on a value proposition similar to that of car...
by Dave Avery | Jul 19, 2016 | MySQL
Are you looking to improve your MySQL performance? Application success is often limited by poor MySQL performance. Please join Percona CEO and Founder Peter Zaitsev for this exclusive webinar on Wednesday, July 20th, 2016 at 11:00 AM PDT (UTC – 7) as he presents...
by Yves Trudeau | Jul 13, 2016 | Hardware and Storage, Insight for DBAs, MySQL
Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is...
by Hrvoje Matijakovic | Jul 7, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.31-77.0 on July 7th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.31, including all the bug fixes in it, Percona Server 5.6.31-77.0 is the...
by Alexander Rubin | Jul 6, 2016 | MySQL
by Alexander Rubin | Jul 5, 2016 | MySQL
In this post, I’ll discuss how MySQL 5.7 handles UTF8MB4 and the load data infile. Many of my clients have told me that they do not like using the LOAD DATA INFILE statement and prefer to manually parse and load the data. The main reason they do it are issues...
by Miguel Angel Nieto | Jul 1, 2016 | Cloud, MySQL
In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together. The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by...
by Manjot Singh | Jun 30, 2016 | Insight for DBAs, MySQL, Percona Software
This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the...
by Shahriyar Rzayev | Jun 29, 2016 | MySQL, Percona Events
In this post, I’ll share my experience attending the annual MySQL User Group Leaders Summit in Bucharest, Romania. The MySQL User Group Leaders Summit gathers together as many of the global MySQL user group leaders as possible. At the summit, we discuss further...
by Alexander Rubin | Jun 23, 2016 | MySQL
In this blog series, I will share my experiences as I migrate commercial databases (i.e., Microsoft SQL or Oracle) to open source (MySQL). More specifically, we will look at how you can migrate from MS SQL Server to MySQL. For this first blog post I’ve chosen...
by Sveta Smirnova | Jun 22, 2016 | MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting configuration issues webinar. First, I want to thank you for attending the June, 9 webinar. The recording and slides for the webinar are available here. Below is the list of your questions...
by Vadim Tkachenko | Jun 21, 2016 | Cloud, MySQL, Percona Software
In this post, we’ll discuss Docker automatic MySQL slave propagation for help with scaling. In my previous posts on the Docker environment, I covered Percona XtraDB Cluster. Percona XtraDB Cluster can automatically scale by conveniently adding new nodes using...
by Dave Avery | Jun 20, 2016 | Insight for DBAs, MySQL
Please join Percona, Technical Account Manager, Michael Patrick on Thursday, June 23, 2016 at 10 AM PDT (UTC-7) as he presents “
by Fernando Ipar | Jun 14, 2016 | MongoDB
In this blog, I will discuss how I found some of my basic SQL assumptions that don’t hold true when dealing with MongoDB and non-existent collections. Coming from a MySQL background, I have some assumptions about databases that don’t apply to MongoDB (or...
by Sveta Smirnova | May 31, 2016 | MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting locking issues webinar. First, I want to thank you for attending the May, 12 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I...
by Vadim Tkachenko | May 31, 2016 | MySQL
In this post, we’ll discuss what constitutes a big innodb_log_file_size, and how it can affect performance. In the comments for our post on Percona Server 5.7 performance improvements, someone asked why we use innodb_log_file_size=10G with an indication that it...
by Alexander Rubin | May 24, 2016 | MySQL
In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented. Document Store MySQL 5.7.12 is a major new release, as it contains quite a number of new features: Document store and “MongoDB” like NoSQL interface to JSON...
by Przemysław Malkowski | May 24, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are...
