my.cnf for optimization

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

my.cnf for optimization

Postby TwistedFister » Tue Nov 28, 2017 9:06 am

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?
TwistedFister
 
Posts: 68
Joined: Tue Jul 26, 2016 11:50 am

Re: my.cnf for optimization

Postby RockAllMoment » Thu Feb 07, 2019 2:02 am

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.
We are happy to help you.
RockAllMoment
 
Posts: 9
Joined: Wed Feb 06, 2019 12:08 am

Re: my.cnf for optimization

Postby Noah » Thu Feb 07, 2019 3:21 pm

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.
MyCallCloud.com - Cool Vici Customizations - Hosted - Configured - Supported
Web: https://mycallcloud.com
P: 888-663-0760
E: sales@mycallcloud.com
Noah
 
Posts: 84
Joined: Tue Feb 08, 2011 7:14 pm

Re: my.cnf for optimization

Postby williamconley » Thu Feb 07, 2019 4:37 pm

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-)
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18177
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: No registered users and 15 guests