Vicidial operation on Slave Server
Posted:
Tue Apr 02, 2019 1:43 amby muyousif
Hi,
We are going to implement slave DB server with our active DB server, I just wanna know will it be be possible to use Slave DB server as Primary, if our primary server goes down due to some hardware issue?
Re: Vicidial operation on Slave Server
Posted:
Tue Apr 02, 2019 10:18 amby williamconley
1) Good job posting your specs.
2) This is not a general discussion. You are asking a support question, not whether The Vicidial Group is going to be open on Christmas or whether we think the Dialer Industry is in decline.
3) Changing the /etc/astguiclient.conf file on all servers to the new servers IP address (for the database variable) and then restarting all the servers is how you switch over.
4) Beware: Once you've "switched over", you'll need to mysqldump and restore the db to get the primary DB role back to the original server.
5) Remember that you can install a later version of mysql on the slave server and syncing will work just fine. But you can NOT have a more recent version of mysql on the master than the slave, that will fail because the master will then have features the slave doesn't understand (because it's newer, of course). So a newer slave is cool, but a newer master is not.