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: 4805601195@uswestdatamail.com (100 chars) eMail: dwacks@interactcommerce.com