EmergencyEMERGENCY? Get 24/7 Help Now!

5 free handy tools for monitoring and managing MySQL replication

 | March 9, 2015 |  Posted In: MySQL, Percona Software, Percona Toolkit

MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication. What is MySQL Replication? It’s the process of copying the (real-time events) data from one master instance to another slave instance and maintaining the redundant consistent data in a different […]

Read More

Percona Toolkit 2.2.13 is now available

 | January 26, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is pleased to announce the availability of Percona Toolkit 2.2.13.  Released January 26, 2015. 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

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