469,276 Members | 2,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,276 developers. It's quick & easy.

MyISAM on master and InnoDB on slave server

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
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE `messages` (
  2.   `id` int(11) NOT NULL auto_increment,
  3.   `subject` varchar(255) NOT NULL default '',
  4.   `message` text NOT NULL,
  5.   `attachment_path` varchar(255) default NULL,
  6.   `new` tinyint(4) NOT NULL default '0',
  7.   PRIMARY KEY  (`id`)
  8. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Aug 29 '07 #1
2 1943
pbmods
5,821 Expert 4TB
Heya, MySQLBeginner.

Is there a benefit to doing that?
Aug 31 '07 #2
mwasif
801 Expert 512MB
You can have different storage engines on master and slave.
Aug 31 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by steve | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.