Sorry, I'm not ignoring you. I was not the one who designed the schema so I'm going to have to go look at it. I will probably not be able to get back to you today with my assessment.

THX - Jon

Justin Swanhart wrote:
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
  

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

Jon Foster
JF Possibilities, Inc.
j...@jfpossibilities.com
541-410-2760
Making computers work for you!
_______________________________________________
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

Reply via email to