mysql migration

[chasejordan1]

I want to put mysql on a seperate server to reduce load. Do I have to stop vicidial, asterisk, and mysql?
My thought is i would have to stop vicidial and asterisk, backup the mysql database, then stop mysql, restore the mysql database on new server, grant permission, then point astguiclient.conf to to new mysql server.
Am i on the right track? If so how do i stop vicidial, asterisk, and mysql, then how do i start vicidial, asterisk, (do i need to turn on mysql or not if so how to turn it back on. Would a reboot turn everything back on? Lastly do I need to change any other IP address in vicidial or "new mysql" Thanks in advance for any input. I have VicidialNow latest versions.

[gardo]

You can check first the LOAD_BALANCING.txt document on Astguiclient. This will help you achieve the setup that you want.

[chasejordan1]

I am sorry where can I find the load balancing txt

[Trying]

I am not sure if it is anywhere else but I always pull it from the SVN Server. Go to VICIDIAL WIKI and then SVN how to. Download the trunk and it will be under "docs" in the trunk.

[chasejordan1]

I did find it and read it but it doesn't have anything to do with my questions. How do you stop vicidial so I can back up mysql database. Or is stoping vicidial not necessary?

[gardo]

You can stop and start the Mysql server with the following commands:

start: "service mysqld start"
stop: "service mysqld stop"
restart: "service mysqld restart"

VICIDIAL is a lot of programs/scripts that act together to create a predictive dialer suite. You can safely stop Asterisk and Mysql and migrate your Mysql data to another server.

You can stop Asterisk by logging-in to it's command line interface (CLI).

asterisk cli: "stop now"