Re: MySQL & Web Clustering...

2004-06-22 Thread Terence
Apparently OpenMosix won't work with MySQL because MySQL uses Shared Memory. There is apparently a component called MAASK which might help. Roy Nasser wrote: Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize eve

Re: MySQL & Web Clustering...

2004-06-18 Thread Mike Miller
seamless. Would require some work to make one though. -Mike From: Jeff Smelser <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: MySQL & Web Clustering... Date: Fri, 18 Jun 2004 11:43:05 -0500 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Mi

Re: MySQL & Web Clustering...

2004-06-18 Thread Jeff Smelser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: > 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

Re: MySQL & Web Clustering...

2004-06-18 Thread Mike Miller
]> 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 so

Re: MySQL & Web Clustering...

2004-06-18 Thread Peter J Milanese
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 tho

Re: MySQL & Web Clustering...

2004-06-18 Thread Cemal Dalar
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 m