… think too much about is if moving from async to synchronous replication is right for their application or not. Facts about… a time. So, Callaghan’s law applied to semi-sync is: [On a semi-sync replication master] you can’t commit (at… weigh both options carefully. But in Galera you cannot relax synchronous replication. You can’t change the law, you can only…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
…. They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other… parallelization here. I could not find any way to parallelize semi-synchronous replication (at least in 5.5), I could be missing… multi-datacenter system for high availability and disaster recovery than semi-synchronous replication in stock MySQL.
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… inconsistent database, broken replication and other problems. I should note semi-synchronous replication available in MySQL 5.5 does not solves these… lagging as semi synchronous replication does not wait for execution only for queing event in relay log. Now lets see how Synchronous Replication…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
… thing to understand is that despite the name, semi-synchronous replication is still asynchronous. Semi-synchronous is actually a pretty bad name, because there…, that is not what happens in semi-synchronous replication. And if there is an error in semi-synchronous replication, such as a crash at…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…All, There is comment on semi-synchronous from Alex Yurchenko @ Galera “Technically speaking Galera is semi-synchronous – just like semi-sync in 5.5. In…
Comment: MySQL Master-Master replication manager released
April 9, 2007 By 27 Comments
… synchronous replication if you wanted. It’s at least nice to have that functionality for some applications.” How ? You can implement semi-synchronous replication which is barrier based, what I’ve told but not fully Synchronous. Synchronous replication means any reads…
Comment: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
… limitation of Semi Synchronous replication was noted and there is a patch to improve it: http://code.google.com/p/enhanced-semi-sync-replication/ With Enhanced Semi Sync Replication the data is committed locally only…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… features, but there is nothing to complain about it – a synchronous distributed transactional system is not an easy problem to solve…-slave setups, but with big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge reception… towards better side). But this is price to pay for synchronous not-getting-behind slaves. With additional nodes, the response time…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… we should look for? A: Percona XtraDB Cluster is a synchronous replication technology, therefore the slaves should never lag behind the… really a bit like semi-synchronous replication, in that changes are queued on all cluster nodes, but not executed synchronously. Because of features…
Comment: How Does Semisynchronous MySQL Replication Work?
March 15, 2012 By 24 Comments
This is not correct. With semi-sync the protocol is: 1) commit to master 2) wait … to ack it 3) return to the user “Basically, what semi-synchronous replication does is ensuring that a transaction/event has been…
