The full schedule for Percona Live London 2014 was revealed earlier this month.
Congratulation to all selected speakers and a big thanks to those who submitted a talk.
I have many reasons to believe that this conference will be a very good year.
Let me explain why
Continue reading “Probably the best European conference on MySQL is coming this fall” »
You’ve probably had some troubles with the shared InnoDB tablespace stored in the ibdata file. Especially when it has grown for some reasons and reached a critical size.
This behavior occurs in some cases, due to excessive rollback segments growth or during a migration from a unique shared tablespace to a file-per-table configuration for example.
In this post, I would like to explain how to shrink the ibdata file after an unwanted file growth in a file-per-table configuration.
Note that the process could be done without Trite but the tool avoids to write the script used to transport tables yourself.
Continue reading “How to shrink the ibdata file by transporting tables with Trite” »
Disclaimer: I’m not specially an expert of benchmarking, this post is to compare different options. All comments and advices are welcome.
I’m not telling you anything new, the show processlist command is a fantastic command line tool for instant check.
But what about monitor your databases with this command embedded in a tool?
Continue reading “Time to forget <i>show processlist</i> for monitoring?” »
Call for papers for Percona Live London 2014 is open. For the fourth consecutive year, PLUK is going to be one of the best community event in Europe.
I have the honour of being conference committee chairman and the hard task to reviewing the talks with my colleagues of the committee.
Continue reading “Wake up European DBA, call for papers for Percona Live London 2014 is open!” »
The goal of this tutorial is to show you how to use Multi-Master and aggregate databases with the same name but with different data from different masters.
- master1 => a French subsidiary
- master2 => a British subsidiary
Both have the same database (PRODUCTION) but the data are totally different:
We will start with 3 servers (2 masters and 1 slave), you can add more master if needed.
Continue reading “[Tuto] A real life Multi-Master use case with MariaDB” »