List:Replication« Previous MessageNext Message »
From:Rick James Date:June 23 2011 11:40pm
Subject:Re: Mysql 5.5 multi master replication
View as plain text  
"no luck" is rather vague.

For both servers...
What does mysqld.err say?
SHOW SLAVE STATUS \G
SHOW MASTER STATUS;
SHOW GRANTS FOR repl@'%';

On 6/23/11 2:37 PM, list@stripped wrote:
> 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.
>
>

-- 
Rick James - MySQL Geek

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