[Spce-user] Moving MySQL to another host

[Walter Klomp]

Hi,

Yes, for point 4, which one?  all ?

database:
  central:
    dbhost: localhost
    dbmaster: xxxxx
    dbport: 3306
    redis_port: xxxx
  debian:
    dbhost: localhost
    dbpassword:
    dbuser: debian-sys-maint
  local:
    dbhost: localhost
    dbport: 3306
  pair:
    dbhost: localhost
    dbport: 3306
  panel_replica:
    dbhost: localhost
    dbport: 3306


> On 24 Jun 2016, at 5:27 PM, Jon Bonilla (Manwe) <manwe at sipdoc.net> wrote:
> 
> 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
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user