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?