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