I'm currently evaluating ways to increase our online storage capacity for our
DB engine. The current winner is a massive external SAN/disk array.
However, I'm wondering how MySQL will handle failover when it comes to InnoDB
tablespaces.
The current plan, based on the disk array, is to have each of the DB engine
servers attached to the same disk array. Server 1 is 'hot' and has the disk
array mounted, and thus creates all of the InnoDB table spaces etc. Should
it fail for whatever reason, Server 2 takes over as hot (based on linux-ha),
mounts the array, fires up MySQL and keeps on going. I am aware of MySQL
cluster, but currently do not have the hardware budget to accomodate the
requirements of Cluster.
Will the InnoDB engine on Server 2 have any issues with Server 1 creating the
table space?
| Thread |
|---|
| • Two servers, one InnoDB area? | Duncan Hill | 18 Apr |