Running reports on slave mysql replicated server
Posted: Wed Oct 30, 2013 6:44 pm
Hi, I installed latest ViciBox5.0.3 x64 with updates to Rev: 2039 and it is working fine.
I configured realtime mysql replication with another debian 7 server and it is working fine also.
I configured in Sytem Settings the field "Slave Database Server" to point to the ip of slave server and I selected all the reports to run on slave.
The reports are still running on master because even with mysql shutted down on replicated server the reports continue to run. In system_settings table the field "slave_db_server" was changed to the ip address of the slave and "reports_use_slave_db" field was changed into a list of reports comma separated.
What should I check next?
Thank you!
I configured realtime mysql replication with another debian 7 server and it is working fine also.
I configured in Sytem Settings the field "Slave Database Server" to point to the ip of slave server and I selected all the reports to run on slave.
The reports are still running on master because even with mysql shutted down on replicated server the reports continue to run. In system_settings table the field "slave_db_server" was changed to the ip address of the slave and "reports_use_slave_db" field was changed into a list of reports comma separated.
What should I check next?
Thank you!