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.
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_teamparticip ation. 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.