> (e) If you had just a one way master->slave relationship and you delete
> data on the slave, that is very bad. The slave is now not the same as
> the master, the record will not be re-inserted, if you go to update the
> record on the master, when the command gets replicated to the slave an
> err
(a) You are mistaken. You can easily setup both as masters and then as
slaves to each other. Simply enable the neccesary binary logging on
both sides, then use the CHANGE MASTER TO command to set each to point
at the other. Now when you do an insert or delete on either it gets
replicated to the
Hi
i'm using MySQL version 4.0.20d.
I was able to set up a simple replication between a master and a slave.
To fully understand the replication mechanism of MySQL i would like to ask
some questions (the manual does not answer all my questions):
(a) in 4.0.20d there is no way for a kind of Mas
