Author - Muhammad Irfan

MySQL Downgrade Caveats

mysql downgrade

In this blog, we’ll discuss things to watch out for during a MySQL downgrade.
Previously, I wrote the blog MySQL upgrade best practices. Besides upgrading your MySQL version, sometimes you need to downgrade. When it comes to downgrading MySQL, there are two types of downgrade methods supported:

In-Place Downgrade: In this method, you use the existing data directory […]

Read more

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

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

Top Most Overlooked MySQL Performance Optimizations: Q & A

Overlooked MySQL performance optimization

Thank you for attending my 22nd July 2016 webinar titled “Top Most Overlooked MySQL Performance Optimizations“. In this blog, I will provide answers to the Q & A for that webinar.
For hardware, which disk raid level do you suggest? Is raid5 suggested performance-wise and data-integrity-wise?
RAID 5 comes with high overhead, as each write turns […]

Read more

MySQL “Got an error reading communication packet”

MySQL error reading communication packet errors

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. So let’s discuss possible reasons for this error and how to remedy it.
MySQL Communication Errors
First of all, whenever a […]

Read more

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

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