Re: Slave is not updated

Jeetendra Ranjan Thu, 24 Dec 2009 00:19:27 -0800

Hi Dilip,

Thanks for your response


I already run the below command at master:

grant replication slave on *.* to 'mysqladm'@'95.84.86.41' identified by'admmysql';



Thanks
Jeetendra Ranjan

----- Original Message -----From: "Parikh, Dilip Kumar" <[email protected]>To: "Jeetendra Ranjan" <[email protected]>;<[email protected]>

Sent: Thursday, December 24, 2009 1:10 PM
Subject: RE: Slave is not updated

You can see connecting to master means it is not able to establish the
connection from slave to master, give the grants as (replication client
etc..)
and then try again.

Thanks,
Dilipkumar
Database Engineering
Pager mail:[email protected]

-----Original Message-----
From: Jeetendra Ranjan [mailto:[email protected]]
Sent: Thursday, December 24, 2009 1:05 PM
To: [email protected]
Subject: Slave is not updated

Hi,

I am getting this information from slave

mysql> show slave status \G;
*************************** 1. row ***************************
            Slave_IO_State: Connecting to master
               Master_Host: 201.107.236.77
               Master_User: root
               Master_Port: 3306
             Connect_Retry: 60
           Master_Log_File: ip-201-107-236-77-bin.000042
       Read_Master_Log_Pos: 4702
            Relay_Log_File: ip-95-84-86-41-relay-bin.000001
             Relay_Log_Pos: 98
     Relay_Master_Log_File: ip-201-107-236-77-bin.000042
          Slave_IO_Running: No
         Slave_IO_Running: Yes
           Replicate_Do_DB:
       Replicate_Ignore_DB:
        Replicate_Do_Table:
    Replicate_Ignore_Table:
   Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                Last_Errno: 0
                Last_Error:
              Skip_Counter: 0
       Exec_Master_Log_Pos: 4702
           Relay_Log_Space: 98
           Until_Condition: None
            Until_Log_File:
             Until_Log_Pos: 0
        Master_SSL_Allowed: No
        Master_SSL_CA_File:
        Master_SSL_CA_Path:
           Master_SSL_Cert:
         Master_SSL_Cipher:
            Master_SSL_Key:
     Seconds_Behind_Master: NULL


The Slave_IO_Running is always No even after repeating below steps so
many times

stop slave

CHANGE MASTER TO ....

and

start slave



Please guide why this is always NO and how do i enable it ?

Regards

Jeetendra Ranjan



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[email protected]

Re: Slave is not updated

Reply via email to