Prashik,
Things are seems to be fine after looking at SHOW SLAVE STATUS, master n slave are in sync try to create database on your master server n check whether it's getting replicated on your slave server or not JITENDRA From: Linux_Mantra@yahoogroups.com [mailto:linux_man...@yahoogroups.com] On Behalf Of prashik pawar Sent: Tuesday, March 02, 2010 11:47 AM To: Linux_Mantra@yahoogroups.com Subject: [Linux_Mantra] Fw: Re: MYSQL Replicatioin.......need HELP --- On Tue, 2/3/10, prashik pawar <pawarpras...@yahoo.co.in <mailto:pawarprashik%40yahoo.co.in> > wrote: From: prashik pawar <pawarpras...@yahoo.co.in <mailto:pawarprashik%40yahoo.co.in> > Subject: Re: MYSQL Replicatioin.......need HELP To: "e- cool" <ecoolsyst...@yahoo.com <mailto:ecoolsystems%40yahoo.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 <mailto:ecoolsystems%40yahoo.com> > wrote: From: e- cool <ecoolsyst...@yahoo.com <mailto:ecoolsystems%40yahoo.com> > Subject: MYSQL Replicatioin.......need HELP To: pawarpras...@yahoo.co.in <mailto:pawarprashik%40yahoo.co.in> Cc: b.sad...@gmail.com <mailto:b.sadhiq%40gmail.com> , jitendra.gondal...@gmail.com <mailto:jitendra.gondaliya%40gmail.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] [Non-text portions of this message have been removed]
