We could have optimized for a time where we had less traffic, like late Friday night, but since we hadn't performed this kind of upgrade before we felt like optimizing for a time where most of the team could be online and alert made sense.
The next time we need scheduled downtime (or, gasp! face unscheduled downtime) we will likely have way more users online at all times. This kind of thing isn't getting easier.
Thanks for the detailed explanation! I don't come from the ROR community so Postgres is foreign to me...and I know a lot of people that fall inthe same boat. Your answer was helpful, so thanks.
English lad currently a C#/Java/VueJs/JavaScript/TypeScript engineer.
Extra dribbling can be found at https://codeheir.com
Portfolio found at https://lukegarrigan.com
I'm so happy we've upgraded to PostgreSQL 11, I can finally start using all the features under the sun ☀️
😂
Some features were down (now good) for a few minutes:
Yes, guilty, I'm a heavy user and needed all this during your 2-minute migration window 😊
We could have optimized for a time where we had less traffic, like late Friday night, but since we hadn't performed this kind of upgrade before we felt like optimizing for a time where most of the team could be online and alert made sense.
The next time we need scheduled downtime (or, gasp! face unscheduled downtime) we will likely have way more users online at all times. This kind of thing isn't getting easier.
Fortnite style!
No worries at all 😉 👍
Was only reporting because I thought it could make it easier for you guys to track any improvement opportunities
I know, but Heroku prudently keeps that for 3 months in beta.
I guess we'll have to upgrade again next year :P
Just curious why dev is using postgres vs mysql. What are the benefits?
workin' ;)
Thanks for the detailed explanation! I don't come from the ROR community so Postgres is foreign to me...and I know a lot of people that fall inthe same boat. Your answer was helpful, so thanks.
RDS DB Snapshot and then upgrade?
What Heroku's upgrade procedure essentially does it the following: create a follower, upgrade, switch over the follower as main DB
The downtime is required to disable processes that write to the main DB while the follower finalizes the sync and upgrades
This was our process, pretty straightforward.
devcenter.heroku.com/articles/upgr...
Still happy it all worked as expected.
I don't know, am I reading this? 🤨
yes
♥️
Absolutely
Postgres...I've become a big fan of materialized views, lately. 😊
Yes
woo well done! 🥳