On Mon, 8 Apr 2002, Horatio B. Bogbindero 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. > > > interesting orly. thanks for the information. how is this feature configured > are there any howtos or best practices documents lying around? very good > since most data access is SELECTs anyway.
it's in the MySQL manual. i think it's only supposed to be for mirroring (for backup purposes) to ONE secondary machine, but no reason why you can't daisy-chain. > does postgres have a similar feature? not that i know of.. as i said (and you prolly realize) MySQL's mirroring/hot sync functionality is an extremely ugly kludge. Maybe the Pg people didn't want to be "defiled" by such an ugly kludge. But it works! and has, for the past 4 years or so.. -- 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]
