…master_yes_txblogpercona.commanual rpl_semi_sync_slave_enabledblogpercona.commanual Rpl_semi_sync_slave_statusblogpercona.commanual rpl_semi_sync_slave…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically microseconds. However if …application. So in which case I would go using simple master slave replication ? – Small database size. Small meaning working set fits in memory…
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… manage master-master pair as well as other configurations such as master-master and bunch of slaves….server if it gets too delayed with replication (or if replication breaks) so you do…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
…master, and can’t be rolled back. What should semi-synchronous replication be called instead? I believe that it should be called delayed…master and at least one slave). If the master commits but a crash occurs while the master is waiting for acknowledgment from a slave…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.10.171 Master_User: replicant Master… master log file. Only in rare cases of switching master binary log file or replication being delayed…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true delay… was running some heavy queries on the master which not take time to replicate to the slave replication lag can be significant. Also even…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…MySQL features which break replication. The failover node is a hot standby, it’s just not a running slave…MySQL Master-Master replication…MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication…
Post: How expensive is MySQL Replication for the Master
January 16, 2010 By 13 Comments
… generally thought about MySQL replication as being quite low overhead on Master, depending on number of Slaves. What kind of load extra Slave causes ? Well… slave. If you have large amount of slaves the delay from the event executed on the master to last thread sends packet to the slave…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…delayed replication (which you already could have set up with mk-slave-delay from Maatkit. Delayed slave is especially helpful if application can operate with just master…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
… without changing MySQL Replication semantics – which is – Slave database state corresponds to master database state at certain point in time. It is delayed but threads… log file and setup multi-master replication so slave can read all of them in parallel you can get replication parallel enough for many…
