DEV Community

Is the database working as expected?

Ben Halpern on October 16, 2019

If you are reading this, the answer is yes.

We just updated our Postgres version, so I'm thankful nothing went wrong.

Collapse
 
rhymes profile image
rhymes • Edited

I'm so happy we've upgraded to PostgreSQL 11, I can finally start using all the features under the sun β˜€οΈ

πŸ˜‚

Collapse
 
byrro profile image
Renato Byrro • Edited

Some features were down (now good) for a few minutes:

  • Dashboard inaccessible
  • Wouldn't save changes to an article
  • Unpublished articles were not accessible (reading draft or editing)

Yes, guilty, I'm a heavy user and needed all this during your 2-minute migration window 😊

Collapse
 
ben profile image
Ben Halpern

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.

Collapse
 
kayis profile image
K

Fortnite style!

Collapse
 
byrro profile image
Renato Byrro

No worries at all πŸ˜‰ πŸ‘

Was only reporting because I thought it could make it easier for you guys to track any improvement opportunities

Collapse
 
rhymes profile image
rhymes

I know, but Heroku prudently keeps that for 3 months in beta.

I guess we'll have to upgrade again next year :P

Collapse
 
kp profile image
KP

Just curious why dev is using postgres vs mysql. What are the benefits?

Collapse
 
hexangel616 profile image
Emilie Gervais

workin' ;)

Collapse
 
kp profile image
KP

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.

Collapse
 
andrewbrown profile image
Andrew Brown πŸ‡¨πŸ‡¦

RDS DB Snapshot and then upgrade?

Collapse
 
rhymes profile image
rhymes

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

Collapse
 
ben profile image
Ben Halpern

This was our process, pretty straightforward.

devcenter.heroku.com/articles/upgr...

Still happy it all worked as expected.

Collapse
 
stephanie profile image
Stephanie Handsteiner

I don't know, am I reading this? 🀨

Collapse
 
jacobherrington profile image
Jacob Herrington (he/him)

yes

Collapse
 
x82isaac profile image
Michael Isaac

β™₯️

Collapse
 
tuwang profile image
TuWang

Absolutely

Collapse
 
cwreacejr profile image
Charles Reace

Postgres...I've become a big fan of materialized views, lately. 😊

Collapse
 
felipperegazio profile image
Felippe Regazio

Yes

Collapse
 
lukegarrigan profile image
Luke Garrigan

woo well done! πŸ₯³