Tory M Blue tmblue at gmail.com
Sun Oct 9 14:42:51 PDT 2016
I currently have a setup like this

Node:
1  primary
2  secondary
3 query
4 query
5 query
11 secondary
12 secondary
13 query
14 query
15 query

Replication is like this

Masternode=1

1 -> 2
2 -> 11 3 4 5
11 -> 12
12 -> 13 14 15

I'm going to switchover between 1 and 11

So switchover would mean node 1 becomes secondary and node 11 becomes
primary.  However as noted above currently 2 is talking to 11, 1 is not
replicating directly to 11 as 2 is doing the wide area replication to 11..

So do I have to subscribe 11 to node 1 prior to trying this switchover? How
is switchover handled if I don't , since data in 2 could not be 100% up to
date (1000ms delay) when the command is triggered, so 1 would have to
finish it's replication to 2 and 2 to 11, before 1 gave the sets to 11?

Also when I tear down the primary site (completely) how do I move, promote,
migrate the masternode (right now the config sees the masternode as 1, but
when I drop 1-5 at some point from 11/12, I don't have a masternode 1
anymore, so how do I configure the system to treat 11 as masternode?

Thanks
Tory
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20161009/3e38b823/attachment.htm 


More information about the Slony1-general mailing list