EmergencyEMERGENCY? Get 24/7 Help Now!

Logical MySQL backup tool Mydumper 0.9.1 now available

 | November 12, 2015 |  Posted In: MySQL

Databases backup

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: MySQL

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

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.