Re: Seconds Behind the master 0 but in reality it"s over 10 minutesor hours..

Alexis Guajardo wrote:
> Are the date time set the same on both servers? What upgrade process did you use?
>
> Alexis Guajardo
> Zaynka.com
>
> On Sep 4, 2011, at 12:09 PM, Andrej Pintar wrote:
>
>> any warnings in the logs. timeouts. connects. had same thing... just can't remember what was it.
>>
>> -> never upgrade if the system works with no errors.
>>
>> did you test and simulate in the development environment?


Hm.

It seems we have sort of ethernet segment saturation problem.

We have new network environment and the slave does not recognise that he
has no connection to the master.

I set the slave_net_timeout to 5 sec. It's working as an ASAP workaround
but we're investigating the problems behind the network.

Thanks for all.

And you're right: Never upgrade it the system works... :( But we have to
move our whole server infrastructure to another place (had to left the
old ones there).

Thanks again.

--
Adam PAPAI
Grapes Communication Kft.
http://www.grapes.hu
E-mail: papai.adam@grapes.hu
Phone: +36 30 33-55-735 (Hungary)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Seconds Behind the master 0 but in reality it"s over 10 minutesor hours..

> Hm.
>
> It seems we have sort of ethernet segment saturation problem.

A possible bandaid/quick fix is turning on compression for mysql replication.


--
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org