… pool dumps can be produced and loaded for faster server warmup after the start. This feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… pool dumps can be produced and loaded for faster server warmup after the start. This feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
…are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-… separate undo tablespace, 5.6-style buffer pool dump files). Bugs Fixed: Individual InnoDB tablespaces with …files. Bug fixed #1085099 (Alexey Kopytov). XtraBackup for MySQL 5.6 has improved the error reporting …
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB…are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-specific… separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup can use XtraDB changed …
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… internally because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html… mysqldump again. We take a dump from the master like we saw before and try to restore it on the slave: slave1… messages can dissapear on the shell buffer because the restore of the dump will continue. Be cautious. Same problem again so same…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13… Launchpad. Improvements SHM Buffer Pool has been replaced with LRU Dump/Restore The ”SHM” buffer pool patch, which provided the ability to… restarts, has been removed. Instead, we recommend using the LRU Dump/Restore patch which provides similar improvements in restart performance. Replacement is…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita). Compatibility Collations Two new collations, utf8_general50_ci… widely used. Instead, we recommend using the much safer LRU Dump/Restore patch, which provides similar improvements in restart performance and has…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… the amazing MySQL manual, especially the option and variable …resetblogpercona.commanual Com_resignalblogpercona.commanual Com_restore_tableblogpercona.commanual Com_revokeblogpercona.commanual Com…commanual Sort_scanblogpercona.commanual sporadic_binlog_dump_failblogpercona.commanual sql_auto_is_…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… high transaction performance like InnoDB buffer pool dump/restore and HandlerSocket, our favorite tricks for backup, restore, and provisioning of large data sets…
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
Some weeks ago I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) to a Percona… would then become a loop : for each production server restoring the dump on the node that will be the dedicated slave convert… XtraDB Cluster is also standard slave (standard asynchronous replication of MySQL), it can spread in the cluster all statements received from…
