Re: Different Table type between MASTER and SLAVE
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
Re: Different Table type between MASTER and SLAVE
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
passing Mysql handler to the exec'ed child
Hi , My aim is to avoid mysql connects to the DB my application does not run as a daemon . But the parent of this program runs as a daemon , so can someone tell me how I would make use of the same Mysql handler in the execed child also assuming I connect to the Mysql Server in the parent ? 1.) Connect to Mysql DB in the parent 2.) exec the child . Now how can the child make use of the same fd to ask questions to the Mysql Server ? Regards - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php