Common mysql options

Mysql common options binlog-format can be set to STATEMENT (default), ROW, and MIXED. SUPER is required. It is not recommended to modify the binlog-format value when replication is in progress. Binlog-do-db (binlog-ignore-db, replicate-do-db, replicate-ignore-db) must use multiple rows for multiple databases. Because the database name can contain commas (,), multiple database names are separated by commas (,), which is considered to be the name of a database containing commas. No matter what binlog-format is, statements such as create table and alter table are always recorded in binary logs in statement format. Binlog-do-db (binlog-ignore-db, replicate-do-db, replicate-ignore-db) takes effect in relation to binlog-format: When binlog-format is STATEMENT, the effective database is the default database. When binlog-format is ROW, the data where the table is located will take effect, regardless of the default database. Log-slave-updates indicates whether to record replication updates. It is necessary for Cascade replication. In dual-master mode, FALSE is required. When auto_increment_increment auto_increment_offset is set to auto_increment_offset + N * auto_increment_increment sync-binlog is set to 0, the file system of the operating system determines when to synchronize binary logs. If it is greater than 0, it is synchronized to binary logs after N commit groups. The value is 1, which is the safest, but has low performance. Slave-ignore-errors ignores replication errors. We do not recommend that you set the value to all. Under normal circumstances, there should be no errors; if an error occurs, the error should be resolved, rather than ignoring the error. Log-error log file, which records information such as MySQL server startup and shutdown. For Windows, note that the path must be separated by "/" instead of "\". Location of log-output (page 522): FILE TABLE NONE