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 the master. I will also keep in touch with MySQL Cluster development and probably go for this in the near future.
Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.gittigidiyor.com & http://www.dalar.net ----- Original Message ----- From: "Roy Nasser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 18, 2004 4:58 PM Subject: MySQL & Web Clustering... Hi All, 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 different services. 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 expandable. 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. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]