View Single Post
Old 12-04-2007, 09:18 AM   #7 (permalink)
bluesaga
Super Moderator
Advanced Programmer 
 
bluesaga's Avatar
 
Join Date: Sep 2007
Posts: 165
Thanks: 0
bluesaga is on a distinguished road
Default

Its for redundancy as you guessed but it is also for speed reasons, a database that is being heavily written to will be much slower than a database with heavy reads. And thus if you mix and match the two then the database will be slower, heavy locks are incurred with some select functions (count(*)) on innodb for instance....

Also, innodb is awesome for writing, but it doesn't allow the benefits that myisam does for reading (fulltext search etc). So it is more beneficial to use innodb as a slave as Adam suggests, and doing an INSERT INTO table SELECT * FROM write_table in order to get an up to date read table!
__________________
Halo 3 Cheats
bluesaga is offline  
Reply With Quote