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

2016-10-16 Thread Daniel Black
On 15/10/16 03:33, Jon Foster 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. Not using RAID6 would be a good start. > But we're looking for a way

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

2016-10-14 Thread Jon Foster
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 looki

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

2016-10-14 Thread Jon Foster
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 mak

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

2016-10-14 Thread Justin Swanhart
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 wrote: > > Excerpts from Jon Foster's message of 2016-10-14 09:33:59 -0700: >> I have a DB scenario that is very write intensiv

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

2016-10-14 Thread Clint Byrum
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 wr

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

2016-10-14 Thread Justin Swanhart
Can you describe your schema and typical queries please? Sent from my iPhone > On Oct 14, 2016, at 12:33 PM, Jon Foster 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

[Maria-discuss] Best way to scale writes

2016-10-14 Thread Jon Foster
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 a