I am a MS SQL DBA/developer - zero expereince with MYSQL. I am trying to ascertain whether the follwing is posslbe and what the best approach would be.
We have a 2 box Windows (2k3) server cluster with attached SAN. We are currently runnnig MSSQL 2000 Enterprise (in a clustered configuration)
We are investigating the use of a new application that only supports a MYSQL database.
We need a high availabilty model (i.e. a cluster) - what are the options for clustering MYSQL?
Preferably, we'd like to find an "enterprise" version that can be clustered using MSCS - is there such a thing?
If not, then what s the best approach, bearing in mind that we already have the Windows Server cluster
From my intial reading it seems that MYSQL has it's own clustering model (which seems to use replication??)