No this is not a mysql option directly. Your going to have to change your database API level to write only to the master and read only from the slave. The only thing that mysql will do is enforce read only on a slave via GRANTS and write only on a master.
DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----Original Message----- > From: Frederic Trudeau [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 27, 2005 10:25 AM > To: mysql@lists.mysql.com > Subject: Replication talk. > > > Consider the simple case where we have a single master and a > single slave. > > Ideally, we would redirect all writes to the master server > only, and reads on the master AND the slave. > > Is it possible to redirect UPDATE, DELETE, INSERT queries > only on the master server automatically, and SELECT* on the > master and the slave ? Is this a MySQL configuration option > that I missed in the doc ? > > Any pointers would be appreciated. > > Thank you ! > > - > Frederic Trudeau <[EMAIL PROTECTED]> > Programmation / Departement reseau > Communications Accessibles Montreal > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
