On Sun, Apr 07, 2002 at 10:43:24PM +0800, Orlando Andico wrote (wyy sez): > On Sun, 7 Apr 2002, Horatio B. Bogbindero wrote: > .. > > MySQL does not come with clustering extensions. there is currently > > no way for example for make a MySQL query faster via some form of > > clustering technology. > > MySQL can do hot mirroring (via a dumb technology: verbose logging, the > log goes into a pipe, and the SQL statements are sent to a secondary > MySQL). > > Dumb as it sounds, this technique works. If you "daisy chain" 3 or 4 MySQL > servers, and on the web front end use some sort of round-robin for your > QUERIES ONLY (NOT the inserts/updates -- they have to go to the primary, > not the replicates) then you can speed up selects. >
Hi Orly, I like this approach but don't know where to get more information. Do you have any notes or links. Thanks in advance. Neil _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
