Hi.

I'm running the binary (RPM) installation of MySQL server 2.23.39 for pc-linux-gnu
on i686 with Kernel 2.4.4 on the master and 2.4.2 on the slave.

I'm using two machines on a local network, one 192.168.0.14 and the other one
192.168.0.81.

The appropriate lines from my.cnf on the slave (192.168.0.81) follow:

[mysqld]
master-host=192.168.0.14
master-user=file
master-password=dgj469l
master-port=3306
server-id=2


The appropriate lines of my.cnf on the master (192.168.0.14) follow:

log-bin
server-id=1


Am I doing something wrong?
when I start up both of the servers, and run a SHOW SLAVE STATUS; they both
show slave_running = yes.

Further, any updates done to the master do indeed get logged, but never propigated
to the slave.

I am now getting lots of this in the slave's error log file:
010620 10:36:24  Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication
resumed in log 'FIRST' at position 35
010620 10:36:24  Error reading packet from server: bogus data in log event (read_errno
0,server_errno=65535)
010620 10:37:24  Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 35
010620 10:37:24  Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication
resumed in log 'FIRST' at position 35
010620 10:37:24  Error reading packet from server: bogus data in log event (read_errno
0,server_errno=65535)


Before I messed with it some more, the same log said:
010620 10:28:01  Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication
resumed in log 'FIRST' at position 35
010620 10:28:01  Slave: received 0 length packet from server, apparent master
shutdown:  (0)
010620 10:29:01  Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 35
010620 10:29:01  Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication
resumed in log 'FIRST' at position 35
010620 10:29:01  Slave: received 0 length packet from server, apparent master
shutdown:  (0)


Any thoughts on what's going on here??


Brian McKelvey
Perl Programmer
Netzon Internet

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to