21 Mar 2016 @ 2:35 PM 

If you need master-master replication for your MySQL server. This example is for Centos 6 x64 but on other Linux OS the process is similar.

 

For example we have two following servers with IPs:
1.1.1.1 SERVER_A
2.2.2.2 SERVER_B

  1. Install MySQL server on both servers.yum -y install mysql-server
  2. By default, MySQL works only with localhost (127.0.0.1), so we need to edit MySQL config file /etc/my.cnf and add followingon SERVER_A:
    server-id = 1
    bind-address = 1.1.1.1
    log_bin = /var/log/mysql/mysql-bin.log
    binlog_do_db = database_for_replication
    #replicate-do-table = database_for_replication.table_for_replication (You can replicate only some table(s))
    More »
Posted By: lvlind
Last Edit: 06 Oct 2016 @ 03:51 PM

EmailPermalinkComments (0)
Tags

 Last 50 Posts
Change Theme...
  • Users » 1
  • Posts/Pages » 35
  • Comments » 0
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight

About



    No Child Pages.

Need Help?



    No Child Pages.

Check your IP



    No Child Pages.