← Back to team overview

maria-discuss team mailing list archive

Re: Best way to scale writes


I asked about schema and queries to determine which sharding framework makes the most sense to suggest.

Sent from my iPhone

> On Oct 14, 2016, at 1:05 PM, Clint Byrum <clint@xxxxxxxxxx> 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, hopefully as
>> conveniently as I might add Apache servers to a website. We see two
>> servers laboring so we add a third to the mix and so on.
>> I'm still looking at the various technologies available to me and was
>> wondering if someone out there had some suggestions on this front.
>> Although Galera Cluster says it scales for write loads too it also says
>> that all servers write the same data and make sure its committed by the
>> time the transaction is completed. So it seems like write performance
>> would never scale because all servers are doing the same write.
>> Maybe I'm missing something.
>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Follow ups