The goals of the system (online community) to be designed are being able to deal with
- 1.000.000 hits per hour (via https)
- 250MB/day of incoming data (text comments…)
I am trying to find the optimal storage engine combining MySQL and memcached. All reading operations would be done from memcached. MySQL would cover writing operations only (hoping that I get to manage to cache all the necessary data). Would it make sense in this case to choose MyIsam as storage engine for all the tables?
Calculating the hardware requirements, I would go for
- a quadcore, 16GB RAM for the Apache
- x times dual cores with 4-8GB each for memcached
- a quadcore, 4-8GB RAM, RAID-1, 15.000rpm HD, for MySQL
Especially the DB-Server is of concern. On one hand it is clear that after a couple of weeks the data wont fit into the RAM anymore. On the other hand, a memcached failure should not lead to a complete deasaster.
Does anyone have any experience to share regarding these questions?