…-sync MySQL replication? It’s actually much worse than Galera. As I illustrated in a blog post last year, semi-sync must serialize…-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but we’re making them (anyone obsessively testing slave position…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…reviewed or tested semi-sync in official MySQL so I am surprised by this …, so we are effectively serializing our 32 clients with semi-sync replication. Apparently each client must wait for it’s turn writing to the binlog and waiting for confirmation from the slave…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication…stores data that replication slave will be reading later. Whenever a replication slave connects to a…. Writes, even though they are serialized, will be fast because they …
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
Brian Aker recently published good write up about using MySQL replication. The piece I find missing however is good description of … need to watch out for slave being able to keep up at all. Remember writes to slave are serialized so if you master… times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
Jeremy Cole recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. … only Master overhead of Replication. Slave is where you can expect more problems, especially on high end systems. Slave serializes all operations to single…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…MySQL Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL replication…can) but the certification process is serial as well as sending write set…3 #wsrep_cluster_address=gcomm:// wsrep_slave_threads=8 wsrep_sst_method=…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to be serialized. Second, MySQL…MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… master and slave in a standard replication setup. The client was using Maatkit’s mk-table-checksum to check his slave data was… transactions updating the Foo table can be reordered once serialized on the slave. Here is an example: I recreated the tables and…; Now when these statements get run on the slave they will be serialized, thus changing the order of the inserts made by…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… control but with semi-sync enabled on the slave (slave was in the other colo). XtraDB Cluster 1… ~100ms, so we are effectively serializing our 32 clients with semi-sync replication. Apparently each client must wait … availability and disaster recovery than semi-synchronous replication in stock MySQL…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
… box. Also, failover with MySQL replication is far from instantaneous, you still need to wait on the slave fo the Relay binlog to… your data being properly serialized. And even if you are not, there is one issue with using MySQL Replication that can make things… there is sometning wrong with MySQL Replication, or that it cannot be used for HA, but that MySQL Replication has many other uses (scale…
