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


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??) 

MySQL in Windows cluster

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.