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. .. > 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]
