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]