Currently we have one database cluster with 15 different schemas – these schemas could be either schemas which contain “real” data, or just schemas with metadata.
I guess the next evolutionary step of our database stack would be to split up the database cluster vertically along these schemas. All the data schemas should be moved to standalone mysql instances, and put the metadata schemas next to them. This also could be a good project for prepare to move a certain part of database for example to a cloud provider while other parts are still kept on bare metal.
I started wondering what could be the best way to split MySQL instances in a single hardware. I have the following ideas:
- Hack init scripts to start different instances on different ports (and log directories, data directories, config files too)
- Use mysqld_multi
- Use MySQL Sandbox
- Use docker
The first …[Read more]