Database Master Switchover

Jump to bottom Edit New page

Tom Hughes edited this page May 5, 2022 · 2 revisions

Switch site to read-only
Stop chef on all database servers
Disable osmdbt replication on planet server with osmdbt-disable-replication -c /etc/replication/osmdbt-config.yaml
Stop postgres on old master
Switch old and new master roles in chef
Run chef on new master
- Check postgres is up and running as master on new master
Run chef on old master
- Check postgres is up and in sync on old master
Run chef on other database servers
- Check postgres is up and in sync on other database servers
Enable osmdbt replication on planet server with osmdbt-enable-replication -c /etc/replication/osmdbt-config.yaml
Switch site back to online mode