Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request.
-Mike
From: "Peter J Milanese" <[EMAIL PROTECTED]> To: "Roy Nasser" <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: MySQL & Web Clustering... Date: Fri, 18 Jun 2004 11:25:45 -0400
I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month.
Good points about LVS are that it is completely rock solid, and runs on minimal hardware.
I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out though. I would think that instead of LVS Load Balancing, server failover might be a more viable path for MySQL.
P
"Roy Nasser" <[EMAIL PROTECTED]> 06/18/2004 01:58 PM
To: <[EMAIL PROTECTED]> cc: 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]
_________________________________________________________________
MSN Premium with Virus Guard and Firewall* from McAfeeŽ Security : 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]