On 10/25/06, Hanks, Dan <dhanks at corp.untd.com> wrote:
>
> Hi folks,
>
> I have a 3-node cluster: node1 replicates to node 2, which replicates to
> node 3.
>
> I would like to reverses that flow, such that node3 replicates to node2,
> which replicates to node1.
>
> Here's my plan, I'm hoping for some feedback on whether it will work or not.
>
> 1)       I run move set to move the origin from node 1 to node 3
> 2)       I run subscribe set to have node 2 pull updates from node 3
> 3)       I run subscribe set again to have node 1 pull from node 2.
>
> Will that work?

It should. However, why don't you

1) Subscribe 3 to 1
2) Subscribe 2 to 3
3) Move set to 3
4) Subscribe 1 to 2

Which will certainly get you the results you want, and in a very
predictable, easy to understand way.