Submitted by martynw on Thu, 10/29/2009 - 20:49 Pro Licensee
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?
Submitted by JamieCameron on Thu, 10/29/2009 - 23:21 Comment #1
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..