MySQL Scale-Out by application partitioning
Eventually every database system hit its limits. Especially on the Internet, where you have millions of users which theoretically access your database simul taneously, eventually your IO system will be a bottle neck.
Conventional solutions
In general, as a first step, MySQL Replication is used to scale-out in such a situation. MySQL Replication scales very well when you have a high read/write (r/w) ratio. The higher the better
[Read the rest of this entry...]
