Hi,
Kindly help me in testing the cluster replication.
My requirement:
Two mysql servers are available (10.203.226.70 and 10.203.226.101). Both are
master -master configuration
One server (10.203.226.70) goes down and Table creation and updation are
happened in second server (10.203.226.101) during that time. If the first
server (70) comes up, then tables created in 101 server should get
replicated in 70 server automatically. This is my requirement
I tried it with the follwoing configurations:
I have three servers (10.203.226.70, 10.203.226.101 and one management
server (ndbd_mgm) is always running.)
My management server shows the following after the configuration:
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.203.226.70 (mysql-5.1.41 ndb-7.0.13, Nodegroup: 0, Master)
id=3 @10.203.226.101 (mysql-5.1.41 ndb-7.0.13, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.203.226.102 (mysql-5.1.41 ndb-7.0.13)
[mysqld(API)] 2 node(s)
id=4 @10.203.226.70 (mysql-5.1.41 ndb-7.0.13)
id=5 @10.203.226.101 (mysql-5.1.41 ndb-7.0.13)
101 and 70 server tables also getting replicated.
But if any of the server (101 / 70) goes down, then after restarting it is
expecting for the change master command . Becos the Slave SQL Running shows
NO. I need to do the following to make it as YES:
1. reset the slave
2. change master command
3. start slave.
*Due to that my requirement is not happening.*
*Please help me out.*
*Immediatley after restatrting the server without the above three commands
is it possible to show status:SLAVE SQL RUNNING: YES **and replication will
happen automatically.*
**
Command to shutdown used : /usr/local/mysqlc/bin/mysqladmin -uroot
-proot123 shutdown
command to restart server used: /usr/local/mysqlc/bin/mysqld
--defaults-file=/export/home/mysql/my_cluster/conf/my.cnf --user=mysql &
Thanks
Preeja
