by Fernando Laudares Camargos | Oct 21, 2014 | MySQL, Percona Software
I reckon there’s little sense in running 2 or more Percona XtraDB Cluster (PXC) nodes in a single physical server other than for educational and testing purposes – but doing so is still useful in those cases. The most popular way of achieving... by Fernando Laudares Camargos | Aug 29, 2014 | MySQL, Percona Services, Percona Software
I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses.)The customer mentioned they... by Fernando Laudares Camargos | Aug 26, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the... by Fernando Laudares Camargos | Aug 21, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Services
A recurring and very common customer issue seen here at the Percona Support team involves how to make the ibdata1 file “shrink” within MySQL. I can only imagine there’s a degree of regret by some of the InnoDB architects on their design... by Fernando Laudares Camargos | Jun 26, 2014 | MySQL, Percona Software
My previous post was an introduction to the TokuDB storage engine and aimed at explaining the basics of its design and how it differentiates from InnoDB/XtraDB. This post is all about motivating you to give it a try and have a look for yourself. Percona Server is... by Fernando Laudares Camargos | Jun 23, 2014 | Insight for DBAs, MySQL, Percona Software
During last April’s Percona Live MySQL Conference and Expo, TokuDB celebrated it’s first full-year as an open source storage engine. I still remember reading the official announcement and the expectations it created one year ago. The premises were... by Fernando Laudares Camargos | Jan 14, 2014 | Insight for Developers, MySQL
UPDATED: explaining the role of innodb_strict_mode and correcting introduction of innodb_file_formatCompressed tables is an example of an InnoDB feature that became available with the Barracuda file format, introduced in the InnoDB plugin. They can bring significant...