MySQL Binary Log

For a long time I have been thinking about trying to get my client Web sites taking advantage of MySQL's data replication capabilities.

I read on the MySQL site that I need to start MySQL with the "--log-bin[=base_name] option," I'm not sure what this means but I noticed that in Webmin - Servers - MySQL - Database Server, there is an option to select LOG. However when I do this and try and change it from OFF to ON, I get the following message: "SQL set global log = ON failed : Variable 'log' is a read only variable"

Please could you advise?

Status: 
Active

Comments

Unfortunately, there isn't yet any support in Virtualmin for setting up MySQL replication, which can be quite complex. If you want to enable it, you will need to edit /etc/my.cnf manually..