Step 1: Checking the Database Status
The first step is to check if the log-bin option is turned on or not and what binary log format is used. MySQL provides three types of bin-log format: ROW, MIXED and STATEMENT. The following query shows that the binary logging is turned off and the binary log format is STATEMENT.
To update the setup, you need to update the MySQL configuration file (my.ini or my.cnf) by adding the following lines to the [mysqld] section (the Server Section).
Step 3: Confirming the Changes
After restarting the MySQL server, you can check the binary logging status again. Make sure the log_bin is ON and the binary log format is the format supported by the replication tools. For example, Oracle GoldenGate 11.2 and 12c only supports ROW format.