469,277 Members | 1,916 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,277 developers. It's quick & easy.

Time management b/w two server

2
Hi,

We have two server one in India and canada, and replication is set up in both mysql database, and its working fine. But the problem arises when i insert a query here using now() function in one server and when i see the result in same server it shows correct time, when i see in other server it is not showing the local time of other server, it shows two hours diffence time.

example: If in Indian server i fire a query using now() function and when i see in indian server i see the same time , but in canada server server i see two hours diff then that of canada local time.

can any one help me how to solve this issue, Thanks in advance.
Aug 31 '07 #1
3 1019
mwasif
801 Expert 512MB
In slave server, it saves the data with time which saved on master server not NOW(). The replication slaves have the exact data of master server.
Aug 31 '07 #2
soheb
2
hi,
Thanks for your reply.
In slave its saving different time. Not the same time.
Sep 3 '07 #3
mwasif
801 Expert 512MB
Do you have the same time zone on both the servers?MySQL Manual says...
The same system time zone should be set for both master and slave. Otherwise some statements will not be replicated properly, such as statements that use the NOW() or FROM_UNIXTIME() functions.
Sep 3 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Andrew Robinson | last post: by
3 posts views Thread by Liming | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.