--- On Tue, 2/3/10, prashik pawar <pawarpras...@yahoo.co.in> wrote:
From: prashik pawar <pawarpras...@yahoo.co.in>
Subject: Re: MYSQL Replicatioin.......need HELP
To: "e- cool" <ecoolsyst...@yahoo.com>
Date: Tuesday, 2 March, 2010, 11:45 AM
Hi,
This is my slave status/master status :-
mysql> SHOW SLAVE STATUS\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.10.47
Master_User: prashikmysql
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000047
Read_Master_Log_Pos: 98
Relay_Log_File: Nilesh-relay-bin.000002
Relay_Log_Pos: 235
Relay_Master_Log_File: mysql-bin.000047
Slave_IO_Running: Yes
Slave_SQL_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: 98
Relay_Log_Space: 235
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: 0
1 row in set (0.00 sec)
ERROR:
No query specified
###################################################################
mysql> SHOW MASTER STATUS;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000047
| 98 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
Regards,
Prashik Pawar
9664384939
--- On Tue, 2/3/10, e- cool <ecoolsyst...@yahoo.com> wrote:
From: e- cool <ecoolsyst...@yahoo.com>
Subject: MYSQL Replicatioin.......need HELP
To: pawarpras...@yahoo.co.in
Cc: b.sad...@gmail.com, jitendra.gondal...@gmail.com
Date: Tuesday, 2 March, 2010, 1:14 AM
Hi,
Please send output of the "show slave status \G;"
OR
run it on slave and check following things,
---------------------------------------------------------------------------------------------------------------
1) Master_Log_File: pradip.0000xx
Read_Master_Log_Pos: 5114
--> match this bin log file and pos number name with #show master status; (
should be same /nearer )
if this matches well means your IO thread working fine.
---------------------------------------------------------------------------------------------------------------
2) Slave_IO_Running: Yes
Slave_SQL_Running: Yes
--> Check all those Yes or no.
---------------------------------------------------------------------------------------------------------------
3) Exec_Master_Log_Pos: 5114
--> This should be matched/ nearer with "Read_Master_Log_Pos" means your SQL
thread is properly working.
---------------------------------------------------------------------------------------------------------------
4) If 1st and 2nd point are not satisfied then do telnet from your
master to your slave 3306 port number. ( to check your windows firewall
blocking it or not )
---------------------------------------------------------------------------------------------------------------
Note:- For security and privacy take care for not mentioning real user-name and
passwords in configuration file.
For more clarification revert back,
Regards,
Digambar Warke
(Enjoy excellence of open source world)
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/
[Non-text portions of this message have been removed]
