- 论坛徽章:
- 0
|
要实现 A --->B---->C, 同步一个audit库。 就是A上的audit热备到B上,然后B在同步到C上。
其中B想用 mysqld_multil来做成两个实例。一个作为A的slave来同步audit库,一个作为C的master来同步C上的audit库.
请问这个应该如何配置?
目前作为A的slave已经实现,但是B为C的master始终不能通过-----在C上读的bin-log始终和B上3307端口show master出来的不一样。而B上的mysql1和mysql2 的master.info是一样的。
请大侠帮助!!
我是如下配置的:
A---172.x.x.11
B---172.x.x.12
C---172.x.x.13
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
[mysqld1]
bind-address = 172.x.x.12
port = 3306
socket = /tmp/mysql.sock
pid-file = /data/mysql_data/1.pid
datadir = /data/mysql_data
tmpdir = /data/mysql_data/tmp
skip-locking
log_err = /data/mysql_data/multi.err
long_query_time = 10
log_slow_queries = /data/mysql_data/mysql-slow.log
log-bin = /data/mysql_data/data1/bin-log
log-bin-index = /data/mysql_data/data1/bin-log.index
server-id = 2
relay-log = /data/mysql_data/data1/relay-log
relay-log-index = /data/mysql_data/data1/relay-log.index
relay-log-info-file = /data/mysql_data/data1/relay-log.info
master-info-file= /data/mysql_data/data1/master.info
master-host = 172.x.x.11
master-port = 3306
master-user = rp
master-password = rp
replicate-do-db = audit
[mysqld2]
bind-address = 172.x.x.12
port = 3307
socket = /tmp/mysql3307.sock
pid-file = /data/mysql_data/2.pid
datadir = /data/mysql_data
tmpdir = /data/mysql_data/tmp
skip-locking
log_err = /data/mysql_data/multi2.err
long_query_time = 10
log_slow_queries = /data/mysql_data/mysql-slow2.log
server-id = 10
log-bin = /data/mysql_data/data2/bin-log
log-bin-index = /data/mysql_data/data2/bin-log.index
binlog-do-db = audit
relay-log = /data/mysql_data/data2/relay-log
relay-log-index = /data/mysql_data/data2/relay-log.index
relay-log-info-file = /data/mysql_data/data2/relay-log.info
master-info-file= /data/mysql_data/data2/master.info
log-slave-updates |
|