launchpad-reviewers team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

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.