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 [...]
About Yves Trudeau
Yves is a Principal Consultant at Percona, specializing in technologies such as MySQL Cluster and DRBD. He was previously a senior consultant for MySQL and Sun Microsystems. He holds a Ph.D. in Experimental Physics.
Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 91 Comments
NDB tutorial at Percona Live London + Free TIcket Give Away
September 23, 2011 By Leave a Comment
In a month, the 24th of October, Johan Andersson (severalnines.com) and I will be giving a full day tutorial on NDB cluster which will include both presentations and hands-on. Be ready for a fast ramp-up on NDB! Among items covered: – Achitecture – Installation – Loading data – Administration (common procedures) – Node recovery – [...]
How to replace a NDB node on EC2
June 9, 2011 By 9 Comments
NDB cluster is a very interesting solution in term of high availability since there are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would think that it is a good fit. It is indeed a good fit but reality is a bit trickier. The [...]
A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
A few day ago, a customer came to Percona needing to recover data. Basically, while doing a transfer from one SAN to another, something went wrong and they lost the ibdata1 file, where all the table meta-data is stored. Fortunately, they were running with innodb_file_per_table so the data itself was available. What they could provide [...]
High availability for MySQL on Amazon EC2 – Part 6 – Publishing server location
February 16, 2011 By Leave a Comment
This post is the sixth of a series that started here. From the previous posts of this series, we now have an HA MySQL service running on EC2. We now need to find a way to point the web servers or application servers to the HA MySQL service. Normally, in an HA setup, this is [...]
High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script
February 15, 2011 By 3 Comments
This post is the fifth of a series that started here. From the previous posts of this series, we now have nearly everything setup, only a few pieces are missing. One of the missing pieces is the Pacemaker script that run on the MySQL instance.
Upcoming Webinar on HA solutions for MySQL
January 7, 2011 By 1 Comment
On January 31st, I’ll be giving a webinar whose title is “Choosing a High-Availability Solution”. Although the subject is not new, we keep receiving many questions regarding HA and MySQL so we thought it would be a good idea to present a webinar on the topic. The content will be a revised version of the [...]
Impact of the number of idle connections in MySQL (version 2)
December 20, 2010 By 6 Comments
Last Friday I published results of DBT2 performance while varying the number of idle connections here, but I had compiled MySQL with the debugging code enabled. That completely screw up my results, be aware… debug options have a huge performance impact. So, I recompiled Percona-Server 11.2 without the debug options and did another benchmark run. [...]
Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
Be careful with my findings, I appear to have compile in debug mode, I am redoing the benchmarks. Updated version here. I recently had to work with many customers having large number of connections opened in MySQL and although I told them this was not optimal, I had no solid arguments to present. More than [...]
Impact of the sort buffer size in MySQL
October 25, 2010 By 7 Comments
The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is a per session buffer that is allocated every time it is needed. The problem with the sort buffer comes from the way Linux allocates memory. Monty Taylor (here) have described the underlying issue in detail, but basically above [...]
