[ale] MySQL DATETIME

[cfowler at outpostsentinel.com (Chris Fowler)]

I think I just found out something nasty.

ubuntu at arm:~$ date;salt 'select 
inbound_call_log_id,started,UNIX_TIMESTAMP(started) from 
inbound_call_log limit 1'
Sat May 31 00:16:56 UTC 2014
+---------------------+---------------------+-------------------------+
| inbound_call_log_id | started             | UNIX_TIMESTAMP(started) |
+---------------------+---------------------+-------------------------+
|                   1 | 2014-05-22 16:53:39 | 1400777619 |
+---------------------+---------------------+-------------------------+

[support at support ~]$ date ; mysql  -h 127.0.0.1 -e 'select 
inbound_call_log_id, started,UNIX_TIMESTAMP(started) from 
inbound_call_log limit 1' SALT;
Fri May 30 20:16:40 EDT 2014
+---------------------+---------------------+-------------------------+
| inbound_call_log_id | started             | UNIX_TIMESTAMP(started) |
+---------------------+---------------------+-------------------------+
|                   1 | 2014-05-22 16:53:39 | 1400792019 |
+---------------------+---------------------+-------------------------+
[support at support ~]$

support is a mysql slave.  Does this mean my data is only valid if I 
restore it on a server in the UTC zone?  The slave is in US/Eastern and 
the master is in UTC.

Chris

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20140530/2f6e8e3e/attachment.html>