StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhat's the best practice to set timezone for globally distributed php-mysql application?
text
Body
copied!<p>For a globally distributed application, each server might be in different timezone, the default timezone for each server could be different. </p> <p>By default, I mean that the server has no idea what would be installed on the server when it's installed with php and mysql.</p> <p>So, should I just work this way? To use the default timezone, let the server guy install everything in the default timezone and make sure the php and mysql have the same timezone? </p> <p>I think this way is a de-coupled way so the application won't need to set timezone both on php or on mysql. All the application would be doing is to get the timezone if it needs to do something about it. </p> <p>I had this concern because some application seems trying to set php or mysql timezone, even try to sync them. I am not quite sure about this. It seems complicating things. </p> <p>Suggestion?</p> <p>Plus:</p> <p>From <a href="http://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html</a></p> <blockquote> <p>The same system time zone should be set for both master and slave. Otherwise, statements depending on the local time on the master are not replicated properly, such as statements that use the NOW() or FROM_UNIXTIME() functions.</p> </blockquote> <p>Does this mean that my "de-coupled" way is a bad idea for master-slave settings?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload