Hi Tim,
We use LVM snapshots all the time. They are essentially
instantaneous with our 90GB innodb database files.
A command to generate the snapshot could be:
sudo /usr/sbin/lvcreate --snapshot --name mysqlsqlbackup --size 15G /
dev/system/data01
Please let me know if you have any
Hi Mike,
The way we do it is installing each mysql instance from a
precompiled binary.
So if you had an 8 core box, and you wanted to use each of the 8
cores, you could install a mysql binary installation and then make 7
copies of it. We use an internal naming convention like the