My current database design uses MyIsam mainly as the storage engine, I wonder if its possible to split some of the tables into MyIsam and some into Innodb in the same database. Reason of switching some of the tables to Innodb is because i need row-based locking which Innodb offers. I am not too sure whether this would have any effect on replication?
A:
No, it's totally safe for replication to have multiple table type in your database. I have MyISAM and InnoDB table, and i use replication over 7 slaves, never had a problem.
Mikushi
2010-04-09 16:54:07
Thanks. Wat about mysql configuration. Can you a balance the load between the two storage engine?
ychian
2010-04-10 14:17:33
If it's in the same database, don't think so. The load balancing happens between different MySQL Server, not tables.
Mikushi
2010-04-22 15:00:16