Go for a simple MySQL master <-> slave configuration. I'm runing 1
master 3 slaves for performance issues and doesn't have any problem at all
for 1 year.. Of course in this case you should change some code in your
webservers to direct SELECT queries to slave machine to gain performance on
I will also keep in touch with MySQL Cluster development and probably go
for this in the near future.
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
----- Original Message -----
From: "Roy Nasser" <rnasser@stripped>
Sent: Friday, June 18, 2004 4:58 PM
Subject: MySQL & Web Clustering...
We have recently acquired some new machines for our ASP service, and I
am investigating different options and setups to optimize everything.
We currently have one large DB server, with RAID5, etc, running mysql
and a few smaller servers for web applications, and e-mail. These
smaller servers arent all identical in their software, and they run
We currently have reached a certain limit in the DB as well as in some
of our applications on the webservers, hence the need for something
I have read slightly about MySQLCluster, as well as some other solutions
such as openMosix, Mosix and LVS. I was wondering if you guys have
experience, and what you would recommend for the DB and for the
webservers. I still want to maintain them separate, even if I end up
having 2 different clusters, I prefer to keep the DB away from the
application for security reasons.