Re: Mysql replication
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.
Subject
Views
Written By
Posted
5363
August 21, 2012 04:07AM
2303
August 22, 2012 09:51PM
5464
August 24, 2012 12:14AM
3189
August 24, 2012 02:27AM
Re: Mysql replication
2868
August 26, 2012 06:20PM
2893
August 27, 2012 08:32AM
2561
August 27, 2012 05:55PM
2180
August 24, 2012 04:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.