… bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… an open source solution, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version… protection to the backups. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client… can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0… that these versions are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-specific features… can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: Fixed couple of warnings found in innobackupex…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release… taking a full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups has been merged…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy… taking a full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug…
Post: What Are Full, Incremental, and Differential Backups?
January 23, 2012 By 9 Comments
… differential backups versus incremental backups. What is the difference? A full backup is pretty self-explanatory. It makes a copy of all of your MySQL… backup process can be significantly more efficient. An incremental backup is a modification of a differential backup. An incremental backup records the changes since the last backup…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM …system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. … supports an incremental mode of operation, so you can (for example) get the incremental increase in…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …commanual ansiblogpercona.commanual auto_increment_incrementblogpercona.commanual auto_increment_offsetblogpercona.commanual autocommitblogpercona…assign_to_keycacheblogpercona.commanual Com_backup_tableblogpercona.commanual Com_beginblogpercona….
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance… with integration with Percona XtraBackup and its incremental backup features, it is possible to have incremental node provisioning. To finalize this post, let…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
…and bring it back to the cluster with an incremental transfer after a crash. This feature was available … can be used if to restore nodes from backup. We can start all nodes from an identical … Starting mysqld daemon with databases from /mnt/data/mysql 130129 23:01:22 mysqld_safe WSREP: Running …
