… support dump and restore of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored from backup to give excellent performance without a lengthy “warm up” time. If provisioning a slave, this means your new slave will end up with a warmed up buffer pool to mimic that of the master. Streaming…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… dropped. Basically when restoring may take less time that trying to load a logical backup. Restoring your data from backup is another topic… same on master and slave Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL I…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… over and over… How can you create loops ? You restore a backup from another machine and you forget to change the server…. change the replication master position on the active master to a newer position from the passive master (get position from show master status\G on mysql 4) Illustration… the active master (server 1): mysql> stop slave; Step 2: there are writes on the active master, the loop statements are also replicated from the…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores and … you have no load on the slave and need it to catch up or when restoring from backup, the loaded replication capacity matters… it is less than 1, so the master writes more binary logs than slave can process they will show number close to…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
…Restore from backup Take restored state snapshot and compare to original state Slave setup Similar to our basic test except we create a slave from… work on the master and compare master and slave states One of the… a WONDER-tool!) : ) * Innobackupex, a MySQL / Percona server and the appropriate …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… know MySQL Replication (statement based) works by fetching statements from MASTERs binary log and executing them on the SLAVE. Since MySQL …restore the replication using CHANGE MASTER TO statement. It is very important to understand the difference between IO Thread position in Master logs (Master…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…master log files up to which replication was done: InnoDB: In a MySQL replication slave the last master…slave-start on the slave server and have a little script which will do CHANGE MASTER TO to specified location to restore…snapshot (for backup or to clone slave from the master) and can’t do …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… traditional database background. > Things are different with MySQL. Good design will help dictate how many… to do a full data restore, more tables means longer restore times. Deciding to create a…from a master to a slave, there is no reason why you can’t remove the foreign key references on the slave…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…master and two slaves, all had same setting Developer accidentally ran DROP DATABASE X on the wrong machine (production master) All slaves…restore from backup on the production master…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…that are hard to maintain, back up, and restore. And the partitioning functionality is not done…save you from the downtime caused by ALTER TABLE — a typical reason to think about master-master with …MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master…
