Shared Hosting: MySQL Server Upgrade

[News]

The MySQL Server will be upgraded on Wednesday at 2 AM.

More...

[Jon124]

does this have anything to do with the random mysql outages earlier today?

[Kevin]

does this have anything to do with the random mysql outages earlier today?

Much, yes. We're attempting to resolve these problems through upgrades and deployment of additional servers. The former should help in the short term and the latter in the long term.

[Jon124]

awesome, you guys sure do keep on top of your stuff.

[NickCatal]

I know people like doing what they want... but jeeze... there is like 50Mbps of traffic going from MySQL to the shared hosting servers... that is TEXT people..

New version of PhpBB has good query caching, new version of Ruby on Rails does query caching, drupal has caching... not only will you help everyone else, you will speed up the performance of your application by not making 30 queries for every user for every page (I'm looking at you, Post/PHPNuke)...

[Jon124]

I have caching enabled on drupal and phpbb!

[Karl]

It seems the upgrades have greatly improved MySQL performance, as we had hoped it would. Service levels should be back to normal and we apologize for the couple days of subpar service from MySQL. We will also be provisioning an additional MySQL server later this week or early next week.

[NickCatal]

I have caching enabled on drupal and phpbb!

That is why I mentioned those two specifically... because Drupal and phpBB 3 (not 2) are great examples of mature PHP applications that use resources (like MySQL) more effectively. Not to mention they are standard features, turned on by default (or at least I know phpBB 3 it is on by default, haven't installed Drupal in awhile)