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