The first thing you need to do is to install MySQL on Server A and Server B. We'll be calling them Server A and Server B from now on. anything will do), each one responding to a specific IP address: they don't need to be identical, as long as they can both properly run the same version of MySQL Server (v5.1 or above is strongly suggested). In order to setup a MySQL Master-Master replication you'll need two different Server system instances (VPS, Hosting, virtualized instances. Once you put up a Master-Master replication mechanism between the two MySQL instances you'll basically have setup a real-time web mirror, which you can use as a disaster recovery (see picture below), and/or a 2-nodes web cluster managed by an hardware load-balancer responding to a third IP - or any other balancing technique you might want to adopt.

One of the most common scenarios involving Master-Master replication is when you have a 2 VPS (or hosting servers) environment/farm, each one providing an http web server (such as IIS or Apache) containing one or more web sites connected to a local MySQL server instance on the same machine.

A more robust, fail-proof and scalable environment, as long as you'll connect different web sites/services/apps to each of your DB and install a software or hardware http load balancer to distribute clients between them.

A 1:1 mirror your entire database pool (or a selection of your choice), ensuring you won't lose anything due to an hardware (or software/OS) crash.In order to do that you'll need a second machine/server, meaning you'll have to sustain more costs: don't make this stop you - an investment like that is hardly worthless: conversely, it will most likely be a substantial improvement for your system.

If you don't know what it is, just imagine two MySQL server instances continuosly updating each other in real-time while fullfilling their job. Master-Master replication, also known as mirror, is by far the simplest technique you can use to increase the performance and the reliability of your MySQL server installation.

Configure replication from Server B to Server A Configure replication from Server A to Server B

REPLIKATOR for ios instal