Change 312241 had a related patch set uploaded (by Gehel):
maps - increase osm replication frequency to hourly

https://gerrit.wikimedia.org/r/312241

Change 312241 merged by Gehel:
maps - increase osm replication frequency to hourly

https://gerrit.wikimedia.org/r/312241

Replication frequency is set to 1 hour on the maps-test cluster. We can see that the server load average and IO peaks every hour and barely has time to go back down before the next replication. We can also see that postgresql replication often lags by > 10 minutes. I have no idea what the cause of that is at the moment, but it looks like something that needs to be fixed before we enable that on production servers.

Better metrics / dashboard is required to have visibility on what is happening.

Tilerator notification is failing regularly on the maps-test cluster, which it the cluster where hourly updates are enabled. This is correlation, not causality, still, we should make sure the problem isn't related (my suspicion: it is actually related).

Based on T159631: Tasmania is covered with water at z10+ we should switch to hourly diffs even if we don't change how often we update.

Moving to prioritized as it's on our list of things that do need doing.

Still something we're interested in doing, but not sufficiently high-priority for Maps-Sprint.

In T137939#2779156, @Gehel wrote:

Replication frequency is set to 1 hour on the maps-test cluster. We can see that the server load average and IO peaks every hour and barely has time to go back down before the next replication. We can also see that postgresql replication often lags by > 10 minutes. I have no idea what the cause of that is at the moment, but it looks like something that needs to be fixed before we enable that on production servers.

In T137939#2854171, @Gehel wrote:

Tilerator notification is failing regularly on the maps-test cluster, which it the cluster where hourly updates are enabled. This is correlation, not causality, still, we should make sure the problem isn't related (my suspicion: it is actually related).

@Gehel Are both of these still the case? (I found a Grafana dashboard for the production cluster[1], but not the maps-test cluster.)

[1] https://grafana.wikimedia.org/dashboard/db/maps-performances

Edit: Of course I found the control to switch to maps-test two seconds after posting...