There and in coming posts I am going to cover main features of Percona XtraDB Cluster. The first feature is High Availability. But before jumping to HA, let’s review general architecture of the Percona XtraDB Cluster. 1. The Cluster consists of Nodes. Recommended configuration is to have at least 3 nodes, but you can make [...] [...more]
There and in coming posts I am going to cover main features of Percona XtraDB Cluster. The first feature is High Availability. Bit before jumping to HA, let’s review general architecture of the XtraDB Cluster. 1. The Cluster consists of Nodes. Recommended configuration is to have at least 3 nodes, but you can make it [...] [...more]
One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during peak times. This is a high number by any account. When a new connection to MySQL is made, it can go into the back_log, which effectively serves as a queue for new connections on operating [...] [...more]
Over the last year, the frustration of many of us at Percona regarding issues with MMM has grown to a level where we started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its communication layer, so instead of reinventing a flat tire, we decided, Baron [...] [...more]
I again work with the system which needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and the system was built using multiple tables. Using multiple key caches was the good solution at that time and we could get over 200K of inserts/sec. [...] [...more]
