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]

Reply via email to