The advantages of replication:– 1) Offload some queries from one server to other. 2) Use master for all writes and Use slave for all reads.

Some basic stuff to remember before we go ahead:– 1. Master and slave installations will be on different server instances. 2. The master should not be in use during the installation process (if master is already present).

Read on →