maria-discuss team mailing list archive
Mailing list archive
Re: Best way to scale writes
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
> 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
Where? This is dubious for the reasons below (which are the same as why
raid6 is poor).
> it also says that all servers write the same data
(well - *have* the same data rather than have it written)
> 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.
I don't think so. You seem to have that worked out.
> Anyhow some pointers would be appreciated.
MyRocks will be interesting to keep an eye on.
Answering Justin's question and details to what component in
hardware/MariaDB is the limiting factor is probably critical before you
go much further. Perhaps even getting professional help.