kevin kempter kevin at kevinkempterllc.com
Sat Aug 2 16:33:18 PDT 2008
Hi All;

I setup a single master & slave like this:

- I did a pg_dump from the master to the slave

- set the cluster name

- init cluster ( id=1, comment = 'Master Node');

- create set ( id=1, origin=1, comment = 'PA REPLICATION SET' );

- ran all the 'set add table' commands

- store node (id=2, comment = 'Slave Node 1');

- store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME  
host=$MASTERHOST port=$MASTERPORT user=$REPUSER');

- store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME  
host=$SLAVEHOST port=$SLAVEPORT user=$REPUSER');

- store listen (origin=1, provider = 1, receiver =2);

- store listen (origin=2, provider = 2, receiver =1);

- started the slon daemon on the master:
slon $CLUSTERNAME "dbname=$MASTERDBNAME port=$MASTERPORT host= 
$MASTERHOST user=$REPUSER"  > ./slon.master.log 2>&1 &

- started the slon daemon on the slave

- subscribe set ( id = 1, provider = 1, receiver = 2, forward = no);


Now I want to add 2 more slaves, I plan to run this:

- do a pg_dump from the master to slaves 3 & 4

- store node (id=3, comment = 'Slave Node 2');

- store node (id=4, comment = 'Slave Node 3');

- store path (server = 1, client = 3, conninfo='dbname=$MASTERDBNAME  
host=$MASTERHOST port=$MASTERPORT user=$REPUSER');

- store path (server = 3, client = 1, conninfo='dbname=$SLAVEDBNAME  
host=$SLAVEHOST port=$SLAVEPORT user=$REPUSER');

- store path (server = 1, client = 4, conninfo='dbname=$MASTERDBNAME  
host=$MASTERHOST port=$MASTERPORT user=$REPUSER');

- store path (server = 4, client = 1, conninfo='dbname=$SLAVEDBNAME  
host=$SLAVEHOST port=$SLAVEPORT user=$REPUSER');

- store listen (origin=1, provider = 1, receiver =3);

- store listen (origin=3, provider = 3, receiver =1);

- store listen (origin=1, provider = 1, receiver =4);

- store listen (origin=4, provider = 4, receiver =1);

- Start the slon daemon on slaves 3 & 4

- subscribe set ( id = 1, provider = 1, receiver = 3, forward = no);

- subscribe set ( id = 1, provider = 1, receiver = 4, forward = no);



Is this correct, or am I missing something here?


Thanks in advance

/Kevin





More information about the Slony1-general mailing list