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 <https://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_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