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