… Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New HA solution. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 4, 2012 By 10 Comments
… US Western region. As I understand it, due to the synchronous replication all writes would be affected by the network latency between…
Comment: How Does Semisynchronous MySQL Replication Work?
March 15, 2012 By 23 Comments
… 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
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 16 Comments
… be unavailable ( The logs are bellow). Other then that, the replication works fine. We are concern of the possibility that incremental…:14:26 ubuntu-server-129 mysqld: #011 at galera/src/replicator_str.cpp:prepare_for_IST():429. IST will be unavailable… ubuntu-server-129 mysqld: 120401 14:14:27 [Note] WSREP: Synchronized with group, ready for connections Apr 1 14:14:27…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
… properly. The idea by itself is not new, I remember synchronous replication was announced for SolidDB on MySQL UC 2007, but later… latest developments in computer science to produce fast and scalable synchronous replication solution that “just works” for databases and similar applications”, which…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
…. To understand why, let’s look at what truly synchronous replication means. In truly synchronous replication, when you commit a transaction, the commit does… is not what happens in semi-synchronous replication. And if there is an error in semi-synchronous replication, such as a crash at the…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
… several appliers working in parallel. This gives us true parallel replication. Slave can have many parallel threads, and you can tune… slave and master is the reason why this replication named “virtually synchronous replication“, not real “synchronous replication” The described behavior of COMMIT also has the…
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 at any…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 4 Comments
… all object ids which were modified from the point slave synchronized successfully and retrieve those objects back from the new master… them if they no more exist). Such approach allows quick synchronization without any complex support of rolling back changes. In MongoDB… the great presentation on MongoDB Replication by Dwight Merriman as well as previously looking at how replication done in Redis I should…
