I am trying to increase performance with a mysql master/slave cluster.
Is there any information on how to do this using config_override.php?
I have a properly set of mysql servers and a SuiteCRM instance all communicating.
All changes in the CRM are properly replicating across the servers.
I want to set all listviews and reports to use the slave mysql server to increase performance.
My suggestion would be to use a Subdomain sort of thing for Master/Slave mysql. reports.yourdomain.com will use the slave DB in order to not put load on master. in the subdomain, hide all modules except show the reporting stuff.
I think it should be working. But I can’t tell if the reportwriter or list view is actually pulling from just the slave.
Multiple CRM web servers sharing /var/www/html via NFS .
We will manually assign url’s to our agents (poor man’s load balanceing)
Seperate MySQl master and slave servers
Using config_override to hammer the slave for read only reports and listviews leaving the master available for the data writes.