MySql Primary-Primary Replication

Tulip Festival — Captured by Vallabhaneni Sree Lasya

Step-by-step guide

Install Mysql server in both the replication servers for example Server A and Server B —

  1. server-id=1
  2. log-bin=”mysql-bin”
  3. relay-log=”mysql-relay-log”
  4. auto-increment-increment = 2
  5. auto-increment-offset = 1
  1. server-id=2
  2. log-bin=”mysql-bin”
  3. relay-log=”mysql-relay-log”
  4. auto-increment-increment = 2
  5. auto-increment-offset = 2

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vallabhaneni Sree Lasya

Vallabhaneni Sree Lasya

Software Engineer who enjoys writing, cooking, eating, travelling, working, maturing in all aspects of life :)