Excerpts from Jon Foster's message of 2016-10-14 09:33:59 -0700:
I have a DB scenario that is very write intensive. Essentially its a
large scale hit counter of sorts. Currently we're running on a single
12core server with 6 SSDs in a RAID6 array. But we're looking for a way
to scale out write volume by adding more servers [...]
Anyhow some pointers would be appreciated.
If you're overwhelming one server (you haven't even begun to scale up
btw) you will have to shard. However, before you do that.. consider how
cheap 24 core servers with 10x FusionIO or similar SSDs would be versus
the cost in complexity of sharding.
Maybe take a look at Vitess, which helps shard things but keeps all the
good stuff you like about MariaDB/MySQL:
http://vitess.io/
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
Thanks, Clint, we are moving towards the 24core option too. Just
looking to the future. :-) In fact we're moving the DB onto another box
just to determine if the "semaphore freezes" we're experiencing are
hardware. The newer box is a dual processor box! I'll look at Vitess.