EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 8.0

 | July 5, 2016 |  Posted In: MySQL

MySQL 8

If you haven’t heard the news yet, MySQL 8.0 is apparently the next release of the world-famous database server. Obviously abandoning plans to name the next release 5.8, Percona Server’s upstream provider relabelled all 5.8-related bugs to 8.0 as follows: Reported version value updated to reflect release name change from 5.8 to 8.0 What will MySQL […]

Read More

MySQL 5.7, utf8mb4 and the load data infile

 | July 5, 2016 |  Posted In: MySQL

utf8mb4 and the load data infile

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 is issues with the character sets, specifically […]

Read More

Amazon RDS and pt-online-schema-change

 | July 1, 2016 |  Posted In: MySQL

Amazon RDS and pt-online-schema-change

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 community users and customers. Using it on Amazon RDS requires knowing about some specific […]

Read More

Rescuing a crashed pt-online-schema-change with pt-archiver

 | June 30, 2016 |  Posted In: MySQL, Percona Server, Percona Software, Percona Toolkit, Replication

crashed pt-online-schema-change

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 pt-online-schema-change via manual operations such as RENAME TABLE and DROP TRIGGER commands. The normal process to […]

Read More

2016 MySQL User Group Leaders Summit

 | June 29, 2016 |  Posted In: Events and Announcements, MySQL

MySQL User Group Leaders Summit

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 actions on how we can better act for their local communities. This […]

Read More

Webinar Wednesday June 29: Percona XtraDB Cluster Reference Architecture

 | June 27, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

Percona XtraDB Cluster Reference Architecture

Please join Jay Janssen for the webinar Percona XtraDB Cluster Reference Architecture Wednesday, June 29 at 10:00 AM PDT (UTC- 7). A reference architecture shows a typical, common, best-practice deployment of a system with all the surrounding infrastructure. In the case of database clusters, this can include the hosting platform, load balancing, monitoring, backups, etc. Percona […]

Read More

The need for parallel crash recovery in MySQL

 | June 27, 2016 |  Posted In: MySQL

parallel crash recovery in MySQL

In this blog, I will discuss how parallel crash recovery in MySQL benefits several processes. I recently filed an Oracle feature request to make crash recovery faster by running in multiple threads. This might not seem very important, because MySQL does not crash that often. When it does crash, however, crash recovery can take 45 […]

Read More

Percona Toolkit 2.2.18 is now available

 | June 24, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona Toolkit

Percona announces the availability of Percona Toolkit 2.2.18, released on June 24, 2016. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source. This release is the […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.