I have set up a master and slave whose versions are (using 'show =
variables') S: 3.23.47-nt, M: 3.23.47-nt-log. They were both installed =
from the same distribution zip. I can't get replication going even =
though the server and client status seem ok (slave running and file and =
position information on master).
On master: Grant file on *.* to astusreplic@"%" identified by 'password'
Master my.cnf:=20
log-bin
server-id=1
Slave my.cnf
master-host=SMCCREA
master-user=astusreplic
master-password=password
master-port=3306
server-id=3
Error messages on slave:
030715 8:53:16 Slave: connected to master '[EMAIL PROTECTED]:3306', =
replication started in log 'FIRST' at position 32
030715 8:53:16 Slave: received 0 length packet from server, apparent =
master shutdown: (0)
030715 8:53:16 Slave: Failed reading log event, reconnecting to retry, =
log 'FIRST' position 32
030715 8:53:16 Slave: reconnected to master =
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at =
position 32
show processlist output:
id=1, user=system user, host=none, db=null, command=connect, =
time=110, state=Waiting to reconnect after a failed read, Info=null
-----------------------------------------------------------------------
Steve McCrea eng.
Director of Software Development
ETL Electronique
2396 de la Province
Longueuil Qc, J4G 1G1, Canada
Phone: (450) 442 7887 - 229
Fax: (450) 442 0605
