Hi,

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 (for read access), and put log to another drive. It's, probably, most general things.

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