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. > 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.
does postgres have a similar feature? thanks for the correction. > .. > > if you have the money buy oracle. > > Forget about it. > > A lot of people throw out statements like that "if you have the money buy > Oracle" but in reality.. totally different thing. > > perspective: Oracle8i EE on a single processor will set you back maybe 2M > pesos. > > ***and that does not include the Oracle Parallel Server option*** > > i've never tried OPS because i haven't needed it, it's really Black Magic > Complicated, and i dont have a license for it. but OPS (AFAIK) costs even > more than the base Oracle8i EE. that gives an idea of the *massive money* > you need if you want OPS. > > > -- > 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] -- -------------------------------------- William Emmanuel S. Yu Ateneo Cervini-Eliazo Networks (ACENT) email : wyy at admu dot edu dot ph web : http://CNG.ateneo.net/wyu/ phone : 63(2)4266001-4186 GPG : http://CNG.ateneo.net/wyu/wyy.pgp War spares not the brave, but the cowardly. -- Anacreon
msg15705/pgp00000.pgp
Description: PGP signature
