I really need any advice about this kind of architecture :
A Master -> 4 slaves servers configuration with this particularity :
Most tables on the master are created with the InnoDB storage engine (others with MyISAM -> InnoDB is not needed for them) and the same tables are created on each salve server BUT with MEMORY Storage Engine.
Database will be about 3GB, slave servers (3.2GHZ Xeon processor) have 12MB of memory (at least 8MB of free memory). The 4 biggest (and most accessed) tables contains about 2 million rows. Others are smaller (10k or 100k rows).
The main idea behind this is to provide four very high performance MySQL slaves for our 4 load balanced webapps running on each server.
I’ve already built a sample of this architecture, running on a single server. I’ve solved the slave crash issue (how to recover the full data loss because of the MEMORY engine) but before going further, I want you to give me your opinion.
Thank you and… happy new year )