List:General Discussion« Previous MessageNext Message »
From:Nico Sabbi Date:July 14 2004 11:15am
Subject:Re: Replication stopping
View as plain text  
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


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