… then it is being configured to become a new slave to the same master as the donor machine. Every once in a… and Oracle MySQL 5.5.x (x=16 on many boxes atm), but we have been experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… is different issue. In many versions Innodb would print wrong position for current binary…http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed… LOCK anyway you can consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…. MySQL is not restarted. If no slaves are ok, all VIPs, readers and writer, will be located on the master During a master switch… node will promoted to master. There are not many requirements regarding the MySQL configuration, Pacemaker will automatically add “skip-start-slave” for a saner…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
…Master-Master approach, finding Master with many slaves more optimal. There is surely room for master-N-slaves systems but I find Master-Master replication much better approach in many…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…. Swapping master. Finally as you have your slave running on new MySQL version you want to promote it to the master and upgrade Master too… run into some serious issues with Master. In many cases you can leave the ex-Master as a slave so you can fail back… cases however it is not possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…, trust me. So Galera 0.8 comes with many nice features: Works with MySQL 5.1 and MariaDB 5.1. The latest… it in traditional master-slave setups, but with big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge… three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the… the future. It can manage master-master pair as well as other configurations such as master-master and bunch of slaves. Typically you would define…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… view the comparisons of master-slave checksums after the master has crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5.5 –test-debug… wider coverage. However, this approach gets tiresome when one has many test cases (more to maintain!). My solution to this problem…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… per say but operating mode change may cause the problem. Many RAID controllers have to periodically go through battery learning cycle… help in this case. Changing Slave Role Changing Slave role, such as swapping active and passive masters in Master-Master setup is often cause of the problem for similar reason as MySQL…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… – MySQL Replication executes queries one after another on the slave, so if you have query which takes certain time on the master you… actually the most fun to deal with as there are many techniques and workarounds. First you normally start with query chopping… often run directly on the Slave(s) when master switched to one of them (especially easy with Master-Master setup) and when query repeated…
