Re: Replicating -- sort of 2 way

2006-08-06 Thread Michael Loftis
--On August 6, 2006 2:01:15 PM -0700 Enrique Sanchez Vela <[EMAIL PROTECTED]> wrote: One thing that you could do, is to setup a replicating slave server, freeze the replication, perform backups (to tape/disks etc), then re-enable the replication activity, this way you provide a non-stop serv

Re: Replicating -- sort of 2 way

2006-08-06 Thread Chris W
Enrique Sanchez Vela wrote: Chris, Replicating for the sake of backups is in general a bad idea, since once you delete/update a record, it will be automatically propagated to the slave server. Replication, should be used to provide better availabilty/load balancing but that would need to be se

Re: Replicating -- sort of 2 way

2006-08-06 Thread Enrique Sanchez Vela
Chris, Replicating for the sake of backups is in general a bad idea, since once you delete/update a record, it will be automatically propagated to the slave server. Replication, should be used to provide better availabilty/load balancing but that would need to be setup as part of a bigger plan to

Replicating -- sort of 2 way

2006-08-06 Thread Chris W
Before I go reading too deep into the documentation I would like to know if this is even possible or if it is just a bad idea. I have Server A with DB X, and server B with DB Y. I would like to set up Server A and B as both a replication master and slave. Where Server A would be the Master f