42 Scaling MySQL
This chapter discusses how to scale MySQL operations up to include multiple servers. It covers the following exam topics:
Running multiple servers on a single host
Replicating databases from one server to another
42.1 Using Multiple Servers
It’s common to run a single MySQL server on a given machine, but it’s possible to run multiple servers. This is a common scenario when you want to test a new release of MySQL on the same machine where you run your production server. Use of multiple servers also might be desirable for administrative ...