List:General Discussion« Previous MessageNext Message »
From:Cemal Dalar Date:July 14 2004 10:32am
Subject:Re: Replication stopping
View as plain text  
Ok. better check .err files in /usr/local/mysql/data/<hostname>.err for any
errors.. It seems that there isn't any problems on slave but from my
experience there can be problem on the slave like auth. For example when
"replica" user can not login to master then 'show slave status' doesn't give
any error messages but writes some lines to .err file..
Check those files both in master and in slave..

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

----- Original Message ----- 
From: "Nico Sabbi" <nsabbi@stripped>
To: <mysql@stripped>
Sent: Wednesday, July 14, 2004 2:15 PM
Subject: Re: Replication stopping


> Il lun, 2004-07-12 alle 13:45, Cemal Dalar ha scritto:
> > 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,
> it happened again just now, this is the status:
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 55463 to server version: 4.0.18-Max-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> show slave status \G
> *************************** 1. row ***************************
>           Master_Host: master
>           Master_User: replica
>           Master_Port: 3306
>         Connect_retry: 60
>       Master_Log_File: db-bin.3323
>   Read_Master_Log_Pos: 437183883
>        Relay_Log_File: server-relay-bin.005
>         Relay_Log_Pos: 228252575
> Relay_Master_Log_File: db-bin.3323
>      Slave_IO_Running: Yes
>     Slave_SQL_Running: Yes
>       Replicate_do_db:
>   Replicate_ignore_db: mysql
>            Last_errno: 0
>            Last_error:
>          Skip_counter: 0
>   Exec_master_log_pos: 437183883
>       Relay_log_space: 228252575
> 1 row in set (0.00 sec)
>
>
> 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