…high-availability solution. But, what they tend not to think too much about is if moving from async to synchronous replication…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… more write latency into the … less than 5 people who …
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
…MySQL 5.5 the only variable used to identify a network …a historically bad configured variable and stalled connections or high latency peaks were not detected for a long period of…having a 5.5 slave with replication‘s heartbeat enabled and connected to a 5.1 master doesn’t break the replication. …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
….5 years ago: State of the art: Galera – synchronous replication for …nice features: Works with MySQL 5.1 and MariaDB 5.1. The latest…MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High… parallel applying on slaves, the latency of round-trip transactions should…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…cluster over a wan connection with ~ 5 ms latency? A: Yes, it can be…high latency can potentially be an issue, otherwise this is mitigated by parallel replication. In this case the cost of latency…a slave on asynchronous replication, galera and built-in mysql replication are independent from each …
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
…replication (at least in 5.5), I could be missing something. PXC’s true parallel replication … PXC to scale much further across high latency environments. If each transaction took 100ms …datacenter system for high availability and disaster recovery than semi-synchronous replication in stock MySQL…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and…replicating over long distance and would like to save on traffic or if write load is high…you get into classical issues of chain replication – the latency will increase a bit (though …
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
…MySQL Enterprise from MySQL Marketing Materials . There is not much of technical insight otherwise – pretty simple site, master slave replication…MySQL Cluster – for example quite possible their solution could help a lot to shorten latency dealing with MemCache servers etc. MySQL High…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group commit…seeks but it is only part of the latency. Disk rotation is another big contibutor. Even if…Master overhead of Replication. Slave is where you can expect more problems, especially on high end systems. Slave…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…latency critical and rarely the problem and log writes, which is critical and latency sensitive. What many people do not realize is MySQL…all and not use MySQL replication instead. So assuming you…4 “sync” operations in MySQL 5.0 – there is event… you want to have things highly durable and performing …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… have problems with latency rather than throughput….replication mainly to be able to fail over if there are problems. Over time application still will be limited by MySQL…5-10K or some $500 a month if you want to lease it. Of course because of replication…stuff especially in high pace markets. Besides…
