… to Galera is existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that… use wsrep_causal_reads. It minimizes the expense of certification by keeping the window between new transactions being committed and the oldest…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
…replication, when you commit a transaction, the commit does not complete until all replicas have also committed successfully. In MySQL‘s semi-synchronous replication, the commit… to read the relevant section of the MySQL manual. But read carefully, for example, the following sentences: When a commit …
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… read committed for InnoDB . Serge in his post explains why READ COMMITED is better for TPCC load, so why don’t we take tpcc-mysql…: READ-COMMITED is used rare than REPEATABLE-READ (default), that is less-tested READ-COMMITED does not work with statement-based replication in 5.1 with READ-COMMITED…
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…committed transactions but failover process is still complicated and you still can have slaves lagging as semi synchronous replication… provides – such as it is safe to read and write from any node and…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_…innodb_read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication_delayblogpercona…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
…regular MySQL replication …read. This gap between slave and master is the reason why this replication named “virtually synchronous replication“, not real “synchronous replication” The described behavior of COMMIT…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation… based replication. If your application can deal with phantom reads and your binary log is in row format, changing the ISOLATION to READ COMMITTED…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… the read-to-write ratio is. What are some workarounds? Here are a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle standby server, which can’t be used for serving reads, only… thread. The worker thread would run up until the COMMIT, but not actually commit, and then report back to the coordinator thread…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…replication in MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL…_Log_File: mysql-bin.000006 Read_Master_Log_Pos: 98 Relay_Log_File: mysql_sandbox20551…test.t; -> drop temporary table test.t; -> commit; -> end// master > delimiter; Now calling…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…MySQL Support customers ask is MySQL Replication Lag. …replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit…Read Traffic Changes Slave read traffic impacts replication performance dramatically and even if nothing has changed to the replication…
