当前位置:Gxlcms > mysql > mysql-cluster中的sqlnode(主)与单独的mysqlserver(从)做_MySQL

mysql-cluster中的sqlnode(主)与单独的mysqlserver(从)做_MySQL

时间:2021-07-01 10:21:17 帮助过:18人阅读

bitsCN.com

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

集群环境:

mysql-cluster 7.2.8 (mysql 5.5.27 ; ndb 7.2.8)

192.168.55.11 mgm node (nodeid=1)

192.168.55.10 data node (nodeid=2)+ sql node (nodeid=4)

192.168.55.9 data node (nodeid=3)+ sql node(nodeid=5)

MySQL服务器:

192.168.55.133 mysql

启动:# /var/lib/mysql/bin/mysqld_safe &

关闭:# /var/lib/mysql/bin/mysqladmin shutdown

进入数据库:# /var/lib/mysql/bin/mysql -u root -p

主从环境搭配:

主:master(sql node (nodeid=4))

[mysqld]

server-id = 1

log-bin = mysql-bin

binlog_format = row

binlog-do-db = db_name1

binlog-do-db = db_name2

binlog-ignore-db = db_name3

从:slave(mysql)

[mysqld]

server-id = 3

log-bin = mysql-bin

binlog_format = row

binlog-do-db = db_name1

binlog-do-db = db_name2

binlog-ignore-db = db_name3

55.133

55.9

# mysqld_safe --ndb_nodeid=5 --user=mysql --server_id=1 &

# mysql -u mysql -p

mysql> show master status;

+------------------+----------+------------------+------------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |

+------------------+----------+------------------+------------------+

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

+------------------+----------+------------------+------------------+

1 row in set (0.00 sec)

mysql> grant replication slave on *.* to slavemysql@192.168.211.133 identified by '908'; # 如果权限不够,切换到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='192.168.55.9', master_user='slaveuser', master_password='000', master_log_file='mysql-bin.000003', master_log_pos=112;

mysql> start slave;

mysql> show slave status/G;

提示错误: Last_IO_Error: error connecting to master 'slaveuser@192.168.55.9:3306' - retry-time: 60 retries: 86400

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

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

错误已经修正:参考:http:///database/201212/175808.html

bitsCN.com

人气教程排行