… solution. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node… Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… a single-mastered data store and why it’s a hard problem to solve. State of the Art for MySQL Multi-Master Replication - (Robert Hodges, Continuent) – Robert is the master in discussing the pros and cons of… with this kind of architecture. Case Study: Designing a synchronous multi-master cluster for elastic scale-out and scale-in in the…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… the way replication is implemented, only one thread on the slave can handle the write operations. If the replication master is multi-cores servers and is heavily writing using multiple threads, the slaves will likely not be able to keep up. Replication…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… way to break such replication is also using multi-table update or delete statements, if you happen to replicate one table or another… example cloning Master (and dropping not replicated tables) to set up replication becomes more tricky because you need to perform mapping between master positions…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles traffic. You may be able to send some traffic to Slaves but because of asynchronous nature of replication… traffic or it is not. There is also no complex multi step failover process – from HA system standpoint if the node…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… the solution that’s least evil. Why isn’t there multi-threaded replication? I think that a) it’s not as easy… that it would allow a replica to subscribe to multiple masters, which is currently impossible. These solutions represent different types of… have to default to single-threaded as replication currently does, and only enable the multi-threaded behavior if the user configures it…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
….17 Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node… and includes Write Set REPlication patches. It uses the Galera library, version 2.x, a generic Synchronous Multi-Master replication plugin for transactional applications…
Comment: MySQL Master-Master replication manager released
May 21, 2007 By 27 Comments
… me on how the MySQL Multi Master replication model is working or how it is different from a Master – Slave replication in terms of the latency since both are asynchronous. How in the Master Master replication the latency is…
Comment: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 19, 2012 By 17 Comments
… in master-slave topology, Galera replication gives many benefits over mysql replication. Many projects migrate to G world by first running in master-slave and escalate to multi-master model…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… Cluster. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic node provisioning…
