Re: Mysql replication

[Mukesh Nagar]

Hi Aftab,

Thanks for your reply.

please find the SHOW CREATE TABLE ssg.cluster_master\G on both the servers.

master server
mysql> SHOW CREATE TABLE ssg.cluster_master\G;
*************************** 1. row ***************************
Table: cluster_master
Create Table: CREATE TABLE `cluster_master` (
`nodeid` varchar(32) DEFAULT NULL,
`touched_time` bigint(20) NOT NULL,
`version` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8




slave server

mysql> SHOW CREATE TABLE ssg.cluster_master\G;
*************************** 1. row ***************************
Table: cluster_master
Create Table: CREATE TABLE `cluster_master` (
`nodeid` varchar(32) DEFAULT NULL,
`touched_time` bigint(20) NOT NULL,
`version` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8


and node id data value is not same on both servers.