Home > Database > Mysql Tutorial > mysql-cluster中的sql node(主)与单独的mysql server(从)做_MySQL

mysql-cluster中的sql node(主)与单独的mysql server(从)做_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:37:49
Original
1047 people have browsed it

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
Related labels:
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template