Skip to content

Database Master Switchover

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
Clone this wiki locally