… MySQL Conference Galera 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…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
This is about the second great feature – Multi-Master replication, what you get with Percona XtraDB Cluster. It is recommended … out-of-sync situation, as it regularly happens with regular MySQL replication if you imprudently write to the wrong server. This is… do not do that. So, if you plan to use Multi-Master capabilities of XtraDB Cluster, and run write transactions on several…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…multi-master replication, the other master should also replicate events : Closer look: Infinite Replication Loop flow: If you have master-master…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
Kevin Burton writes about making MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in… soon. On other hand if support for Multi-Master is implemented for many applications Parallel Replication could be implemented simply by filtering transactions… log file and setup multi-master replication so slave can read all of them in parallel you can get replication parallel enough for many…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
… Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any… compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any… compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal…
Post: Percona XtraDB Cluster Events
February 24, 2012 By 6 Comments
…’t not make to MySQL Conference, you may attend webinar. Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. As I expect, the… Percona XtraDB Cluster: New HA solution. Out book «High Performance MySQL, 3rd edition» has couple pages dedicated to Percona XtraDB Cluster…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…master_connect_retryblogpercona.commanual master_hostblogpercona.commanual master_info_fileblogpercona.commanual master_passwordblogpercona.commanual master_portblogpercona.commanual master_retry_countblogpercona.commanual master_sslblogpercona.commanual master_ssl_cablogpercona.commanual master…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…. That means Galera supports the XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts for node propagation. RSYNC method… we can setup distributed replication systems with masters in different data centers. This provides a HA solution for MySQL setups in the Cloud…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle…that’s least evil. Why isn’t there multi-threaded replication? I think that a) it’s …would allow a replica to subscribe to multiple masters, which is currently impossible. These solutions represent …
