Tue Oct 8 00:20:40 PDT 2019
- Previous message: [Slony1-general] problem with lock on sl_log_x table in cleanupevent
- Next message: [Slony1-general] Is it safe to subscribe multiple slaves concurrently?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello!
We use Slony 2.1.4, with ~55 global slaves. Susbcribing [1] a node takes
from ~3minutes (a few milli seconds away) to 15 minutes (200ms away) -
one some minutes for the initial sync.
a) Is it safe to subscribe multiple nodes in parallel, or do I have to
subscribe them one after the other?
b) Why does it take so long to subscribe? Can I speed up the subscribe?
Thanks
Klaus
[1]
slonik <<_EOF_
cluster name = $CLUSTERNAME;
node 1 admin conninfo = 'dbname=...';
node $NODE admin conninfo = 'dbname=...';
# create node
store node(id=$NODE,comment='$SLAVEHOST node',event node=1);
# create paths
store path(server=1,client=$NODE,conninfo='dbname=...';
store path(server=$NODE,client=1,conninfo='dbname=...';
subscribe set ( id = 1, provider = 1, receiver = $NODE, forward = no);
_EOF_
- Previous message: [Slony1-general] problem with lock on sl_log_x table in cleanupevent
- Next message: [Slony1-general] Is it safe to subscribe multiple slaves concurrently?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list