[maatkit-discuss] UTC timestamps for mk-heartbeat
Brought to you by:
daniel_nichter
|
From: Neil L. <nei...@tr...> - 2008-07-08 23:18:46
|
Just wondering if there has ever been any consideration of this when
monitoring replication to a slave in a different timezone.
Seems to be the quick fix is to replace now() references with
UTC_TIMESTAMP()[including UNIX_TIMESTAMP(UTC_TIMESTAMP()) but this is
not exactly portable.
Second consideration here is to use a:
strftime("%Y-%m-%d %H:%M:%S",gmtime)
and similar comparisons or include dependancies to other Modules to
handle time comparisons.
Thoughts?
Neil
|