Drop echo tables from local wiki databases
Open, Needs TriagePublic

Description

The following tables:

echo_email_batch
echo_event
echo_notification
echo_target_page

Are used in x1 but not on local wikis (check this for the proof on dbstore2001: T54921#2880996) and then should be dropped from local wikis.

The following database on the other hand DO NOT USE x1, and need to be EXCLUDED from the list of wikis from where the tables need to be dropped.

mediawikiwiki
metawiki
officewiki
labswiki
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 19 2016, 10:22 AM

I will start by making sure they are indeed not written.
An easy test without messing up with production (and which is needed anyways to export x1 to dbstore2001 T151552)) will be to rename all those tables in dbstore2001 before dropping them, just to make sure RBR doesn't break because they are written somehow.

Marostegui moved this task from Triage to Next on the DBA board.Dec 19 2016, 10:25 AM

Note wikitech is not a database itself, in this context it is a database list containg labswiki and labtestwiki, hosted on silver and labtestweb2001 respectively

Marostegui updated the task description. (Show Details)Dec 19 2016, 10:30 AM

Note wikitech is not a database itself, in this context it is a database list containg labswiki and labtestwiki, hosted on silver and labtestweb2001 respectively

Thanks! I have edited the task description

Legoktm updated the task description. (Show Details)Dec 19 2016, 10:36 AM

I want to start working on this slowly in the background as doing T136428 was confusing and painful with so many echo tables that were all over the shards and not really needed.

in db2057 (s3) I have renamed all the echo tables to:

T153638_echo_xxxx

Just to make sure replication doesn't break, I will leave it like that for a few days before dropping them (after taking a backup)

Marostegui moved this task from Next to Backlog on the DBA board.Jul 12 2017, 7:38 AM