List:Replication« Previous MessageNext Message »
From:Miguel Araújo Date:March 16 2010 4:21pm
Subject:Circular Replication
View as plain text  
Hello.

I'm trying to set up a circular replication with 5 nodes. Here goes the configuration file
of each one:

-- 192.168.82.161

[mysqld]
server-id                       = 10
log-bin                         = mysql-bin
log-slave-updates               = 1
replicate-same-server-id        = 0
auto_increment_increment        = 10
auto_increment_offset           = 1
master-host                     = 192.168.82.145
master-user                     = repl
master-password                 = repl
master-connect-retry            = 60


-- 192.168.82.145

[mysqld]
server-id                       = 50
log-bin                         = mysql-bin
log-slave-updates               = 1
replicate-same-server-id        = 0
auto_increment_increment        = 10
auto_increment_offset           = 5
master-host                     = 192.168.82.163
master-user                     = repl
master-password                 = repl
master-connect-retry            = 60


-- 192.168.82.163

[mysqld]
server-id                       = 20
log-bin                         = mysql-bin
log-slave-updates               = 1
replicate-same-server-id        = 0
auto_increment_increment        = 10
auto_increment_offset           = 2
master-host                     = 192.168.82.185
master-user                     = repl
master-password                 = repl
master-connect-retry            = 60


-- 192.168.82.185

[mysqld]
server-id                       = 30
log-bin                         = mysql-bin
log-slave-updates               = 1
replicate-same-server-id        = 0
auto_increment_increment        = 10
auto_increment_offset           = 3
master-host                     = 192.168.82.183
master-user                     = repl
master-password                 = repl
master-connect-retry            = 60


-- 192.168.82.183

[mysqld]
server-id                       = 40
log-bin                         = mysql-bin
log-slave-updates               = 1
replicate-same-server-id        = 0
auto_increment_increment        = 10
auto_increment_offset           = 4
master-host                     = 192.168.82.161
master-user                     = repl
master-password                 = repl
master-connect-retry            = 60



I start all the slaves, create a database on the 192.168.82.161, everything goes ok. Now I
try to read a dump file on 192.168.82.161, and it is replication to all the servers with
no problem, but in the 192.168.82.145 I get this error:

Last_Error: Relay log read failure: Could not parse relay log event entry. The possible
reasons are: the master's binary log is corrupted (you can check this by running
'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this
by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's
or slave's MySQL code. If you want to check the master's binary log or slave's relay log,
you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.


Can someone please help me? I'm stuck with this for hours...


With best regards,
Miguel Araújo
Thread
Circular ReplicationMiguel Araújo16 Mar
  • Re: Circular ReplicationIan Simpson16 Mar
    • Re: Circular ReplicationMiguel Araújo16 Mar
      • Re: Circular ReplicationIan Simpson16 Mar
        • Re: Circular ReplicationMiguel Araújo16 Mar
          • Re: Circular ReplicationIan Simpson17 Mar
            • Re: Circular ReplicationMiguel Araújo17 Mar
              • Re: Circular ReplicationWalter Heck - OlinData.com18 Mar
                • Re: Circular ReplicationMiguel Araújo18 Mar