Postgres troubles

16 Mar

Hi everyone!

I am reposting this as the lovely people at MusicBrainz are having really serious issues with their server at the moment, and they are looking for help from anyone savvy with similar software.

Cheers and spread the info!

Update (19/03/2015): The problem was recently fixed. Good on MusicBrainz for their transparency, and thanks to all the helpers! Now let’s get back to editing! :)

MusicBrainz/MetaBrainz Blog

(Regular readers of this blog, please ignore this post. We’re casting a wide net to try and find help for our problems.)

Dear Postgres gurus:

We at MusicBrainz have been very happy postgres users for over a decade now and Postgres is something that gives is very few headaches compared to all the other things that we run. But last week we started having some really vexing issues with our server. Here is some back-story:

http://blog.musicbrainz.org/2015/03/14/hosting-issues-downtime-tonight/

When our load spiked, we did the normal set of things that you do:

  • Check for missing indexes, made some new ones, no change. (see details below)
  • Examined for new traffic; none of our web front end servers showed an increase in traffic.
  • Eliminated non-mission-critical uses of the DB server: stop building indexes for search, turn off lower priority sites. No change.
  • Review the performance settings of the server. Debate each setting as a…

View original post 639 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: