List:Cluster« Previous MessageNext Message »
From:umapathi b Date:November 29 2011 11:37am
Subject:Replication issue from Cluster to Non Cluster
View as plain text  
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

Thread
Replication issue from Cluster to Non Clusterumapathi b29 Nov
  • Re: Replication issue from Cluster to Non ClusterWagner Bianchi29 Nov
    • Re: Replication issue from Cluster to Non Clusterumapathi b29 Nov
      • Re: Replication issue from Cluster to Non ClusterWagner Bianchi29 Nov
      • Re: Replication issue from Cluster to Non ClusterJonas Oreland29 Nov
        • Re: Replication issue from Cluster to Non Clusterumapathi b29 Nov
  • Re: Replication issue from Cluster to Non ClusterWagner Bianchi29 Nov