|
I'm guessing it wouldn't work properly, since the binlog position on
the master/slave need to be synchronized, or it will stop replicating
or fail for some other reason. You might have master1<->slave working
fine, but if it reads from master2 for some reason it might have a
small amount of replication lag, and then bam - it'll break.
On 1/10/06, Brent Jensen <brent@xxxxxxxxxxx> wrote:
> My current MySQL configuration uses a master-master replication setup for
> failover (using a VIP). I now need to move the application reads off to
> another server. This could be accomplished by moving the reads to the
> non-master server; however, I would like to place an additional slave
> server off the current master.
>
> The Question: Can the slave server (not the slave in the master-master
> server) be replicated off of the master-master VIP? I know how to do it off
> of the current master (non-vip); however, if using the VIP what happens if
> the VIP switches to the failover slave (now master)? I'm guessing the
> replication would get confused since it might not be queuing off of the
> right replication info. Is this correct or am I missing something?
>
> M -- VIP -- M
> |
> |
> S
>
> Has anyone run into this scenario? Suggestions?
>
> Thanks,
>
> Brent
>
> _______________________________________________
> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
|
