Code review comment for lp:~stub/launchpad/auth-mirror-tables

Revision history for this message
Stuart Bishop (stub) wrote :

For Bug #489078.

We need to ship a copy of some of our tables to the login service database, so we can drop the lpmain replica from there.

This branch creates three new tables - lp_person, lp_personlocation and lp_teamparticipation. These tables are replicas of the person, personlocation and teamparticipation tables and maintained with database triggers.

The first DB patch will be applied before rollout, adding the tables to a new replication set.

The second DB patch inserts the initial data and adds the triggers, which will be done as a normal part of the rollout.

Flagging this as release critical in case deferring this to next cycle affects ISD's login service schedule adversely.

« Back to merge proposal