log_bin & log_bin_basename & log_bin_index

log_bin

log_bin是二进制日志的开关,用来记录所有的修改数据的dml语句,以备恢复数据库和复制数据库使用.
如果不指定log_bin_basename,则binlog使用主机名命名binlog日志
==> log_bin_basename 二进制日志文件名
==> log_bin_index 二进制的索引文件名

实验室

1 不指定

# hostname 
monitor
# grep log-bin /etc/my.cnf 
log-bin
# ll /usr/local/mysql/data/monitor*
-rw-r----- 1 mysql mysql      177 Jun 26 12:00 monitor-bin.000001
-rw-r----- 1 mysql mysql      799 Jun 26 12:08 monitor-bin.index

2 指定名称

# grep log-bin /etc/my.cnf              
log-bin         = test
# ll /usr/local/mysql/data/test.*
-rw-r----- 1 mysql mysql 154 Jun 26 14:56 /usr/local/mysql/data/test.000001
-rw-r----- 1 mysql mysql  14 Jun 26 14:56 /usr/local/mysql/data/test.index

3 指定路径

# grep log-bin /etc/my.cnf     
log-bin         = /usr/local/mysql/data/binlog/test
# ll /usr/local/mysql/data/binlog/
-rw-r----- 1 mysql mysql 154 Jun 26 15:02 /usr/local/mysql/data/binlog/test.000001
-rw-r----- 1 mysql mysql  41 Jun 26 15:02 /usr/local/mysql/data/binlog/test.index