"Bill Thomason" <[EMAIL PROTECTED]> wrote: > Here is my scenario: > > I have 3 linux boxes - 2 with mysql 4.0.16 and 1 with 4.0.17. > > I have a 4.0.16 master (sys1) replicating a database (db1) that is > roughly 1.5GB to a slave system (sys2) running 4.0.17. For the sake of > a formal representation I'll say that (sys1,db1) --> (sys2,db1) > represents this relationship. > > On sys2 we run an application that inspects the replication of db1 and > maintains information in a different database (db2). I would like sys2 > to replicate db2 to our third system (sys3) which happens to be running > version 4.0.16. (sys2,db2) --> (sys3,db2). > > In this situation, can system sys2, who is a slave to sys1 for db1, be a > master for db2 to a slave system sys3? > > If this is possible could someone help me by inspecting my my.cnf files > and tell me why the second step (sys2,db2) --> (sys3,db2) does not > replicate? > > Here are pieces of the my.cnf files that should be relevant. If someone > can tell me what I'm doing wrong or has some suggestions I would greatly > appreciate it. > > my.cnf from sys1: > > ============== > > [mysqld] > log-bin > bind-address = 192.168.1.2 > server-id=1 > log-bin=sys1-bin > log-bin-index=sys-bin.index > binlog-do-db=db1 > set-variable = max_binlog_size=20M > > my.cnf from sys2: > > ============== > > [mysqld] > log-bin > bind-address = 192.168.1.3 > server-id=2 > master-host=192.168.1.2 > master-user=sys2 > master-password=sys2password > master-port=3307 > master-connect-retry=60 > replicate-do-db=db1 > log-warnings > log-slave-updates > report-host=192.168.1.3 > report-port=3307 > log-bin=sys2-bin > log-bin-index=sys2-bin.index > binlog-do-db=db2 > set-variable=max_binlog_size=20M > > my.cnf from sys3: > > ============== > > bind-address=192.168.1.4 > server-id=3 > master-host=192.168.1.3 > master-user=sys3 > master-password=sys3password > master-port=3307 > replicate-do-db=db2 > log-warnings > log-slave-updates > master-connect-retry=60 > report-host=192.168.1.4 > report-port=3307
What is the output of SHOW SLAVE STATUS for the sys3? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]