My issue is Asterisk and Apache are set to primary on node-a, but Mysql is set to secondary on node-b.
In a fail over situation Mysql does not start. It is also causing me to not be able to install AsternicCDR. When the install gets to crating the DB and tables I get and error. How can I change the primary/secondary for mysql?
Asterisk (Ver. 11.21.0)
PBX Firmware: 6.12.65-32
PBX Service Pack: 1.0.0.0
This node is:freepbx-a
Other node is:freepbx-b
Service Status:
Floating IP Address 192.168.130.20
MySQL Database (mysql) Running on: freepbx-b
The Asterisk service (asterisk) Running on: freepbx-a
Apache Web Server (httpd) Running on: freepbx-a
DRBD Stuff
freepbx-a
asterisk Connected
My/Other Connection state:Primary/Secondary
My/Other Data State:UpToDate/UpToDate
mysqlConnected
My/Other Connection state:Secondary/Primary
My/Other Data State:UpToDate/UpToDate
httpdConnected
My/Other Connection state:Primary/Secondary
My/Other Data State:UpToDate/UpToDate
spareConnected
My/Other Connection state:Primary/Secondary
My/Other Data State:UpToDate/UpToDate
freepbx-b
asteriskConnected
My/Other Connection state:Secondary/Primary
My/Other Data State:UpToDate/UpToDate
mysqlConnected
My/Other Connection state:Primary/Secondary
My/Other Data State:UpToDate/UpToDate
httpdConnected
My/Other Connection state:Secondary/Primary
My/Other Data State:UpToDate/UpToDate
spareConnected
My/Other Connection state:Secondary/Primary
My/Other Data State:UpToDate/UpToDate