… node along with a script which checks PXC for its sync status. As referenced in that post, you can refer a…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Comment: Is Synchronous Replication right for your app?
May 28, 2013 By 18 Comments
Jay – Yoshinori found one performance bug for semi-sync — http://bugs.mysql.com/bug.php?id=69341. Wonder if there are others.
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… that the slaves can execute all events and be in sync with the master Change configuration for all servers and restart…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… post. Tuning flow control Flow control is triggered when a Synced node exceeds a specific threshold relative to the size of… lcf bfa 09:22:17 myclu P 3 3 node3 Sync T/T 0 0 0 9 0 13K 0.0… not cause flow control because they are moved from the Synced to the Donor/Desynced state. Donors in that state will…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… level of detail. I have not reviewed or tested semi-sync in official MySQL so I am surprised by this and…. But my peers are interested in semi-sync now so we will verify this. “Semi-sync performs dismally under concurrency. Think about…, so we are effectively serializing our 32 clients with semi-sync replication. Apparently each client must wait for it’s turn…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse than Galera. As I illustrated in a blog post last year, semi-sync must serialize all transactions and wait for them one at… time. So, Callaghan’s law applied to semi-sync is: [On a semi-sync replication master] you can’t commit (at all…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… still one noticeable omission: pt-table-sync. It’s still unclear if or how one would sync a cluster that, in theory, doesn’t become out-of-sync. As Percona XtraDB Cluster develops…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Mark: I’d be interested to know if semi-sync can be improved as well. I’m not seeing a lot of love on Semi-sync in general, though if you guys come up with a…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… tables pt-table-checksum/pt-table-sync, to check if data on replicas is in sync with data on the master pt…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… a blocking operation. With FlashCache, echoing “1″ to the do_sync sysctl of the cache device triggers a cache flush, but…
