主: [mysqld] log-bin=mysql-bin server-id=1 从: [mysqld] log-bin=mysql-bin server-id=2 relay-log=relay-log #read_only=1 #super_read_only=1 注意这里要添加 log-bin=mysql-bin 为 从(从作为主) 添加一个 从: [mysqld] server-id=3 relay-log=relay-log #read_only=1 #super_read_only=1