EmergencyEMERGENCY? Get 24/7 Help Now!

NDB tutorial at Percona Live London + Free TIcket Give Away

 | September 23, 2011 |  Posted In: Events and Announcements, MySQL

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 – […]

Read More

How to replace a NDB node on EC2

 | June 9, 2011 |  Posted In: MySQL

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 […]

Read More

A recovery trivia or how to recover from a lost ibdata1 file

 | June 3, 2011 |  Posted In: MySQL

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 […]

Read More

Impact of the number of idle connections in MySQL (version 2)

 | December 20, 2010 |  Posted In: Insight for DBAs, MySQL

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. […]

Read More

Impact of the sort buffer size in MySQL

 | October 25, 2010 |  Posted In: Benchmarks, MySQL

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 […]

Read More

High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script

 | October 22, 2010 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, MySQL

This post is the fifth of a series that started here. From the previous posts of this series, we now have an instance restart script that can restart the database node in case of failure and automatically reconfigure Pacemaker and the other servers that needs to access the MySQL server. What we will cover in […]

Read More