← Back to team overview

maria-discuss team mailing list archive

Re: Best way to scale writes


Can you describe your schema and typical queries please?

Sent from my iPhone

> On Oct 14, 2016, at 12:33 PM, Jon Foster <jon@xxxxxxxxxxxxxxxxxxx> wrote:
> 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.
> TIA - Jon
> -- 
> Sent from my Debian Linux workstation -- http://www.debian.org/intro/about
> Jon Foster
> JF Possibilities, Inc.
> jon@xxxxxxxxxxxxxxxxxxx
> 541-410-2760
> Making computers work for you!
> _______________________________________________
> 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