Hi,
often my slave suddenly stops, reporting these the logs:
040712 12:19:00 Slave I/O thread exiting, read up to log 'db-bin.3323',
position 197564621
040712 12:19:10 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'db-bin.3323' at
position 197564621
040712 13:48:22 Slave I/O thread exiting, read up to log 'db-bin.3323',
position 208931388
040712 13:48:25 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'db-bin.3323' at
position 208931388
this is the configuration of the slave:
[mysqld]
log-bin
server-id=20
master-host=master
master-port=3306
master-user=replica
master-password=***********
replicate-ignore-db=mysql
replicate-wild-do-table=db1.prc
replicate-wild-do-table=db2.provincia_rc
replicate-wild-do-table=db3.tc
replicate-wild-do-table=prc.%
master-connect-retry=60
slave-skip-errors=all
How can I understand exactly what is stopping the replication?
Thanks,
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]