thinkAPI

An interface to collection of thoughts and ideas about technology.

hacker emblem

Codeigniter: Separating reads and writes for scaling MySQL

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 … Continue reading →

How to skip MySQL replication counter

There are such times when MySQL replication stops when you run certain updates on the master and the slave fails. Like for example you may have run a create table or an alter table on the master and further inserts … Continue reading →