3.4.1.1. Objectives

Our goal is to use replication in order to improve the throughput of the service by adding more servers which will become replicas of the already existing server. These replicas will allow scaling out of the service by taking up all the read requests, leaving the old server (now called the master) only in charge of the writes. Rather than doing everything "by hand" with the mysql command line, we are going to setup this replication scenario using a single script, mysqlreplicate which will do most of the hard work for us. We then check the result using the mysqlrpladmin utility.

Lets assume the existing server, Server1, is running on port 13001 on the local machine with IP 192.168.1.1 and that we want to add 2 new servers, Server2 running on 192.168.1.2:13001 and Server3 running on 192.168.1.3:3306.


User Comments
Sign Up Login You must be logged in to post a comment.