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 written…
Comment: How Does Semisynchronous MySQL Replication Work?
March 15, 2012 By 23 Comments
Hi Mark, Which part of the following article is wrong according to you ? http://www.dbi-services.com/index.php/blog/entry/mysql-data-high-availability-with-semi-synchronous-replication Thanks for your feedback, best regards
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
… with semi-synchronous replication, and what you don’t get. The first thing to understand is that despite the name, semi-synchronous replication is still asynchronous. Semi-synchronous…, that is not what happens in semi-synchronous replication. And if there is an error in semi-synchronous replication, such as a crash at the wrong…
Comment: MySQL Master-Master replication manager released
April 9, 2007 By 27 Comments
… implement 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 at any…
Comment: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
… 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…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… replication is asynchronous so whenever you switch to the slave in case of master failure you may loose transactions. Google semi-synchronous replication patches… DRBD to get a standby MySQL server or at least synchronously replicated master binary logs. If you can’t loose any single…
Comment: How Does Semisynchronous MySQL Replication Work?
January 20, 2012 By 23 Comments
I think it is not so bad to have an asynchronous replication. And the semi synchronous replication is not so bad. If you want to have synchronous replication you could use distributed transactions instead. And there we have similar problems …
Comment: How Does Semisynchronous MySQL Replication Work?
January 20, 2012 By 23 Comments
Holger, MySQL Replication is great and this is what made MySQL so successful … build truly highly available solutions with replication which also require consistency and no data loss. Semi Synchronous replication in fact can be enough for…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
…. Somewhere in 6.x series proper performance monitoring instrumentation and semi-synchronous replication is promised together with a lot of other good stuff… much of technical insight otherwise – pretty simple site, master slave replication, plans to use DRBD, nothing which I would call fancy…
Comment: Getting use of Slave in MySQL Replication
June 14, 2007 By 15 Comments
Dmitry, If replication is that delayed you need to tune it first as semi synchronous replication will cral very slow in such case.
