[mysql-dde] Re: Clocks Synchronization

  • From: Fabricio Mota <fabricio.mota@xxxxxxxxx>
  • To: mysql-dde@xxxxxxxxxxxxx
  • Date: Mon, 12 Dec 2005 20:37:23 -0300

Aloha,
But really this is not a critical problem that we could occupy our minds
now. But I will star it in GMail.  Maybe we think it a bit more in future.

FM


2005/12/12, Fabricio Mota <fabricio.oliveira@xxxxxxxxxxxxxxxx>:
>
> Hello
>
> ----- Original Message -----
> From: "Peter B. Volk" <PeterB.Volk@xxxxxxx>
> To: <mysql-dde@xxxxxxxxxxxxx>
> Sent: Monday, December 12, 2005 5:25 PM
> Subject: [mysql-dde] Re: Clocks Synchronization
>
>
> > Well I remember that that was a critical issue in one of the MySql
> > version.
> > My suggestion would be to evaluate the NOW() function in the Master node
> > and
> > then distribute the value to the other servers. But the problem would be
> > that the other servers would have a different internal timestamp. I
> think
> > a
> > nother chapter in the optimizationsbook should be a chapter on
> > Timefunctions. I think it should be advised that the DBAs have to sync
> the
> > clocs themselfse among the servers. Since I don't think that a Clock
> sync
> > should be part of the databases functions.
>
> Maybe you have the reason... But the problem is that sometimes we should
> not
> trust in other services, such as SO, etc.
>
> >
> > Peter
> > ----- Original Message -----
> > From: "Fabricio Mota" <fabricio.oliveira@xxxxxxxxxxxxxxxx>
> > To: "dde" <mysql-dde@xxxxxxxxxxxxx>
> > Sent: Monday, December 12, 2005 5:54 PM
> > Subject: [mysql-dde] Re: Clocks Synchronization
> >
> >
> >> Hey, man!
> >>
> >> Another problem (I'm noting all of them) hahahaha
> >>
> >> If we don't sync the clocks (and I guess it's better don't sync them),
> > what
> >> about the funcion Now() ???
> >>
> >> And if the clocks being different, the user uses the time to comparate
> >> critical values order?
> >>
> >>
> >>
> >> ----- Original Message -----
> >> From: "Peter B. Volk" <PeterB.Volk@xxxxxxx>
> >> To: "Fabricio Mota" <fabricio.oliveira@xxxxxxxxxxxxxxxx>
> >> Sent: Monday, December 12, 2005 3:42 PM
> >> Subject: Re: [mysql-dde] Re: Clocks Synchronization
> >>
> >>
> >> >
> >> > ----- Original Message -----
> >> > From: "Fabricio Mota" <fabricio.oliveira@xxxxxxxxxxxxxxxx>
> >> > To: <mysql-dde@xxxxxxxxxxxxx>
> >> > Sent: Monday, December 12, 2005 4:48 PM
> >> > Subject: [mysql-dde] Re: Clocks Synchronization
> >> >
> >> >
> >> >> Yes, I do! send me please.
> >> >>
> >> >>
> >> >> ----- Original Message -----
> >> >> From: "Peter B. Volk" <peter.benjamin.volk@xxxxxxxxxxxxxxxxx>
> >> >> To: <mysql-dde@xxxxxxxxxxxxx>
> >> >> Sent: Monday, December 12, 2005 12:45 PM
> >> >> Subject: [mysql-dde] Re: Clocks Synchronization
> >> >>
> >> >>
> >> >> > Well I know rather a lot about it since we hade about 4 lectures
> > about
> >> > it.
> >> >> > The percision is as high as good you clock hadware is. The porblem
> > with
> >> >> > cloc
> >> >> > synch is that you have a drift rate of the clock plus network
> > overhead.
> >> >> > now
> >> >> > these numbers are only detectable with multible hardwareclocks. If
> > you
> >> >> > like
> >> >> > I can send you several ppt slides that have to do with clock
> synch.
> >> >> >
> >> >> > In terms of DDE I'd like to avoid any type of clock synch because
> > this
> >> >> > would
> >> >> > make averything a lot harder.
> >> >> >
> >> >> > Peter
> >> >> >
> >> >> >
> >> >> > ----- Original Message -----
> >> >> > From: "Fabricio Mota" <fabricio.oliveira@xxxxxxxxxxxxxxxx>
> >> >> > To: "dde" <mysql-dde@xxxxxxxxxxxxx>
> >> >> > Sent: Monday, December 12, 2005 2:43 PM
> >> >> > Subject: [mysql-dde] Clocks Synchronization
> >> >> >
> >> >> >
> >> >> >> Hey man,
> >> >> >> What do you know about clocks sync in Distributed Systems? What
> >> >> >> kind
> >> >> >> of
> >> >> > precision is possible to reach among machines?
> >> >> >>
> >> >> >> Fabricio Mota
> >> >> >> Analista de Sistemas
> >> >> >> FCPC - Divisão de Planejamento do Cadastro Comercial
> >> >> >> MySql-DDE discussion list
> >> >> >> www.freelists.org/
> >> >> >>
> >> >> >
> >> >> > MySql-DDE discussion list
> >> >> > www.freelists.org/
> >> >> >
> >> >> >
> >> >>
> >> >> MySql-DDE discussion list
> >> >> www.freelists.org/
> >> >>
> >> >
> >>
> >> MySql-DDE discussion list
> >> www.freelists.org/
> >>
> >
> > MySql-DDE discussion list
> > www.freelists.org/
> >
> >
>
> MySql-DDE discussion list
> www.freelists.org/
>
>


--

Sem mais,

Fabricio Mota
Oda Mae Brown - Aprecie sem moderação.
http://www.odamaebrown.com.br

MySql-DDE discussion list
www.freelists.org/

Other related posts: