mysql主从同步配置

来源:互联网 发布:南京直销软件开发 编辑:程序博客网 时间:2024/06/17 19:44
主配置文件由于升级mysql5.7被覆盖了 木有了10.142.164.235[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0server-id = 1log-bin = mysql-binbinlog-ignore-db = mysql,information_schemaauto-increment-increment = 2auto-increment-offset = 1slave-skip-errors = all[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid10.142.164.235[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0server-id = 2log-bin = mysql-binbinlog-ignore-db = mysql,information_schemaauto-increment-increment = 2auto-increment-offset = 1slave-skip-errors = all[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid
原创粉丝点击