List:Cluster« Previous MessageNext Message »
From:Nick Cen Date:May 5 2008 6:54am
Subject:How to setup cluster replication
View as plain text  
Hi All,

I wanna to build up a whole new cluster replication, i have 3 machines M1,
M2 and S2. M1 & M2 makeup the cluster. M2 and S2 makeup a replication
channel.
I am using the tar ball mysql-5.1.23-ndb-6.2.14-telco.tar. And follow the
instructions in this page
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-preparation.html
,
the initial table is create with the mysql_install_db script.

The cluster is run without problem and here is the my.cnf in M2 and S2.

M2's my.cnf
[client]
default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
# Options for mysqld process:
[mysqld]
ndbcluster                      # run NDB storage engine
ndb-connectstring=192.168.145.131  # location of management server
default-character-set=utf8
default-storage-engine=ndbcluster
# Replication
log-bin=mysql-bin
binlog-format=ROW
server-id=2
# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.145.131  # location of management server

S2's my.cnf
[client]
default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
# Options for mysqld process:
[mysqld]
ndbcluster
default-character-set=utf8
default-storage-engine=MyISAM
server-id=3

The bin-log file info is accquire with the following sql statement
mysql> flush tables with read lock;
Query OK, 0 rows affected (0.02 sec)
mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |      233 |              |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)


The cluster(M1,M2) and S2 can start without problem.

When i create a table in M2, a replicate table is create in S2. but when i
insert a record in to M2's table nothing happen in S2. And here is the
mysqld log of S2.
080505  7:38:01 [Note] Slave I/O thread: connected to master '
repl@stripped:3306',replication started in log 'mysql-bin.000001' at
position 233
080505  7:39:00 [ERROR] Slave SQL: Error 'Table 'mysql.ndb_apply_status'
doesn't exist' on opening table `mysql`.`ndb_apply_status`, Error_code: 1146
080505  7:39:00 [Warning] Slave: Table 'mysql.ndb_apply_status' doesn't
exist Error_code: 1146
080505  7:39:00 [Warning] Slave: Got error 4009 'Cluster Failure' from NDB
Error_code: 1296
080505  7:39:00 [ERROR] Error running query, slave SQL thread aborted. Fix
the problem, and restart the slave SQL thread with "SLAVE START". We stopped
at log 'mysql-bin.000001' position 322


Any idea, thanks in advance.

Nick

Thread
How to setup cluster replicationNick Cen5 May 2008
  • Re: How to setup cluster replicationewen fortune5 May 2008
    • Re: How to setup cluster replicationNick Cen5 May 2008
    • Re: How to setup cluster replicationNick Cen5 May 2008
      • Re: How to setup cluster replicationewen fortune5 May 2008
        • Re: How to setup cluster replicationNick Cen5 May 2008
          • Re: How to setup cluster replicationewen fortune5 May 2008
            • Re: How to setup cluster replicationNick Cen6 May 2008
              • Re: How to setup cluster replicationNick Cen6 May 2008
              • Re: How to setup cluster replicationewen fortune6 May 2008
                • Re: How to setup cluster replicationNick Cen6 May 2008
                  • Re: How to setup cluster replicationewen fortune6 May 2008
                    • Re: How to setup cluster replicationewen fortune6 May 2008