Page 1 of 1

my.cnf for optimization

PostPosted: Tue Nov 28, 2017 9:06 am
by TwistedFister
Vicibox 7.0.3 from .iso | Vicidial 2.14-579a Build 161128-1746 | Asterisk 11.22.0-vici | CLuster setup: 1 web 1 DB 1 Slave DB 8 telephony | No Digium/Sangoma Hardware | No Extra Software After Installation

we added a new slave db (ssd's 64GB ram) and looking to optimize it. Do we need to change anything within my.cnf? Or what would be recommended for optimization?

Re: my.cnf for optimization

PostPosted: Thu Feb 07, 2019 2:02 am
by RockAllMoment
Yes you have to change my.conf file in slave db to add server_id=2 and in master server_id=1 and log_bin then only the main server will act as master and the second one will act as a slave server.

Note: Once you started slave concept on secondary server avoid manual changes on slave server. Which disconnects slave server from master server.

Re: my.cnf for optimization

PostPosted: Thu Feb 07, 2019 3:21 pm
by Noah
Did you use the standard my.cnf on the installation for the slave DB?

Slave acts very similarly to production. It inserts, updates and deletes as the production db does based on the same queries from the bin log.
If the servers are the same the same settings would apply, other than the server ID as the post before mentions.

Re: my.cnf for optimization

PostPosted: Thu Feb 07, 2019 4:37 pm
by williamconley
TwistedFister wrote:Vicibox 7.0.3 from .iso | Vicidial 2.14-579a Build 161128-1746 | Asterisk 11.22.0-vici | CLuster setup: 1 web 1 DB 1 Slave DB 8 telephony | No Digium/Sangoma Hardware | No Extra Software After Installation

we added a new slave db (ssd's 64GB ram) and looking to optimize it. Do we need to change anything within my.cnf? Or what would be recommended for optimization?

Vicibox has an installer option for replication. I suspect you'll find it ... useful. 8-)