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 <cl...@fewbar.com> 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ 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
