EmergencyEMERGENCY? Get 24/7 Help Now!

Logical MySQL backup tool Mydumper 0.9.1 now available

 | November 12, 2015 |  Posted In: MySQL

The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available.  You can download the code from here. A significant change included in this version now enables Mydumper to handle all schema objects!!  So there is no longer a dependency on using mysqldump to ensure complex schemas are backed up alongside the data. Let’s review […]

Read More

Containing your logical backups: mydumper in docker

 | September 21, 2015 |  Posted In: Docker, MySQL, Percona Backup Service, Percona XtraBackup

Docker

Even with software like Percona Xtrabackup, logical backups remain an important component of a thorough backup strategy. To gather a logical backup in a timely fashion we rely on a tool called mydumper. In the Percona Managed Services department we’re lucky enough to have one of the project’s most active contributors and many of the latest features and […]

Read More

mydumper [less] locking

 | June 13, 2014 |  Posted In: Insight for DBAs, MySQL

In this post I would like to review how my dumper for MySQL works from the point of view of locks. Since 0.6 serie we have different options, so I will try to explain how they work As you may know mydumper is multithreaded and this adds a lot of complexity compared with other logical […]

Read More

Introducing backup locks in Percona Server

 | March 11, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software, Percona XtraBackup

TL;DR version: The backup locks feature introduced in Percona Server 5.6.16-64.0 is a lightweight alternative to FLUSH TABLES WITH READ LOCK and can be used to take both physical and logical backups with less downtime on busy servers. To employ the feature with mysqldump, use mysqldump –lock-for-backup –single-transaction. The next release of Percona XtraBackup will […]

Read More

New mydumper 0.6.1 release offers performance and usability features

 | March 10, 2014 |  Posted In: Events and Announcements, MySQL, Percona Remote DBA

One of the tasks within Percona Remote DBA is to ensure we have reliable backups with minimal impact. To accomplish this, one of the tools our team uses is called mydumper. We use mydumper for logical backups because of several nice features. Some of them are: multithreaded, producing very fast backups compared to mysqldump almost […]

Read More