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.
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.
Comment