List:General Discussion« Previous MessageNext Message »
From:Nico Sabbi Date:July 12 2004 3:08pm
Subject:Replication stopping
View as plain text  
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
'replica@master: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
'replica@master: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

Thread
Replication stoppingNico Sabbi12 Jul
  • Re: Replication stoppingCemal Dalar12 Jul
    • Re: Replication stoppingNico Sabbi14 Jul
  • Re: Replication stoppingCemal Dalar14 Jul
  • Replication only DBArcangelo Casavola11 Mar
    • Re: Replication only DBDeluxe Web11 Mar
      • Re: Replication only DBSteve Buehler11 Mar
        • Re: Replication only DBSGreen11 Mar
        • Re: Replication only DBPeter Brawley11 Mar
          • Re: Replication only DBEric Bergen11 Mar