Will Analytics handle this?
I would suggest to rename the tables on all the hosts and leave them with a different name before dropping them, to make sure nothing breaks.

As per the backups...I am fine with whatever you guys think it is the right way to proceed.

Sure we can handle it, renaming sounds good. As far as I can understand dropping the renamed table after some days seems the best option.

In T171883#3485110, @elukey wrote:

Sure we can handle it, renaming sounds good. As far as I can understand dropping the renamed table after some days seems the best option.

Yep, renaming it, it is a quick way of checking if something is really using it before it is too late. If nothing breaks in 2-3 days you can probably go ahead and drop the renamed tables.
If something breaks while renamed, it just needs to be renamed back to its original name

Mentioned in SAL (#wikimedia-operations) [2017-08-01T12:04:49Z] <elukey> stop eventlogging_sync on analytics-slaves && rename all CookieBlock* tables (log db) to CookieBlock*_backup - T171883

Action executed on db1046 (m4-master):

MariaDB [(none)]> use log;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [log]> rename table CookieBlock_16046548 to CookieBlock_16046548_backup;
Query OK, 0 rows affected (0.11 sec)

MariaDB [log]> rename table CookieBlock_16241436 to CookieBlock_16241436_backup;
Query OK, 0 rows affected (0.02 sec)

MariaDB [log]> rename table CookieBlock_16241436_15423246 to CookieBlock_16241436_15423246_backup;
Query OK, 0 rows affected (0.02 sec)

MariaDB [log]> show tables like 'Cookie%';
+--------------------------------------+
| Tables_in_log (Cookie%)              |
+--------------------------------------+
| CookieBlock_16046548_backup          |
| CookieBlock_16241436_15423246_backup |
| CookieBlock_16241436_backup          |
+--------------------------------------+
3 rows in set (0.00 sec)

MariaDB [log]> select count(*) from CookieBlock_16046548_backup union select count(*) from CookieBlock_16241436_backup union select count(*) from CookieBlock_16241436_15423246_backup;
+----------+
| count(*) |
+----------+
|      310 |
| 15771712 |
|      988 |
+----------+

Same to db047 and dbstore1002. If nothing explodes during the next two days I'll drop them :)

Mentioned in SAL (#wikimedia-operations) [2017-08-03T13:28:43Z] <elukey> drop CookieBlock backup tables for T171883

Anything pending here?