EmergencyEMERGENCY? Get 24/7 Help Now!

Making HAProxy 1.5 replication lag aware in MySQL

 | December 18, 2014 |  Posted In: haproxy, Insight for DBAs, MySQL, Percona Toolkit, Percona XtraDB Cluster

HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes. The same approach can be used in a regular master-slaves setup to spread the read load across […]

Read More

How a set of queries can be killed in MySQL using Percona Toolkit’s pt-kill

 | November 19, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona Toolkit

You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading. Report query (select) offloading to a slave server is a common practice to reduce the workload of the […]

Read More

Percona Toolkit 2.2.12 is now available

 | November 17, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is pleased to announce the availability of Percona Toolkit 2.2.12.  Released on November 14, 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 […]

Read More

Data inconsistencies on MySQL replicas: Beyond pt-table-checksum

 | November 4, 2014 |  Posted In: MySQL, Percona Toolkit

Percona Toolkit’s pt-table-checksum is a great tool to find data inconsistencies between a MySQL master and its replicas. However it is sometimes not enough to know that there are inconsistencies and let pt-table-sync fix the issue: you may want to know which exact rows are different to identify the statements that created the inconsistency. This […]

Read More

Percona Toolkit for MySQL with MySQL-SSL Connections

 | October 16, 2014 |  Posted In: MySQL, Percona Toolkit

I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be accessing MySQL over public internet or even over a public “private” […]

Read More

How to avoid hash collisions when using MySQL’s CRC32 function

 | October 13, 2014 |  Posted In: MySQL, Percona Toolkit

Percona Toolkit’s  pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently between MySQL tables. The tools by default use the CRC32. Other good choices include MD5 and SHA1. If you have installed the FNV_64 user-defined function, pt-table-sync will […]

Read More

Percona Toolkit 2.2.11 for MySQL is now available

 | September 30, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is pleased to announce the availability of Percona Toolkit 2.2.11.  Released on Sept. 25, 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 contains […]

Read More

Logical MySQL backup tool mydumper 0.6.2 now available

 | September 26, 2014 |  Posted In: MySQL, Percona Toolkit

We are pleased to announce the third release in the 0.6 series of mydumper, a tool for performing logical MySQL backups. In this release, we focused on simplifying compiling the code and added new features for making logical backups. These new features include enhancements to AWS RDS support and extending TokuDB support. Due to recent changes (or […]

Read More

Syncing MySQL slave table with pt-online-schema-change

 | September 17, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

I recently encountered a situation in which after running Percona Toolkit’s pt-table-checksum on a customer system, 95% of the table on the MySQL master was different on the MySQL slave. Although this table was not a critical part of the infrastructure, from time to time, writes to the table from the master would break replication. […]

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.