Spotty outages… very confused.

November 7, 2007

Yesterday I got the replicated slave database up and running and even made the API use MediaWiki’s built-in database-connections which are persistent, so that should have knocked down the amount of connect/disconnects (which are time-expensive).

Today, we’ve still been getting “Too Many Connections” errors… possibly because the MediaWiki persistent connections don’t close very quickly?  We’ll be looking into this some more… maybe I need new stats on how much traffic the API is getting.

Anyway, the solution I’ve taken is that during peak times, I keep setting the API to drop a certain percent of requests.  This isn’t a cool solution, so I’ll be trying to figure out a better way… anyone have any ideas?