…’t pass certification (or this would be a form of two-phase commit), so the only way nodes might get different certification results… force all nodes to commit simultaneously to guarantee cluster consistency as you would in a two-phase commit architecture. Seeing when replication conflicts happen This…
Post: Understanding Multi-node writing conflict metrics in Percona XtraDB Cluster and Galera
November 20, 2012 By 17 Comments
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… precisely what this option is for. It enables two-phase commit in InnoDB (prepare, then commit). This is necessary not only for user-initiated… performance. Having innodb_support_xa enabled on a replication master—or on any MySQL server where binary logging is in use—ensures…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…MySQL being slow but few queries being “inside innodb” and potentially even empty queue. This is because bottleneck happens in commit phase…MySQL 4.1 Disable Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication… of first two workarounds you…
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… and 2. have binary logging (replication) enabled your benchmarks suggested that by doing that (even if group commit is “broken”) you can… to make of that. XA support is traditionally for 2-phase commits between two different databases (or other transactional resources), i wouldn’t…, if you have enabled binary logging (replication), sync_binlog = 1, and you’re using MySQL 5, and it’s the only transactional…
