Background:
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...)
1) 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?
2) 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?
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...)
1) 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?
2) 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?
Comment