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 Percona Support team receives a request from a customer to assist in the configuration of [&]

The post mysqld_multi: How to run multiple instances of MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/26/mysqld_multi-how-to-run-multiple-instances-of-mysql/

In a previous post, my colleague Dimitri Vanoverbeke discussed at a high level the concepts of database as a service (DBaaS), OpenStack and OpenStack’s implementation of a DBaaS, Trove. Today I’d like to delve a bit further into Trove and discuss where it fits in, and who benefits. Just to recap, Trove is OpenStack’s implementation [&]

The post OpenStacks Trove: The benefits of this database as a service (DBaaS) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/25/openstacks-trove-the-benefits-of-this-database-as-a-service-dbaas/

In my last post, A closer look at the MySQL ibdata1 disk space issue and big tables, I looked at the growing ibdata1 problem under the perspective of having big tables residing inside the so-called shared tablespace. In the particular case that motivated that post, we had a customer running out of disk space in his [&]

The post When (and how) to move an InnoDB table outside the shared tablespace appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/22/when-and-how-to-move-an-innodb-table-outside-the-shared-tablespace/

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 theres a degree of regret by some of the InnoDB architects on their design decisions regarding disk-space management by the shared tablespace* because this has been a big [&]

The post A closer look at the MySQL ibdata1 disk space issue and big tables appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/21/the-mysql-ibdata1-disk-space-issue-and-big-tables-part-1/