Page MenuHomePhabricator

[toolsdb] Copy s51698__yetkin.wanted_items on the replica from the primary
Closed, DeclinedPublic

Description

Hi!

@Superyetkin due to some replication issues we will need to do a manual copy of this table from the primary DB to the secondary, but while doing this copy there should not be any writes to this table.

The copy might take some time (as this table is quite big, currently >1M rows).

Is there any window of a couple days that we can use to do this copy?
Once we have that window I'll take care of the rest, you'll just make sure there's no writes happening.

The risk here is mostly for backup, so if anything irreversible happens to the primary (unlikely), we will not have a copy of the table to restore from until we do this procedure.

Thanks!

Notes:

Event Timeline

dcaro updated the task description. (Show Details)

The dataset is refreshed every 24 hours, so that is the window we can use.

fnegri changed the task status from Open to Stalled.Aug 22 2023, 3:14 PM
fnegri subscribed.

Thanks @Superyetkin, I think I will try to create a new replica from scratch instead, as this is a procedure I wanted to test anyway: T344717.

In case that procedure proves harder/longer than expected, we can revert to @dcaro's plan to manually copy only your database.

I will keep this task open in the meantime, but no action is required.

The new replica tools-db-3 is live and includes all tables, so this task is no longer required.