MySQL in Windows cluster

Posted on 2006-05-30
Last Modified: 2013-11-15
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??)
Question by:OctaviaIS
    LVL 19

    Accepted Solution

    Lots of detail here. No specific reference to cluster model. If you wade through the white paper or search the forum, you should get more detail.
    LVL 2

    Assisted Solution

    native MySQL Clustering, as available from 5.0, is only available in Linux.  You can perform 'kind-of' clustering using circular replication between windows boxes.

    Clustering in mySQL is a shared nothing architecture that uses it's own storage engine.  in 5.0 it's an in-memory data storage engine.  5.1 sees that moving to in-memory with a disk absed commit. Clustering uses network interconnects between storage nodes, and will automatically detect when nodes come online(5.1 and later) and offline.

    replication is simpler, in that it is a binlog of all update,insert and deletes performed against a database, and the slave database pulls that info and 'replicates' the queries.  Circular replication sees a master replicate to a slave, that then replicates back to the master, so you have (in effect) a 2 box cluster.  Replication doesn't have any way of knowing that the command has been completed on the slave.  Clustering looks for confirmation.

    MySQL Clustering is still very new, but well worth looking at, but as I said, it's only available with the linux distribution as far as I know.

    There is a company (continuum??) that provides a 3rd party, disk based MySQL clustering solution, but I know very little about it.



    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now