I am working on a website for movie reviews. In the current design, the front-end( jQuery, HTML, CSS) connects with the model (individual php scripts which deals with MYSQL database) for basic storage and retrievals. This trivial design will work for small traffic.
My concern is how to tackle problems related to heavy traffic with many requests coming in at the same time. What are the design changes i should do to the model part to handle heavy traffic and make the system scalable?
PS: please let me know if you need more info.
Thank you
http://redis.io/ - Redis allows your database to be memory-resident with lazy writes back to disk. This greatly improves DB performance. Pour in a bucket of RAM first. Memcached is also a popular tool, but not as feature-packed.