3 ms·
Heroku just does this. At my old job we would scale the database using replication multiple times a week depending on expected traffic. https://devcenter.herok
by october8140 3y ago
Heroku just does this. At my old job we would scale the database using replication multiple times a week depending on expected traffic.
https://devcenter.heroku.com/articles/heroku-postgres-follower-databases https://devcenter.heroku.com/articles/heroku-postgres-follow...
- why-el 3y agoNot quite I don't think. For a busy database, The Heroku followers will not catch up to your upgraded database as quickly, so during an upgrade using Heroku's physical replication (as opposed to logical), there will be a time period where your freshly upgraded primary is on its own as the followers are being issued and brought up to date.
- thejosh 3y agoExcept Heroku has an issue of your backup etc is too large (despite paying for the correct size), it would cause the replica to go down and spin up a new one, and this process could take hours.