…(incremental state transfer) is not feasible. It also helps when node data integrity is compromised. So, naturally duration of SST is paramount. We recommend …PXC for its sync status. As referenced in that post, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference architecture with…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
Last week at Percona Live, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than… will not lead to inconsistencies, but that is beyond the scope of this post. Tuning flow control Flow control is triggered when a Synced node…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not…nodes in your cluster. Transaction apply on slave nodes is still asynchronous from client commit (except on the original node where the transaction is…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
… Percona XtraDB Cluster. It is recommended you get familiar with general architecture of the cluster,…node in your cluster and do not worry that eventually you get out-of-sync…Percona XtraDB Cluster provides it, and let’s see how it works. With our Cluster you can write to any node, and the Cluster…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…: text/plain Node is running. Same output on percona2 Now let’s check the status variables: | wsrep_local_state_comment | Synced (6) | | wsrep… the dead node comes back it will perform its IST or SST. In conclusion: 2 nodes cluster is possible with Percona XtraDB Cluster but it’s not advised…
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
…cluster nodes are not like traditional replicas. In this post I demonstrate how to use pt-table-checksum with Percona XtraDB Cluster. First, you’ll need Percona…until pt-table-sync is “PXC-approved” There are other limitations when using pt-table-checksum with Percona XtraDB Cluster Please submit …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…nodes. # yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install haproxy and sysbench on the client node…Percona XtraDB Cluster (GPL), wsrep_23.6.r340 120619 13:21:19 [Note] WSREP: Member 0 (ip-10-244-33-92) synced…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… (not semi-sync). Semi-sync Same as the control but with semi-sync enabled on the slave (slave was in the other colo). XtraDB Cluster 1… thread per node per test client. More on that in a future post. Conclusion Percona Xtradb Cluster and Galera on which it is based offers…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
…node. There is three methods of SST available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona XtraBackup with support of XtraDB Cluster…Node by using SHOW STATUS LIKE ‘wsrep_local_state_comment’, when it is ‘Synced (6)’, the node is…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… on not identical data, but you know that you do not have a consistent cluster in…Note] WSREP: Node 5 (node3) requested state transfer from ‘*any*’. Selected 0 (node1)(SYNCED) as donor… the node is ready and succesfully joins cluster. You may try it with the latest release Percona XtraDB Cluster…
