multiple mySQL data directories?
Posted on 2013-02-03
I would like to use multiple data directories. Right now my.ini points to a single d:\mysqldata directory.
I would like to do something as in Microsoft SQLServer that allows storing database files anywhere (e.g. d:\sqldata, e:\sqldata, f:\sqldata).
Why? I have many large (5Gb+) mySQL databases. SSD is the way to go, but drives bigger than 128G are for now expensive. Plus a single point of failure for all the databases...
So I would like to add 128G SSD drives in my Windows machine, as I do in my SQL Servers.