Yes, this shouldn't be a problem. Master on InnoDB & Slaves on MyIsam. Only after a commit on the master does it get replicated to the slave. Regards P.Murali Placed At : "Heo, Jungsu" <[EMAIL PROTECTED]> on 01/03/2003 01:37:50 PM To: [EMAIL PROTECTED] cc: (bcc: Murali P/Satyam) Subject: Different Table type between MASTER and SLAVE Hello. I'm build a system aka of Shopping mall.(I think most of queies will be SELECT) For performance, MySQL will run on replication. I need TRANSACTIONs to manages orders and payment. So, Master's Table type is InnoDB. But I think that InnoDB is slower than MyISAM. (InnoDB's row level locking is very good. but, My system will query SELECT most cases) So, I decide that Master's table uses InnoDB Slave's table uses MyISAM. This has any problem? Any sugesstion will please me. Thank you for advanced answer! ########################## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php