I have installed Multiple MySQL instances and i have two configuration files one for each one is using default location of /etc/mysql/my.cnf
.
other server i have started like
root@ABC-240:/usr/local/mysql# bin/mysqld_safe --defaults-file=/etc/mysql/binary_my.cnf &
root@ABC-240:/usr/local/mysql# 120104 10:19:34 mysqld_safe Logging to syslog.
120104 10:19:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
I have set the error log in both of the configuration files but one of them as above is logging to syslogs.
Why is it like that?
Best Answer
It may be possible that both instances of MySQL are trying to record log entries to the same location (same file).
I do not think mysql allows more that one error log per MySQL instance.
Here is something further on using error log with mysqld and mysqld_safe:
Since you started mysqld_safe to start mysqld, you just need to start mysqld_safe and explicitly choose a separate file for the error of the other MySQL Instance using the -
-log-error
option.