How to turn off the binary log for mysqld_multi instances?
Posted
by
netvope
on Server Fault
See other posts from Server Fault
or by netvope
Published on 2011-01-01T06:06:29Z
Indexed on
2011/01/01
6:56 UTC
Read the original article
Hit count: 331
MySQL supports running multiple mysqld
on the same server. One of the ways is to use mysqld_multi.
If the default MySQL server instance (as configured in the [mysqld]
section in my.cnf
) uses log-bin
, it enables the binary log for all the other instances ([mysqld1]
, [mysqld2]
, etc). How can we override the setting for the other instances? We tried putting log-bin=
or log-bin=OFF
under [mysqld1]
, but that won't disable the binary log.
© Server Fault or respective owner