Hi Christopher!
Am 08.10.2019 um 18:03 schrieb Christopher Browne:
On Tue, 8 Oct 2019 at 03:20, Klaus Darilion
<klaus.mailingli...@pernau.at <mailto:klaus.mailingli...@pernau.at>>
wrote:
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.
b) Why does it take so long to subscribe? Can I speed up the
subscribe?
Well, the process involves:
a) Copying all of the data in the replication set, and
b) Regenerating all of the indexes on the tables (as it is almost
always faster to deactivate indexes while doing the COPY)
As far as I understand adding a node involves 2 steps:
1. Slony configuration via slonik "subscribe". This configures the
cluster and creates the slony namespace on the slave.
2. Initial sync: COPY the respective tables and sequences from the master
The initial sync (2) is actually fast, except there is low bandwidth to
the slave. But the "subscribe" (1) is slow for far away nodes (in terms
of RTT).
regards
Klaus
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general