… presumably busier with more writes coming from more nodes), the more leeway each node will get to be a bit further behind… you only write to a single node in PXC, then it is recommended you disable this feature by setting fc_master_slave… tell if and when flow control is happening and what node (or nodes) are causing it. Using myq_gadgets, I can easily…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… our software repositories. New Features: Percona XtraDB Cluster has implemented initial implementation of weighted quorum. Weight for node can be assigned via…. Bug fixed #1084702 (Seppo Jaakola). In case two nodes in a 3-node cluster had to abort due to inconsistency, one wouldn’t correctly notify the surviving node which would lead to surviving node to loose the primary component and cause subsequent…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… Percona XtraDB Cluster nodes as workaround. Note that with the latter, make sure to not forget turning the feature back on when you switch to the new cluster especially if you are planning to write on multiple nodes. Have…, and because cluster performance is somewhat dependent on the slowest node – this overhead can easily become visible on the whole cluster…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… QPI bandwidth, and the third one features even higher QPI speed (and thus, faster inter-process/node communication). Results: First of all… chart shows a results comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises here… consistent with what we saw previously. Note that the single-node configuration used 16 threads (8 cores on a single socket…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… in the past that, in absence of a ‘SKIP LOCKED’ feature, would use READ-UNCOMMITTED to find which rows that had…. This type of system simply won’t work across multiple nodes in Galera, however. @Bill — is this the kind of thing…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… posts I am going to cover main features of Percona XtraDB Cluster. The first feature is High Availability. But before jumping to… put read queries to any of the nodes Drawbacks: Overhead of joining new node. The new node has to copy full dataset from… it was down. This is done using caching mechanism on nodes. Each node contains a cache, ring-buffer, (the size is configurable…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
This is about the second great feature – Multi-Master replication, what you get with Percona XtraDB Cluster. … imprudently write to the wrong server. This is long-waited feature, I’ve seen growing demand for it for last two… serious implication. If you run write transactions to two different nodes, the cluster will use an optimistic locking model. That means…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… to recovery a node and bring it back to the cluster with an incremental transfer after a crash. This feature was available… methodology can be used if to restore nodes from backup. We can start all nodes from an identical starting position, so they…: ready for connections. So what happens there? Basically at start node detects that the last transaction had GTID: 50176f05-69b5-11e2…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… feature request for the Galera team: provide the ability for incremental node provisioning. By this I mean that if right now a node… with Percona XtraBackup and its incremental backup features, it is possible to have incremental node provisioning. To finalize this post, let me…. Standard InnoDB is seriously behind InnoDB-plugin in terms of features and performance. Update (6-Jun-2011): It was my misunderstanding…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… layer, Heartbeat and the resources manager, Pacemaker. A key new features that has been added to Pacemaker recently, a Clone resources… this feature to start the data nodes. If after a major outage, only one of the physical host where the data nodes are located comes up, the cluster will start. The other features of Pacemaker that I need…
