← Back to team overview

maria-discuss team mailing list archive

Re: Help to size: Best configuration for a lot read and write



1. You have to start from metrics for your servers. Metrics from OS (cpu,
memory, disk, network) and MySQL (grab 'show global status')
2. Look at them, think :)
I think - without information from the first paragraph, good start point
will be increasing innodb_buffer_pool_size
read access), and put log to another drive. It's, probably, most general

Master-Master - is a complicated thing in a case of heavy writes (usually,
solution is Galera - but there are lots limitations). Try to think about
sharding or splitting business logic.

2016-02-19 17:26 GMT+02:00 Tristan Auriol <tristan.auriol@xxxxxxxxx>:

> Hello everyone,
> I have some basics about SQL. But I need your help.
> I must set up a SQL servers for a new web application. This web
> application will make a lot of write and some reads the night and
> enormously read and some writing on the day.
> Here are my questions:
> - What is the best solution for performance and security?
> - On a cluster Master / Master (three node) can I write on the 3 master
> node simultaneously (with HAProxy or another product)?
> Thank you in advance for your help.
> Best Regards, Tristan
> _______________________________________________
> 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