MySQL ODBC Connector - Multi Master Replication

Author

Multi Master Replication

Marvin Wright

2006-02-28, 8:28 pm

------ _=_NextPart_001_01C6
3BA4.F43FB082
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm having a few problems at the moment with replication.
We are in the process of migrating a cache to 2 new database machines.

As the data is a cache its very large is refreshed constantly.

Currently we have 2 machines, 1 master and 1 slave.

I am trying to set up this configuration but I just can not get it to
work.

Master --> Slave1 --> Slave2 --> Slave3

Master has id 1 and bin-log enabled

Slave1 has id 2 and bin-log enabled but also a do-bin-log=3DCache

Slave2 has id 3 and bin-log enabled

Slave3 has id 4

The process is working between Master, Slave1 and Slave2 but for some
reason Slave2 is not writing bin-log information.
So Slave3 is sitting empty and not getting any data because of no data
in Slave2's bin-log.

The idea is to get this process working correctly, then the
Slave2->Slave1 link broken and Slave2 will become the new Master.

Any idea why this could be a problem ?

All mysql versions are 4.1.12 and running on linux.

Many Thanks

Marvin Wright
Flights Developer
Lastminute.com
mwright@lastminute.com

********************
********************
********************
**********
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
********************
********************
********************
**********

------ _=_NextPart_001_01C6
3BA4.F43FB082--

Atle Veka

2006-02-28, 8:28 pm

Your subject is misleading, I would rather call this something like
Chained Replication. Unless your slaves all replicate from 'Master', in
that case your drawing is the culprit. :)

Does the error log on slave3 or slave2 indicate any problems?

Atle
-
Flying Crocodile Inc, Unix Systems Administrator

On Mon, 27 Feb 2006, Marvin Wright wrote:

> Hi,
>
> I'm having a few problems at the moment with replication.
> We are in the process of migrating a cache to 2 new database machines.
>
> As the data is a cache its very large is refreshed constantly.
>
> Currently we have 2 machines, 1 master and 1 slave.
>
> I am trying to set up this configuration but I just can not get it to
> work.
>
> Master --> Slave1 --> Slave2 --> Slave3
>
> Master has id 1 and bin-log enabled
>
> Slave1 has id 2 and bin-log enabled but also a do-bin-log=Cache
>
> Slave2 has id 3 and bin-log enabled
>
> Slave3 has id 4
>
> The process is working between Master, Slave1 and Slave2 but for some
> reason Slave2 is not writing bin-log information.
> So Slave3 is sitting empty and not getting any data because of no data
> in Slave2's bin-log.
>
> The idea is to get this process working correctly, then the
> Slave2->Slave1 link broken and Slave2 will become the new Master.
>
> Any idea why this could be a problem ?
>
> All mysql versions are 4.1.12 and running on linux.
>
> Many Thanks
>
> Marvin Wright
> Flights Developer
> Lastminute.com
> mwright@lastminute.com
>
>
>
>
> ********************
********************
********************
**********
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> ********************
********************
********************
**********
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Ravi Prasad LR

2006-02-28, 8:28 pm

Marvin,
> The process is working between Master, Slave1 and Slave2 but
>for some reason Slave2 is not writing bin-log information.
> So Slave3 is sitting empty and not getting any data because of no data
> in Slave2's bin-log.
I guess u don't have 'log-slave-updates' flag enabled also along
with bin-log in Slave1 and Slave2 in order to have the updates from master
by slave sql-thread to be logged in their bin-log.

Have a look here
http://dev.mysql.com/doc/refman/5.0...on-options.html

--Ravi

On Monday 27 February 2006 19:18, Marvin Wright wrote:
> Hi,
>
> I'm having a few problems at the moment with replication.
> We are in the process of migrating a cache to 2 new database machines.
>
> As the data is a cache its very large is refreshed constantly.
>
> Currently we have 2 machines, 1 master and 1 slave.
>
> I am trying to set up this configuration but I just can not get it to
> work.
>
> Master --> Slave1 --> Slave2 --> Slave3
>
> Master has id 1 and bin-log enabled
>
> Slave1 has id 2 and bin-log enabled but also a do-bin-log=Cache
>
> Slave2 has id 3 and bin-log enabled
>
> Slave3 has id 4
>
> The process is working between Master, Slave1 and Slave2 but for some
> reason Slave2 is not writing bin-log information.
> So Slave3 is sitting empty and not getting any data because of no data
> in Slave2's bin-log.
>
> The idea is to get this process working correctly, then the
> Slave2->Slave1 link broken and Slave2 will become the new Master.
>
> Any idea why this could be a problem ?
>
> All mysql versions are 4.1.12 and running on linux.
>
> Many Thanks
>
> Marvin Wright
> Flights Developer
> Lastminute.com
> mwright@lastminute.com
>
>
>
>
> ********************
********************
********************
**********
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> ********************
********************
********************
**********

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

alexj

2006-02-28, 8:28 pm

On Mon, 27 Feb 2006, Marvin Wright wrote:

> Hi,
>
> I'm having a few problems at the moment with replication.
> We are in the process of migrating a cache to 2 new database machines.
>
> As the data is a cache its very large is refreshed constantly.
>
> Currently we have 2 machines, 1 master and 1 slave.
>
> I am trying to set up this configuration but I just can not get it to
> work.
>
> Master --> Slave1 --> Slave2 --> Slave3
>
> Master has id 1 and bin-log enabled
>
> Slave1 has id 2 and bin-log enabled but also a do-bin-log=Cache
>
> Slave2 has id 3 and bin-log enabled
>
> Slave3 has id 4
>
> The process is working between Master, Slave1 and Slave2 but for some
> reason Slave2 is not writing bin-log information.
> So Slave3 is sitting empty and not getting any data because of no data
> in Slave2's bin-log.

for slaves to log data from the master into the binlog you should set log-slave-updates=on

Thanx
Alex

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links