|
Home > Archive > MySQL ODBC Connector > September 2005 > Binary Logs not updating
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Binary Logs not updating
|
|
| James Green 2005-09-26, 7:23 am |
| Hi,
Intend on the following replication scenario:
A -> B -> C
A is replicating to B no problem.
B was copied to C.
C was ordered to begin replicating from B, but saw no updates
Checked on B, and although mysql 'show variables' states binary logging
in 'ON', no updates are being written to the logs except the relay-log.
Can someone please advise? Using InnoDB's hotbackup.pl file to perform
the backups.
Cheers,
--
James Green
--
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 2005-09-26, 7:23 am |
| Hi James,
If you want to configure a relay replication server, i.e. make the
replication to pass data from slave to another slave as A->B->C you need to
start B with --log-bin and --log-slave-updates.So check that
log-slave-updates has been included in your my.cnf file.
You can read more about this
http://www.mysql.com/news-and-event...0000000270.html
Thanks,
Ravi
On Monday 26 September 2005 17:01, James Green wrote:
> Hi,
>
> Intend on the following replication scenario:
>
> A -> B -> C
>
> A is replicating to B no problem.
> B was copied to C.
> C was ordered to begin replicating from B, but saw no updates
> Checked on B, and although mysql 'show variables' states binary logging
> in 'ON', no updates are being written to the logs except the relay-log.
>
> Can someone please advise? Using InnoDB's hotbackup.pl file to perform
> the backups.
>
> Cheers,
>
> --
> James Green
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|