in this example we have 2. Now restart MySQL. Master 2 (Slave 1) Modify your MySQL config file. Add the following in [mysqld] [mysqld] server-id=2 auto_increment_offset=2 auto_increment_increment=2 lo

Here we are going to create a Master -> Master -> Slave -> Slave replications architecture. I am expecting here , you have MySQL installed and set-up as normal.       Master 1 will be known as Master 1 and Slave 2 with IP 10.1.1.1 Master 2 will be known as Master 2 and Slave 1 … Read more