…. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…the task to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential… mean that if right now a node gets disconnected from the cluster, in order to join to the cluster again, it has to copy the whole data set …
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
…cluster and do not worry that eventually you get out-of-sync situation, as it regularly happens with regular MySQL…do read from the slave, you may read data, that has not changes yet. You can …two different nodes, the cluster will use an optimistic locking model. That means a transaction will not …
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
…. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona…
Post: Understanding Multi-node writing conflict metrics in Percona XtraDB Cluster and Galera
November 20, 2012 By 17 Comments
… that it is probably the best compromise for performance and data protection out there. There’s likely a lot more depth… fundamentally “virtually synchronous replication” means: Writesets (or “transactions”) are replicated to all available nodes in the cluster on commit (and enqueued on…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
With the recent release of Percona XtraDB Cluster, I am increasingly being asked about MySQL‘s semi-synchronous replication. I find that… guarantees against data loss. What do I mean by a strong guarantee against data loss? I consider the safety of my data strongly guaranteed… the MySQL manual. But read carefully, for example, the following sentences: When a commit returns successfully, it is known that the data…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
… it to identify and debug Percona XtraDB Cluster replication problem ? If you are using PXC, you… Those files correspond to a replication failure. That means the slave thread was not able to …mysql]# file GRA_3_3.log GRA_3_3.log: data [root@node2 mysql]# ls -l GRA_3_3.log -rw-rw—-. 1 mysql mysql…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… look at factors such as the variance-to-mean ratio, the Apdex score, and the explain …queries completed in a cluster. One-second granularity (what you get in standard MySQL) might be enough precision…second performance stalls we are interested in. Without data, you can only guess; and guessing ain’t …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… believe clustered indexes are becoming less relevant with the rise of Solid State technology. As random read access times decrease clustering of data… modifying any part of MySQL to make the engine work. This means that PBXT runs with the standard MySQL/MariaDB distribution. But this…
