Different Table type between MASTER and SLAVE

2003-01-03 Thread Heo, Jungsu
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

Re: Different Table type between MASTER and SLAVE

2003-01-03 Thread Murali P
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

Re: Different Table type between MASTER and SLAVE

2003-01-03 Thread Murali P
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