… that the slaves can execute all events and be in sync with the master Change configuration for all servers and restart them Use CHANGE MASTER TO…, let’s create a simple replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually…(anyone obsessively testing slave position to ensure it’s caught up with the master?). Synchronous replication with PXC and Galera is no …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… 0.0 and 1.0, which is multiplied by the current fc_limit (adjusted by the above calculation if fc_master_slave=NO… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc…. Flow control and State transfer donation Donor nodes should not cause flow control because they are moved from the Synced to the…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
…mysql ‘start slave until master-log-file master-log-pos’ reliable enough to synch up two slaves with their master? I have a set up now with master and…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… 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: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… will try to run the master and slave IPS and will accept writes. But…And if you test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…synced with group. If the communication fails between node1 and node2, they will communicate and…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 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 11 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 …
