Stuart Bishop has proposed merging lp:~stub/launchpad/replication into lp:launchpad.
Requested reviews: Stuart Bishop (stub) Related bugs: Bug #307407 in Launchpad itself: "slave database should never be used when lag is too great" https://bugs.launchpad.net/launchpad/+bug/307407 Bug #345835 in Launchpad itself: "Database load balancing should use slave lag, not cluster lag" https://bugs.launchpad.net/launchpad/+bug/345835 Bug #447453 in Launchpad itself: "Changes made through the API (via javascript) aren't blacklisting the Slave DBs" https://bugs.launchpad.net/launchpad/+bug/447453 Bug #461800 in Launchpad itself: "new-slave.py no longer works" https://bugs.launchpad.net/launchpad/+bug/461800 Bug #504696 in Launchpad itself: "Replication lag checks can block" https://bugs.launchpad.net/launchpad/+bug/504696 Bug #504751 in Launchpad itself: "Standalone slave not subscribed to the authdb replication set" https://bugs.launchpad.net/launchpad/+bug/504751 Bug #504807 in Launchpad itself: "authdb replication set sequence values not being restored on staging" https://bugs.launchpad.net/launchpad/+bug/504807 Bug #514267 in Launchpad itself: "InternalError on clusters under busy load" https://bugs.launchpad.net/launchpad/+bug/514267 Bug #1014661 in Launchpad itself: "Replication lag checks do not understand PG 9.1 streaming replication" https://bugs.launchpad.net/launchpad/+bug/1014661 For more details, see: https://code.launchpad.net/~stub/launchpad/replication/+merge/110801 = Summary = We are switching to PostgreSQL 9.1 streaming replication, and the mechanism to obtain replication lag of the slave database needs to be updated. == Proposed fix == == Pre-implementation notes == == LOC Rationale == Slony code will be dropped later, making a net LOC loss. == Implementation details == == Tests == == Demo and Q/A == = Launchpad lint = Checking for conflicts and issues in changed files. Linting changed files: lib/lp/services/webapp/dbpolicy.py configs/replicated-development/launchpad-lazr.conf -- https://code.launchpad.net/~stub/launchpad/replication/+merge/110801 Your team Launchpad code reviewers is subscribed to branch lp:launchpad. _______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp

