Another Suggestion
If you have any products/plugins installed, check all the files and plugins associated with them. Many are not written properly - for MASTER/SLAVE configuration.
for example, many SELECTS that should be going to SLAVE are actually going to the MASTER. In fact, not to long ago some rewrites were done to vbulletin files to retrieve data from the SLAVE rather than the MASTER.
check all modifications found here and commercial addons
NOTE: not all SELECTs should go to the SLAVE as there may be a delay in the MASTER/SLAVE replication
|