Maybe I'm not understanding how replication is supposed to work, but I've found a situation where it definitely does not log changes. I'd just like to know if this is normal or not. Say you have two databases (call them data1 and data2) on your master server. Only data1 is being replicated. Within the mysql client, connecting to the master machine: use data2 /* this database is NOT being replicated */; update data1.table set somefield=1 where somevalue=1; The data changes properly in the master, but does not get replicated to any slaves. simply doing this: use data1 update table set somefield=1 where somevalue=1; works as expected. Any comments?
