First, a thank you to everyone who attended the webinar Today, I appreciate your time and nice comments. As promised, here are answers to questions that couldn’t be answered during the talk: Q: How do you install the tools? The manual has full details, but it’s important to know that the latest release for [...]
Migrating several single standalone MySQL server to one Percona XtraDB Cluster… MariaDB to the rescue !
December 18, 2012 By 3 Comments
Some weeks ago I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) to a Percona XtraDB Cluster of 3 nodes. So the easiest way would be to configure each node to become also an asynchronous slave of one of the production servers. Like illustrated here: But in this [...]
Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding. They didn’t want to drop any actual data, and their index usage was fairly high, so we decided to look for unused indexes that could be removed. Collecting data It’s [...]
Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
Just yesterday I wrote about math of automatic failover today I’ll share my thoughts about what makes MySQL failover different from many other components and why asynchronous nature of standard replication solution is causing problems with it. Lets first think about properties of simple components we fail over – web servers, application servers etc. We [...]
Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
During the design period of a new cluster, it is always advised to have at least 3 nodes (this is the case with PXC but it’s also the same with PRM). But why and what are the risks ? The goal of having more than 2 nodes, in fact an odd number is recommended in [...]
Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
I am excited to announce the availability of the GA release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5.20. With this release we make clustering very easy and affordable for everyone. You can convert your existing [...]
Percona XtraDB Cluster 5.5.20 – Beta release
February 23, 2012 By 10 Comments
I am happy to announce the availability of beta release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and the beta release is based on Percona Server 5.5.20 and the recently released Galera 2.0 GA The main focus in this release: Incremental State Transfer, [...]
Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
I am happy to announce the availability of alpha release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and based on Percona Server 5.5.17 Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to [...]
Actively monitoring replication connectivity with MySQL’s heartbeat
December 29, 2011 By 2 Comments
Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master before abort the connection and establish it again. With a default value of 3600 this has been a historically [...]
Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
Statement based replication writes the queries that modify data in the Binary Log to replicate them on the slave or to use it as a PITR recovery. Here we will see what is the behavior of the MySQL when it needs to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll [...]
