Thu Feb 11 14:47:22 PST 2010
- Previous message: [Slony1-general] Question about logging behavior
- Next message: [Slony1-general] Problems configuring Slony-I Replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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"
- Previous message: [Slony1-general] Question about logging behavior
- Next message: [Slony1-general] Problems configuring Slony-I Replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list