In this case, slave server is not able to connect to master, check user privileges and if
there is any firewall blocking communication.
Best wishes,
Eber.
--- Em qua, 3/6/09, Ian Simpson <ian@stripped> escreveu:
De: Ian Simpson <ian@stripped>
Assunto: Re: Fwd: Slave does't update data from master
Para: "Walter Cervini" <wcervini@stripped>
Cc: "replication" <replication@stripped>
Data: Quarta-feira, 3 de Junho de 2009, 9:04
Forwarded to the list, since I think you wanted reply all there ;)
On Thu, 2009-06-04 at 07:24 +1930, Walter Cervini wrote:
>
> On the master Server do: show master status;
> On the slave: Show slave status\G;
> Compare this values on both servers
> Master Log_file
> Master_log_pos on Master and Exec_Master_Log_Pos on Slave.
>
> Walter Cervini
> movil: 0424-1543350
> 0412-2042186
> Pin: 20911CF3
>
>
> On Thu, Jun 4, 2009 at 06:39, Ian Simpson <ian@stripped>
> wrote:
> If the IO thread isn't running, the reason is
> normally logged
> in the
> main MySQL error log. Try restarting the slave
> and then
> checking for the
> most recent entries in this log; they should
> help with the
> problem.
>
>
> On Wed, 2009-06-03 at 18:02 +0700, saiful haqqi
> wrote:
> > Thang's Shastry for your replay,
> > how I make sure that IO is running? I
> doing all step at
> tutorial from mysql.
> > this is my.cnf
> > server-id=2
> > master-host=192.168.1.17
> > master-connect-retry=60
> > master-user=repl
> > master-password=repl
> > replicate-do-db=sentinusa
> > relay-log = "D:/Program
> Files/xampp/mysql/slave-relay.log"
> > relay-log-index = "D:/Program
> Files/xampp/mysql/slave-relay-log.index"
> > and then, i use this mysql command
> > mysql> slave stop;
> > mysql> CHANGE MASTER TO
> MASTER_HOST='192.168.1.17',
> MASTER_USER='repl',
> > MASTER_PASSWORD='repl',
> MASTER_LOG_FILE='mysql-bin.000001',
> > MASTER_LOG_POS=98;
> > Query OK, 0 rows affected (0.02 sec)
> > mysql> slave start;
> > with phpmyadmin, i get message like
> first:
> > Slave_IO_State:Connecting to master
> > Slave_IO_Running: NO
> > Slave_SQL_Running: Yes
> > is any wrong with my step?
>
> --
> Ian Simpson
> System Administrator
> MyJobGroup
>
>
> --
> MySQL Replication Mailing List
> For list archives:
> http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe: http://lists.mysql.com/replication?unsub=1
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
