| jcrespo | |
| Jan 17 2023, 10:13 AM |
| F36563448: Screenshot_20230131_110804.png | |
| Jan 31 2023, 10:08 AM |
| F36563439: Screenshot_20230131_104501.png | |
| Jan 31 2023, 9:45 AM |
| Restricted File | |
| Jan 25 2023, 4:15 PM |
| F36494349: Screenshot_20230125_154309.png | |
| Jan 25 2023, 2:49 PM |
The following hosts:
Are an expansion of the existing dbprov[12]00[1-3] cluster, intended to implement streaming backups (binlog backups) for point in time recovery. See more at https://wikitech.wikimedia.org/wiki/MariaDB/Backups
These new hosts will not be dedicated to binlogs, existing backups will be reshuffled over the existing hosts evenly, and binlogs will be downloaded local to the existing backups, so later automated PITR can be implemented.
Change 880896 had a related patch set uploaded (by Jcrespo; author: Jcrespo):
[operations/puppet@production] dbbackups: Setup dbprov1004, dbprov2004 as empty dbprov
Change 880896 merged by Jcrespo:
[operations/puppet@production] dbbackups: Setup dbprov1004, dbprov2004 as empty dbprov
Change 881360 had a related patch set uploaded (by Jcrespo; author: Jcrespo):
[operations/puppet@production] dbbackups: Reorganize backups with the new dbprov[12]04 host
Change 881868 had a related patch set uploaded (by Jcrespo; author: Jcrespo):
[operations/puppet@production] dbbackups: Setting up grants for new dbprov hosts
Change 881868 merged by Jcrespo:
[operations/puppet@production] dbbackups: Setting up grants for new dbprov hosts
Mentioned in SAL (#wikimedia-operations) [2023-01-20T18:22:32Z] <jynus> deploying new grants for backups on m1 T327155
Mentioned in SAL (#wikimedia-operations) [2023-01-24T18:55:24Z] <jynus> deploy new dump grants for analytics dbs at db1108 T327155
Change 881360 merged by Jcrespo:
[operations/puppet@production] dbbackups: Reorganize backups with the new dbprov[12]04 host
Change 883834 had a related patch set uploaded (by Jcrespo; author: Jcrespo):
[operations/puppet@production] dbbackups: Optimize execution time and delay backups
Change 883834 merged by Jcrespo:
[operations/puppet@production] dbbackups: Optimize execution time and delay backups
Change 883857 had a related patch set uploaded (by Jcrespo; author: Jcrespo):
[operations/puppet@production] dbbackups: Reorganize backups to avoid overload
Change 883857 merged by Jcrespo:
[operations/puppet@production] dbbackups: Reorganize backups to avoid overload
Mentioned in SAL (#wikimedia-operations) [2023-01-30T09:29:01Z] <jynus> disabling puppet on dbprov2004 to reorganize partitions T327155
Running multiple times without issue so far, more optimizations could be done, but so far, let's consider the scope done.
