Re: Using Mysql functions in INSERTS and UPDATES in replication setup

2003-11-27 Thread Victoria Reznichenko
"Arnoud Witt (Marktplaats)" <[EMAIL PROTECTED]> wrote: > We are using Mysql with one master and several slaves. > > In some INSERT and UPDATE queries we use Mysql functions like CURDATE() = > and > RAND() . > > The problem that now occurs is that if a slave is reading the queries = > from > the b

Using Mysql functions in INSERTS and UPDATES in replication setup

2003-11-27 Thread Arnoud Witt \(Marktplaats\)
We are using Mysql with one master and several slaves. In some INSERT and UPDATE queries we use Mysql functions like CURDATE() and RAND() . The problem that now occurs is that if a slave is reading the queries from the binary log, the resulting data is different from that on the master, because o