Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqlexpress database file auto-creation error, dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO

Links

XODOX
Impressum

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

Posted on 2011-09-05 07:46:31 by Adam PAPAI

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<api984@gmail.com> 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

Report this message

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

Posted on 2011-09-06 07:12:40 by Rob Wultsch

> 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

Report this message