Closed Bug 469215 Opened 14 years ago Closed 14 years ago
setup postgres replication for breakpad in staging
Please setup postgres replication for breakpad in the staging environment. The staging db lives on tm-stage01-master01. The purpose of this replicated environment is to be able to make backups of the db from the slave without impacting the production db performance. Once the staging env is setup and work, we can then deploy this to production.
My plan for this is shipping completed write ahead logs to a slave. The slave will replay the logs regularly and we'll backup the write ahead logs and the slave state. I'll be deploying and verifying this on stage in the next couple days.
chizu, for scheduling/planning, do you have an ETA on this?
This just needs an ACL from tm-stage01-master01 to dracula, the rest is ready.
This is replicating and I've made and restored backups from it. It just needs some more polish and documentation before I can call this done.
Status: NEW → ASSIGNED
Great news, Trevor! Thanks for picking this up. <3
I should note how this is a different than MySQL replication. The master keeps write ahead logs normally. To make a slave we checkpoint one, rsync the database directory over to the slave, and put the slave into recovery mode pulling in those logs over nfs or rsync. Because the slave is in recovery mode, it's not serving queries. This makes it great for backups and failover in case the master dies, but it can't take read-only queries while replicating. Recovery mode can be stopped to run queries in batches.
Documented and running.
Status: ASSIGNED → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.