Just today I was challenged with a project that will require value caching in a PHP/MySQL cluster environment. This project will have to deal with loads of up to 500 requests per second, most of which will involve writes. When working on a small scale it is easy to forget the latency issues associated with all engines in MySQL. This project will require a massive read/write caching system that will sit between PHP and MySQL and will require full data persistence. I found a valuable article that shows some of the timing differences of the popular storage systems under load. Redis seems to be the real winner here. With write-only data persistence (write to disk), this storage engine still comes out on top! This is truly the best system if you are caching write calls to MySQL. This way, most of the data will survive in case of a crash. Persistence can be increased even further by using another fully redundant Redis server. This is a must have for high-load write caching.
Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world’s most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or you’re a database expert searching for a fast-paced introduction to MySQL’s advanced features, this book is for you.
This book is amazing for anybody that is interested in advanced database architecture and management. I’ve started the deep dive into this book and I’ve felt inspired by the knowledge brought onto me. Every aspect of MySQL is explained in agonizing detail with performance and design aspects thoroughly explored and explained. If you feel that you may be able to achieve better results through MySQL, then this book is for you. The book contains many references to source and gives you the full rundown on the databasing engines. Perfect for figuring out that ideal configuration for your databasing needs.
