RE: Replication talk.

2005-01-27 Thread Dathan Pattishall
://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 mast

Replication talk.

2005-01-27 Thread Frederic Trudeau
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