…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…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
…master and a commit on the replicas. To understand why, let’s look at what truly synchronous replication means. In truly synchronous…In MySQL‘s semi-synchronous …master and at least one slave). If the master commits but a crash occurs while the master is waiting for acknowledgment from a slave…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…it in traditional master-slave setups, but with big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge …weeks, and from my observation, the task to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 4 Comments
… new Master. In MySQL world we can chose to either ignore this problem (or may be even replay those changes on slaves and hope… slave synchronized successfully and retrieve those objects back from the new master (or delete them if they no more exist). Such approach allows quick synchronization…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… queries. If you’re using only Innodb tables and do not need to synchronize binary log position with backup you can skip… to the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to saved binary log position: change master to master…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
…your cluster and do not worry that eventually you get out-of-sync situation, as it regularly happens with regular MySQL …the read. This gap between slave and master is the reason why this replication named “virtually synchronous replication”, not real “synchronous replication” The described behavior…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
… Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was …synchronous your “slaves-nodes” are in the same state, there is no “slave behind”. When you read from any slave… Implementing fast, scalable and working group communication and transaction manager is the…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
…Synchronous Multi-Master replication plugin for transactional applications. The Galera library is developed by Codership Oy company and…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…) to identify rows that have changed Triggers to capture changes synchronously Database log reading to capture the changes asynchronously The first… up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master. I’ll talk…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…Synchronous replication. Transaction either commited on all nodes or none. Multi-master…slave. Real “parallel replication”. Automatic node provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL…
