… the amazing MySQL manual, especially the option and variable reference table. But just …sync_master_wait_sessionsblogpercona.commanual Rpl_semi_sync_master_yes_txblogpercona.commanual rpl_semi_sync_slave_enabledblogpercona.commanual Rpl_semi_sync_slave_statusblogpercona.commanual rpl_semi_sync_slave…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
…master‘s or slave‘s MySQL code. If you want to check the master‘s binary log or slave…slaves. Skipping around event makes master and slave potentially inconsistent and you should access the risks depending on applications (and… tables are out of sync and when use mk-table-sync to resync them. Last …
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…and 5.1 slave at the same position and used mk-table-checksum to ensure the data is in sync…slaves at the same position again and used tcpdump and mk-query-digest to get sample read traffic from both master and slave… hook up old MySQL 5.0 and all it slaves as a slave off new master and keep it for …
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
… only writing to the master. In any case you need slave to be synced with Master. To discover the difference between Master and Slave you can use…; UNLOCK TABLES; This will dump master‘s table content to the file clean the table on master and slave and refresh it on both of… anyway as having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL…master-master pair as well as other configurations such as master-master and bunch of slaves. Typically you would define “roles” for example READER and… is still in sync) – I see too …
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…master-slave pair, subject the master to a transactional load, crash the master, restart it, then ensure the master and slave are in sync…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
… your cluster and do not worry that eventually you get out-of-sync situation, as it regularly happens with regular MySQL replication if…_slave_threads Second: There might be a small period of time when the slave is out-of-sync from master. This happens because the master may apply event faster than a slave. And if you do read from the slave…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… master – active master setups. You can write on both masters and do not worry about conflict resolution and get rid of those “slave is out of sync… weeks, and from my observation, the task to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…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…slave never lags and slave never is able to catch up. MySQL…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
…slippage between master and slave in a standard replication setup. The client was using Maatkit’s mk-table-checksum to check his slave … trigger. The Foo_History table is now out of sync. Master: *************************** 1. row *************************** Foo_History_Id: 1 Name: maxlength Value: …
