On Sun, 7 Apr 2002, Onie Camara wrote: .. > > 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.
It's in the "fine" manual. It's quite easy. MySQL in verbose logging mode echoes ALL SQL statements it processes, to its logfile. The logfile goes to a pipe, which is connected to a MySQL client, which sends these SQL statements to a secondary MySQL. Obviously things like bulk loads won't get mirrored properly.. -- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc. _ 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]
