…-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really… MySQL replication, but my main focus will be the logistics – how replication events are written on the master, how they are transferred to the replication slave…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… get stuck to have all replication stalled. Long Queries – MySQL Replication executes queries one after another on the slave, so if you have query which takes certain time on the master you… is high enough so Master is almost fully busy handling the writes. This is not the case – because MySQL Replication runs in single…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… to know about partial replication – you can do filtering on the Master or on the Slave. Filtering on the Slave is normally preferred as…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically… application. So in which case I would go using simple master slave replication ? – Small database size. Small meaning working set fits in memory…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
…Slave_received_heartbeats | 1476 | +—————————+——-+ Conclusion If you need to know when exactly the connection between your Master/Slaves breaks then replication…
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
MySQL Replication is useful and easy to setup. It is used for … to slave 2012-09-10T12:41:31 slave stopped at master position mysql-bin.000001/100072820 [...] 2012-09-10T12:49:31 START SLAVE until master 2012… replication. With MySQL 5.6 this technique will be included natively: http://dev.mysql.com/doc/refman/5.6/en/replication-delayed.html CHANGE MASTER…
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… was running some heavy queries on the master which not take time to replicate to the slave replication lag can be significant. Also even… approach can be used in Master-Master replication in Active-Passive mode, just think about passive node as a slave. Query type based distribution…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles traffic. You may be able to send some traffic to Slaves but…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
… MySQL‘s semi-synchronous replication…master. However, that is not what happens in semi-synchronous replication. And if there is an error in semi-synchronous replication…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: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… “slave is out of sync with master” pain-in-the-neck problems. Combining all above, now we can setup distributed replication systems with masters… three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I…
