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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]