If this is possible, what should I consider before changing MyISAM to InnoDB on slave server?
Here is the table structure
Expand|Select|Wrap|Line Numbers
- 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;