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.aur...@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 >
_______________________________________________ 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
