MySQL Clustering and Replication

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: dwacks@interactcommerce.comdwacksinteractcommerce.com
Date:  
Subject: MySQL Clustering and Replication
Hi,

I was wondering if you had set up a MySQL clustering solution. I found the
MySQL Clustering Toolkit: http://prometheus.zerodivide.net/mysql_cluster/
Have any of you used it?
I found a recommended best way for replication is that one server is used
for INSERT / UPDATE / DELETE, while others are used replicated from this
one, and all are used for queries.
What about service availability and load balancing issues?

I am looking for some input on the best solution to implement this:
Hardware/OS/configuration

We have a layer 4 switch that allows us to load balance among several
servers. I think setting up a master server then several slaves that are
clustered. This allows us to connect via the layer4 IP/Name which would
redirect to one of the slave servers.

Any ideas or help would be appreciated.

________________________________________________________________
David C.Z. Wacks    Website Manager
                    Interact Commerce Corporation
Phone:   480 368-3806                  8800 N. Gainey Center Drive
         800 555-4424 x 3806           Suite 200
FAX:     480 315-3121                  Scottsdale, AZ  85258
Mobile:  480 560-1195                  480.368.3700
Pager:   602 340-2218
Text:    (100 chars)
eMail: