Codeigniter: Separating reads and writes for scaling MySQL

Posted on the August 6th, 2009 under Codeigniter, Programming by Suku

Generally websites average a ratio of 9:1 or more for reads:writes for their applications which makes MySQL replication as one of the ways to scale you web application. The simplest configuration is to separate reads and writes with all the reads coming from the slave servers.

…continue reading Codeigniter: Separating reads and writes for scaling MySQL