CentOS MySQL 配置二进制日志

CentOS MySQL 配置二进制日志

1.开启服务并登陆MYSQL

[ root@bogon] # service mysql start[ root@bogon] #{path}/bin/mysql -uroot -p

2.查看当前是否已开启二进制文件

mysql -> show variables like 'log_%';

“Variable_name” “Value”
“log_bin” “ON”
“log_bin_basename” “/program/mysql/data/bogon-bin”
“log_bin_index” “/program/mysql/data/bogon-bin.index”
“log_bin_trust_function_creators” “OFF”
“log_bin_use_v1_row_events” “OFF”
“log_builtin_as_identified_by_password” “OFF”
“log_error” “/program/mysql/data/bogon.err”
“log_error_verbosity” “3”
“log_output” “FILE”
“log_queries_not_using_indexes” “OFF”
“log_slave_updates” “OFF”
“log_slow_admin_statements” “OFF”
“log_slow_slave_statements” “OFF”
“log_statements_unsafe_for_binlog” “ON”
“log_syslog” “OFF”
“log_syslog_facility” “daemon”
“log_syslog_include_pid” “ON”
“log_syslog_tag” “”
“log_throttle_queries_not_using_indexes” “0”
“log_timestamps” “UTC”
“log_warnings” “2”

在这里可以看到日志文件的开启状态log_bon on/off和其他日志配置信息，我这里是已开启日志。若日志未开启则继续下面步骤

3.开启二进制配置

[ root@bogon] # vim /etc/my.cnf

在[mysqld]后配置以下信息：

log-binserver-id = 1

注意：server-id必须配置，否则mysql将启动失败

4.重新启动mysql

[ root@bogon] #service mysql restart