Mitul,
----- Original Message ----- From: "Mitul Bhammar" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 30, 2004 7:38 AM
Subject: MIXING MYISAM AND INNODB
I'm using multiple dbs for my very high traffic multiple sites. One of my db (say parentDb) just maintains users who can login to all the sites. Others are sites specific dbs(say childDbs). I'm using INNODb tables for my parentDb while my childDbs tables are of MyISAM type. Some code does have direct joins with between parentDb and childDb.
Is it good to use this kind of mixture? Can it create problems in future?
you can mix InnoDB and MyISAM with no problems. Just remember that MyISAM does not support FOREIGN KEY constraints.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
