So far we've looked at many aspects of MySQL, not in any great depth, but hopefully with enough information to get you started and whet your appetite for more. Now we start to look into areas that aren't in the basic tutorials.
Replication is the technology that allows data to be stored on multiple servers. Typically this is used in "scale out" applications. "Scale out" is used in contrast to "Scale up" where to scale a solution you buy a bigger box to run it on, where "scale out" means you buy more boxes. Each has its benefits and drawbacks, with the usual benefit of scale out being that you get more bang for your buck.
The way replication works in MySQL is pretty simple. One server is identified as the master, and writes every transaction to a file, the binary log. Other servers (and there may be many) act as slaves and[Read more...]