优化大型逐步增加的数据库[关闭]

Question

I am about to create a PHP web project that will be consisting of a large database. The database will be MYSQL and will store more than 30000 records per day. To optimize the DB I thought to use MEMCACHED library with it. Am i going the correct way or some other alternative can be used to overcome the data optimization problem. I just want to provide faster retrieval and insertion. Can somebody advise me which tool should I use and how, as the data will gradually increase at a higher rate ? Should i use object relational mapping concept too ?

Answer 1

You can use Master & Slave technique for this purpose. Basically it would be combination of 2 db first for read operation and other for write operation.