On October 7, 2009, Stuart Bishop wrote:
> I believe this behavior stops being a problem if we move the master for
> the auth replication set to a dedicated server that does not have a
> replica of the lpmain replication set.
>
> In this setup, the authdb tables will get locked on the Launchpad
> databases (launchpad_prod*). They will not be locked on the standalone
> database used for read only mode, as it is stand alone. They will not be
> locked on the authdb replication set master as there is no lpmain
> replica there.
>
The plan was to still have a replica of the lpmain replication set on the auth
master DB. Otherwise, we'll need to set-up another separate launchpad replica
for the ShipIt/OpenID servers.
On October 7, 2009, Stuart Bishop wrote:
> I believe this behavior stops being a problem if we move the master for
> the auth replication set to a dedicated server that does not have a
> replica of the lpmain replication set.
>
> In this setup, the authdb tables will get locked on the Launchpad
> databases (launchpad_prod*). They will not be locked on the standalone
> database used for read only mode, as it is stand alone. They will not be
> locked on the authdb replication set master as there is no lpmain
> replica there.
>
The plan was to still have a replica of the lpmain replication set on the auth
master DB. Otherwise, we'll need to set-up another separate launchpad replica
for the ShipIt/OpenID servers.
--
Francis J. Lacoste
<email address hidden>