Can not activate the log-bin
I have a database that uses the InnoDB engine on all his tables, running
on a Windows Server 2008 r2 64bit in a VM farm. The policies of my
organization promotes that every server has to have a replication that can
run in the case of disaster in the primary (a DRP). So, in order to
achieve that, I tried to activate the log-bin, (to deploy a slave server),
I checked the CPU and Memory usage and everything seemed to be normal, but
the log file wasn't created, also the DB started reject lots of
connections and the app started to act odd. As soon as I deactivated the
log-bin everything went back to normal (immediately).
The next time I try to activate the log;
What can I do to ensure the log-bin is activated, besides uncomment the
Log-bin= line? What parameters from the Data Base can be monitored to see
what is wrong or need tuning?
No comments:
Post a Comment