Re: Some basic and advanced replication questions

2004-10-13 Thread Gary Richardson
> (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

Re: Some basic and advanced replication questions

2004-10-13 Thread John McCaskey
(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