From: Wagner Bianchi Date: November 29 2011 1:11pm Subject: Re: Replication issue from Cluster to Non Cluster List-Archive: http://lists.mysql.com/cluster/8223 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf3040e9a4789a4b04b2df5aac --20cf3040e9a4789a4b04b2df5aac Content-Type: text/plain; charset=ISO-8859-1 Great, Happy MySQL'ing! Best wishes, -- *Wagner Bianchi* 2011/11/29 umapathi b > Hi Guys, > > I could resolve the issue . > The issue was that as the table is having mediumtext column, the data was > not being replicated. > When I changed it to varchar , everything went fine.. > > Once again thanks to all ..and Wagner... > > - Umapathi. > > > On Tue, Nov 29, 2011 at 6:37 PM, Wagner Bianchi > wrote: > >> Could you share with us the result of SHOW SLAVE STATUS command? >> >> Best wishes, >> -- >> *Wagner Bianchi* >> >> >> 2011/11/29 umapathi b >> >>> Hi, >>> >>> I set up replcation from cluster to non-cluster. >>> For most of the tables it is working fine. But for a few tables ...it is >>> not. >>> The DML statements wrt to the table are not even logged into the binlog. >>> Anyone faced this problem earlier ? How to solve this or any other idea ? >>> Plz let me know .. >>> >>> Here are the table strucutures. >>> >>> Master >>> ----------- >>> >>> | user_admin_comments | CREATE TABLE `user_admin_comments` ( >>> `user_id` int(10) unsigned NOT NULL DEFAULT '0', >>> `support_operator` varchar(16) NOT NULL DEFAULT '', >>> `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', >>> `comments` mediumtext NOT NULL, >>> KEY `idx_user_admin_comments` (`user_id`) >>> ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 | >>> >>> Slave >>> ------------ >>> | user_admin_comments | CREATE TABLE `user_admin_comments` ( >>> `user_id` int(10) unsigned NOT NULL DEFAULT '0', >>> `support_operator` varchar(16) NOT NULL DEFAULT '', >>> `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', >>> `comments` mediumtext NOT NULL, >>> KEY `idx_user_admin_comments` (`user_id`) >>> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | >>> >>> >>> Umapathi >>> 8019133653 >>> >> >> > --20cf3040e9a4789a4b04b2df5aac--