Christopher Browne cbbrowne at ca.afilias.info
Thu Feb 11 14:47:22 PST 2010
Melvin Davidson <melvin6925 at yahoo.com> writes:
> I have a question about logging behavior.
>
> Given that I have a master,  slave1 and a new slave2 to be subscribed.
>
> I will subscribe the new slave2 from slave1.
>
> If a lot of DML is occuring on the master, are the logs on the master (sl_log1
> & sl_log2) retained until slave2 has completed subscription, or will the master
> purge/truncate it's logs as slave1 acknowledges/SYNCs the changes?

The logs are held until receipt of the data has been confirmed (table
sl_confirm) by *all* nodes in the cluster.

So sl_log_1 and sl_log_2 data will hold up until the subscription has
completed, and the new node has confirmed that it has received all that
data.

We were careful about that :-).
-- 
output = reverse("ofni.sailifa.ac" "@" "enworbbc")
Christopher Browne
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"


More information about the Slony1-general mailing list