In the previous article I discussed using Read Replication
Clustering to scale out reads for a website. What I will now do
is describe a refined approach to the problem of scaling by
creating "Application Clusters with Replication".
A common approach to website design is that a web designer creates a website and decides that search is a feature that they want to implement. If they use the MyISAM engine this means that they can add fulltext indexes to their tables and then make use of them in queries. I will ignore the case where the developer decides that an unanchored LIKE clause is an appropriate solution, since this developer will quickly hit a wall on performance and …