List:General Discussion« Previous MessageNext Message »
From:Cemal Dalar Date:July 12 2004 1:45pm
Subject:Re: Replication stopping
View as plain text  
To debug the problem. Make "SHOW SLAVE STATUS" in the slave and check for
the error number..

Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net

----- Original Message ----- 
From: "Nico Sabbi" <nsabbi@stripped>
To: <mysql@stripped>
Sent: Monday, July 12, 2004 6:08 PM
Subject: Replication stopping


> 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
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
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