List:General Discussion« Previous MessageNext Message »
From:Fred van Engen Date:January 3 2003 4:20pm
Subject:Re: Replication and the function now()
View as plain text  
Remi,

n Fri, Jan 03, 2003 at 10:56:21AM -0500, Remi Lanteigne wrote:
> I would like to know if there is a way of telling mysql to transfer the
> value of the function now() in it's replication, as it is now (from what I
> see in the binlog file) mysql passes the now() to the slave instead of the
> value, this causes a difference in my 2 databases.
> 

In my 3.23.52 binlog I see this before each time related update:

SET TIMESTAMP=1039489014;

Each time with the current timestamp of course. I haven't checked
if it is actually used by the slave however.


Regards,

Fred.

-- 
Fred van Engen                              XB Networks B.V.
email: fred.van.engen@stripped                Televisieweg 2
tel: +31 36 5462400                         1322 AC  Almere
fax: +31 36 5462424                         The Netherlands
Thread
Replication and the function now()Remi Lanteigne3 Jan
  • Re: Replication and the function now()Fred van Engen3 Jan
Re: Replication and the function now()Fred van Engen3 Jan