MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Chained replication
Posted by: J.F. Gratton
Date: October 23, 2011 04:39AM

Hi,

I was wondering if this kind of setup is possible, and if so, how to implement it ?

Let's say I have two databases (DB1 and DB2), and four servers (SrvA, SrvB, SrvC, SrvD), across multiple OSes (OS1, OS2, OS3). I think the OS doesn't matter much unless there is some kind of config tweak to apply that I'm unaware of.

So, I want DB1 which is on SrvA, to be replicated on SrvB, and then I want SrvB to replicate it on SrvC, and finally SrvC to replicate it on SrvD.

For DB2 I want something else. I want DB2 to be replicated from SrvA to SrvB and SrvD simultaneously, and then from SrvB or SrvD (depending on server availability), replicated to SrvC.

The sequencing is important as not all servers are available at the same time (uptime & connectivity requirements are different for each server).

Is what I'm asking possible in the first place ?

OSes are linux (SrvA, SrvC), OpenIndiana (SrvB), Windows (SrvD).

Thanks,

-- Jeff

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Chained replication
2002
J.F. Gratton
October 23, 2011 04:39AM
Re: Chained replication
1075
Rick James
October 24, 2011 08:21AM
Re: Chained replication
927
J.F. Gratton
October 24, 2011 01:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.