List:Replication« Previous MessageNext Message »
From:<list Date:June 23 2011 9:37pm
Subject:Mysql 5.5 multi master replication
View as plain text  
Working with Mysql 5.5 and I am having no luck getting a two node multi
master replication setup going.  Here are my configs so far:

Server 1 - 10.123.70.10
------------------------------
master.info:

mysql-bin.000007
10.123.70.11
repl
replpassword
3306
1800.000

my.cnf:

bind-address = 10.123.70.10

server-id=1
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=cmgapp,puma

relay-log=mysqld-relay-bin
log-slave-updates

auto_increment_increment = 10
auto_increment_offset = 1
 
Server 2 - 10.123.70.11
------------------------------
master.info:

mysql-bin.000007
10.123.70.10
repl
replpassword
3306
1800.000

my.cnf:

bind-address = 10.123.70.11

server-id=2
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=cmgapp,puma

relay-log=mysqld-relay-bin
log-slave-updates

auto_increment_increment = 10
auto_increment_offset = 2

Any advice, or a link to an example setup would be much appreciated.

Thread
Mysql 5.5 multi master replicationlist23 Jun
  • Re: Mysql 5.5 multi master replicationRick James24 Jun
Re: Mysql 5.5 multi master replicationRick James24 Jun
  • Re: Mysql 5.5 multi master replicationAlexis Guajardo25 Jun
    • Re: Mysql 5.5 multi master replicationRick James25 Jun
      • Re: Mysql 5.5 multi master replicationAlexis Guajardo25 Jun
        • Re: Mysql 5.5 multi master replicationRick James2 Jul
          • Re: Mysql 5.5 multi master replicationAlexis Guajardo2 Jul