mysqlcluster能单独_mysqlcluster中的sqlnode（主）与单独的mysqlserver（从）做主从复制（异常解决）...

mysql-cluster 中的 sql node(主) 与 单独的 mysql server(从) 做主从复制(错误解决)

集群环境&＃xff1a;

mysql-cluster 7.2.8 (mysql 5.5.27 ; ndb 7.2.8)

192.168.55.11 mgm node (nodeid&＃61;1)

192.168.55.10 data node (nodeid&＃61;2)&＃43; sql node (nodeid&＃61;4)

192.168.55.9  data node (nodeid&＃61;3)&＃43; sql node(nodeid&＃61;5)

MySQL服务器&＃xff1a;

192.168.55.133 mysql

启动&＃xff1a;# /var/lib/mysql/bin/mysqld_safe &

关闭&＃xff1a;# /var/lib/mysql/bin/mysqladmin shutdown

进入数据库&＃xff1a;#  /var/lib/mysql/bin/mysql -u root -p

主从环境搭配&＃xff1a;

主&＃xff1a;master(sql node (nodeid&＃61;4))

[mysqld]

server-id &＃61; 1

log-bin &＃61; mysql-bin

binlog_format &＃61; row

binlog-do-db &＃61; db_name1

binlog-do-db &＃61; db_name2

binlog-ignore-db &＃61; db_name3

从&＃xff1a;slave(mysql)

[mysqld]

server-id &＃61; 3

log-bin &＃61; mysql-bin

binlog_format &＃61; row

binlog-do-db &＃61; db_name1

binlog-do-db &＃61; db_name2

binlog-ignore-db &＃61; db_name3

55.133

55.9

# mysqld_safe --ndb_nodeid&＃61;5 --user&＃61;mysql --server_id&＃61;1 &

# mysql -u mysql -p

mysql> show master status;

&＃43;------------------&＃43;----------&＃43;------------------&＃43;------------------&＃43;

| File             | Position | Binlog_Do_DB     | Binlog_Ignore_DB |

&＃43;------------------&＃43;----------&＃43;------------------&＃43;------------------&＃43;

| mysql-bin.000003 |      112 | db_name1,db_name2 | db_name3            |

&＃43;------------------&＃43;----------&＃43;------------------&＃43;------------------&＃43;

1 row in set (0.00 sec)

mysql> grant replication slave on *.* to slavemysql&＃64;192.168.211.133 identified by &＃39;908&＃39;; # 如果权限不够&＃xff0c;切换到root

mysql> flush privileges;

55.133

# /var/lib/mysql/bin/mysqld_safe &

# /var/lib/mysql/bin/mysql -u root -p

mysql> change master to master_host&＃61;&＃39;192.168.55.9&＃39;, master_user&＃61;&＃39;slaveuser&＃39;, master_password&＃61;&＃39;000&＃39;, master_log_file&＃61;&＃39;mysql-bin.000003&＃39;, master_log_pos&＃61;112;

mysql> start slave;

mysql> show slave status/G;

提示错误&＃xff1a; Last_IO_Error: error connecting to master &＃39;slaveuser&＃64;192.168.55.9:3306&＃39; - retry-time: 60  retries: 86400

但是通过&＃xff1a;# mysql -h 192.168.55.9 -u slavemysql -p 可成功登录远程9上的数据库。

# 在55.9上 mysql> grant all on *.* toslavemysql&＃64;192.168.211.133 identified by &＃39;908&＃39;; 也已经成功授权

错误已经修正&＃xff1a;参考&＃xff1a;http://blog.csdn.net/xc_gxf/article/details/8292075

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~