Currently our replicas do not use postgres replication slots. This means that during adverse conditions (such as imposm imports) we have hosts drop out of replication quite frequently.
Reparenting them can be a frustrating and time consuming activity and using replication slots will hopefully help us avoid these issues.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T321959 Tech Wishes - Maps service infrastructure deprecations | |||
| Resolved | None | T316365 Restore the map data health and parity between clusters | |||
| Resolved | awight | T321722 Look into the replica sync fails | |||
| Resolved | • ssastry | T263854 [Maps] Modernize Vector Tile Infrastructure | |||
| Resolved | jijiki | T290149 Configure replication slots on Postgres masters |
Change 755959 had a related patch set uploaded (by Hnowlan; author: Hnowlan):
[operations/puppet@production] postgres: add option to enable replication slots
Change 755959 abandoned by Hnowlan:
[operations/puppet@production] postgres: add option to enable replication slots
Reason:
Implemented in 854563
Change 857067 had a related patch set uploaded (by Effie Mouzeli; author: Effie Mouzeli):
[operations/puppet@production] maps: add support for replication slots
Change 857077 had a related patch set uploaded (by Effie Mouzeli; author: Effie Mouzeli):
[operations/puppet@production] maps: enable replication slots on maps1009 and maps1008
Change 857505 had a related patch set uploaded (by Effie Mouzeli; author: Effie Mouzeli):
[operations/puppet@production] maps: enable postres replication slots in eqiad
Change 857067 merged by Effie Mouzeli:
[operations/puppet@production] maps: add support for replication slots
Change 857077 merged by Effie Mouzeli:
[operations/puppet@production] maps: enable replication slots on maps1009 and maps1008
Change 857505 abandoned by Effie Mouzeli:
[operations/puppet@production] maps: enable postres replication slots in eqiad
Reason:
rebase hell
Change 857704 had a related patch set uploaded (by Effie Mouzeli; author: Effie Mouzeli):
[operations/puppet@production] maps: enable postgres replication slots in eqiad
Change 857704 merged by Effie Mouzeli:
[operations/puppet@production] maps: enable postgres replication slots in eqiad
Change 858337 had a related patch set uploaded (by Effie Mouzeli; author: Effie Mouzeli):
[operations/puppet@production] maps: enable postgres replication slots in codfw
Change 858337 merged by Effie Mouzeli:
[operations/puppet@production] maps: enable postgres replication slots in codfw