Home >Database >Mysql Tutorial >mysql主从同步随笔_MySQL
mysql主从同步随笔_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:34:41895browse
bitsCN.com
mysql主从同步随笔
vim /etc/my.cnf
server-id=1
log-bin=/data/binlog/mysql-bin
binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=information_schema
flush tables with read lock;
show master status;
server-id=2
stop slave;
chage master to
master_host=
master_user=
master_password=
master_port=
master_log-file=
master_log_pos=
start slave;
show slave status;
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysql字符集的修改及查看问题_MySQLNext article：CentOS6.4安装MySQL记录_MySQL