maria-discuss team mailing list archive

[Igor Mazur <igor.kozlov@xxxxxxxxx>]

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@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
>