[MediaWiki-l] Scaling up - MySQL server

David Chamberlain david at alaskawiki.org
Tue Feb 18 22:22:57 UTC 2014


I am sorry if this seems obvious, I am new to these lists but it looks like
you are not leveraging cache.


On Tue, Feb 18, 2014 at 5:11 PM, David Gerard <dgerard at gmail.com> wrote:

> rationalwiki.org is getting hammered again. It looks like MySQL is the
> busiest portion - seriously just doing a lot of work.
>
> Our current arrangement is: one box for MySQL, Apache, Lucene (the
> latter reindexing weekly); two Squids; a load balancer. These are all
> virtual machines on Linode (who we like). Apache and Squid boxes are
> Ubuntu 12.04 servers.
>
> The *usual* thing when we get hammered is that Reddit discovers an
> amusing tumbleweed article. The squids take care of this, of course.
> But then something like the Bill Nye/Ken Ham debate happens, we score
> pretty highly in Google for skeptical material and a wide variety of
> articles gets hit and MySQL has to work for a living.
>
> So, what's a good approach to scaling up MySQL on a VM? Add more
> memory? Add more cores? (How's MySQL 5.5-ubuntu do for multicore?) We
> can trivially add more Squids, and we haven't doubled up on Apache but
> shirley that won't be entirely unfeasible.
>
>
> - d.
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>



-- 
David Chamberlain
http://alaskawiki.org/ <http://alaskawiki.org/index.php?title=Alaska>
http://about.me/david.chamberlain
Mission: To be the largest and most accurate source of information about
Alaska.


More information about the MediaWiki-l mailing list