EmergencyEMERGENCY? Get 24/7 Help Now!

pmp-check-pt-table-checksum Percona Monitoring Plugin

 | September 14, 2016 |  Posted In: MySQL

pmp-check-pt-table-checksum

Recently, I worked on a customer case where the customer needed to monitor the checksum via Nagios monitoring. The pmp-check-pt-table-checksum plugin from Percona Monitoring Plugins for MySQL achieves this goal. I thought it was worth a blogpost. pmp-check-pt-table-checksum alerts you when the pt-table-checksum tool from Percona Toolkit finds data drifts on a replication slave. pmp-checksum-pt-table-checksum monitors data differences on the slave from […]

Read More

MySQL “Got an error reading communication packet” errors

 | May 16, 2016 |  Posted In: MySQL

Galera Error Failed to Report Last Committed

In this blog post, we’ll discuss the possible reasons for MySQL “Got an error reading communication packet” errors, and how to address them. In Percona’s managed services, we often receive customer questions on communication failure errors – where customers are faced with intermittent “Got an error reading communication packets” messages. I thought this topic deserved […]

Read More

MySQL replication primer with pt-table-checksum / pt-table-sync, part 2

 | March 17, 2016 |  Posted In: MySQL

pt-online-schema-change

This is the second and last tutorial blog post on how to use pt-table-checksum / pt-table-sync tools for MySQL replication. In the first post, I showed you how to use the pt-table-checksum  / pt-table-sync  tools in a typical MySQL replication setup. In this post, we’ll discuss MySQL replication for more advanced topologies. I will show you how to […]

Read More

MySQL 5.7: CHANGE REPLICATION FILTER online

 | November 4, 2015 |  Posted In: MySQL

shutterstock_253451584

MySQL 5.7 has a lot of enhancements and new features. I summarized this list previously in this blog post. Adding replication filters online is one of the MySQL 5.7 features described in this manual. However, I will describe and summarize a few examples in this blog post. Filtering replication events is also known as Partial Replication. […]

Read More

MySQL 5.7 key features

 | May 27, 2015 |  Posted In: InnoDB, MySQL, Percona MySQL Support

The other day I was discussing new features of MySQL 5.7 with a Percona Support customer. After that conversation, I thought it would be a good idea to compile list of important features of MySQL 5.7. The latest MySQL 5.7.6 release candidate (RC) is out and is packed with nice features. Here’s a list of […]

Read More

3 handy tools to remove problematic MySQL processes

 | February 27, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server

DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools to remove problematic MySQL processes. I will highlight all of the tools via some […]

Read More

MySQL 5.6 Transportable Tablespaces best practices

 | December 9, 2014 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla MySQL server. Moreover, since Percona Server 5.6, innodb_import_table_from_xtrabackup is obsolete as Percona Server also […]

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.