Re: [Maria-discuss] Best way to scale writes

Jon Foster Fri, 14 Oct 2016 11:04:13 -0700

Clint Byrum wrote:

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     : [email protected]
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.

THX - Jon

-- 
Sent from my Debian Linux workstation -- http://www.debian.org/intro/about

Jon Foster
JF Possibilities, Inc.
[email protected]
541-410-2760
Making computers work for you!

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-discuss] Best way to scale writes

Reply via email to