You have to send the SELECT queries directly to the slaves. Your code must know to connect to an appropriate machine for the type of work it wants to do: If it's only reading data (SELECTs), it should connect to one of the slaves. If it must alter data (INSERT/UPDATE/DELETE) or must both read AND alter data then it must connect to the master.
-JF > -----Original Message----- > From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 1:48 AM > To: Jon Frisby > Cc: [EMAIL PROTECTED] > Subject: R: Mysql Replication > > > I want do build a mysql cluster. > > The master receive all queries. > > Then, the master write, update, delete, ecc.. > the slaves answer SELECTs > > If this is impossible, which is the utility to have slaves??? > > -----Messaggio originale----- > Da: Jon Frisby [mailto:[EMAIL PROTECTED]] > Inviato: mercoledì 20 novembre 2002 21.10 > A: Massimo Bandinelli > Oggetto: RE: Mysql Replication > > > No. Why would you wish to do so? > > -JF > > > -----Original Message----- > > From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 20, 2002 7:22 AM > > To: [EMAIL PROTECTED] > > Subject: Mysql Replication > > > > > > A question: > > > > I've a Mysql System with a Master and two slave. > > > > Can I configure my master to automatically forward the select > > queries to = > > the slaves? > > > > > > Massimo Bandinelli > > System Administrator > > ------------------------------------------------- > > Register.it S.p.A. - Gruppo DADA > > tel +39 199 REGIST (+39 199 734478) > > fax +39 035 3230312 > > http://we.register.it > > mailto:[EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
