Could you share with us the result of SHOW SLAVE STATUS command?
Best wishes,
--
*Wagner Bianchi*
2011/11/29 umapathi b <umapathi.b@stripped>
> 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
>
