[Spce-user] Moving MySQL to another host

[Jon Bonilla (Manwe)]

El Fri, 24 Jun 2016 07:37:30 +0000
Walter Klomp <walter at myrepublic.com.sg> escribió:

> Hi,
> 
> I want to offload the CPU’s of the servers a bit more to prevent RcvBuferrors
> which I still have, probably due to high load, and as such I have created a
> slave of the current MySQL server on another host. 
> 
> In order to make this the “master” server, do I just have to change the
> dbhost entries in constants.yml?   (i’ll obviously check if the accounts are
> accessible from the sip server beforehand)
> 
> Would the switchover shutdown everything and start again, or will calls in
> progress keep on working?
> 
> Anybody else here have moved their SQL out of the box?
> 
> 

1: copy the mysql dbs
2: Copy the grants but adjust the host
3: Change the db in constants.yml
4: run ngcpcfg apply


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: Firma digital OpenPGP
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20160624/655cf7b3/attachment.sig>