master.cnf: |
# Apply this config only on the master.
[mysqld]
+ sql_mode = "NO_ENGINE_SUBSTITUTION"
log-bin
[localpathprefix]
master
slave.cnf: |
# Apply this config only on slaves.
[mysqld]
+ sql_mode = "NO_ENGINE_SUBSTITUTION"
super-read-only
[localpathprefix]
slave