Is this possible to have a MyISAM table on master server and change its storage engine (to InnoDB) on slave server in a replication environment?
If this is possible, what should I consider before changing MyISAM to InnoDB on slave server?
Here is the table structure
- CREATE TABLE `messages` (
-
`id` int(11) NOT NULL auto_increment,
-
`subject` varchar(255) NOT NULL default '',
-
`message` text NOT NULL,
-
`attachment_path` varchar(255) default NULL,
-
`new` tinyint(4) NOT NULL default '0',
-
PRIMARY KEY (`id`)
-
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
