EmergencyEMERGENCY? Get 24/7 Help Now!

Upcoming Webinar Wednesday August 16: Lock, Stock and Backup – Data Guaranteed

 | August 15, 2017 |  Posted In: Backups, MySQL, Technical Webinars

Backup

Join Percona’s, Technical Services Manager, Jervin Real as he presents Lock, Stock and Backup: Data Guaranteed on Wednesday, August 16, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Reserve Your Spot Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data […]

Read More

Testing backup locks during Xtrabackup SST on Percona XtraDB Cluster

 | December 22, 2014 |  Posted In: MySQL, Percona XtraBackup, Percona XtraDB Cluster

Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL) in Xtrabackup. While Xtrabackup can hot-copy Innodb, everything else in MySQL must be locked (usually […]

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