472,127 Members | 2,063 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

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 2041
pbmods
5,821 Expert 4TB
Heya, MySQLBeginner.

Is there a benefit to doing that?
Aug 31 '07 #2
mwasif
802 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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.