replication - MySQL : Timestamps replicating inconsistently depending on local timezone of server? -

-

can explain mysql 5.5 handling of replication between 2 servers.

this structure of 1 of table.

id int(10) unsigned not null primary key default 'null' auto_increment kot_no varchar(45) not null default 'null' emp_id int(10) unsigned not null foreign key default '0' description varchar(45) null default 'null' created_date timestamp not null default '0000-00-00 00:00:00' created_by int(10) unsigned not null default '0' modified_date timestamp not null default 'current_timestamp on update current_timestamp' modified_by int(10) unsigned null default '0' state tinyint(1) unsigned not null default '1'

in database every table has last 5 columns , binlog format statement based replication

when i'm executing insert kot (kot_no, emp_id, created_date) values (1, 1, now()) on server these results on 2 servers.

on server a

id  kot_no  emp_id  description  created_date         created_by  modified_date        modified_by  state 1   1       1       null         2015-11-01 22:51:57  0           2015-11-01 22:51:57  0            1

on server b

id  kot_no  emp_id  description  created_date         created_by  modified_date        modified_by  state 1   1       1       null         2015-11-02 12:21:57  0           2015-11-02 12:21:57  0            1

i had naively assumed dates stored in utc in database , effect of localtime display purposes? can shed light on what's happening here , tell me solution without affecting server data?

problem mysql timezone different in both server

check timezone query :-

select @@global.time_zone;

or can set timezone :-

set global time_zone = '+8:00';//your timezone  set global time_zone = 'europe/helsinki';////your timezone  set @@global.time_zone='+00:00';////your timezone

more details


Comments

Post a Comment

Popular posts from this blog

javascript - Slick Slider width recalculation -

-
i'm trying add slide in panel on slick container css. carousel works except new width not being calculated when space has been added. recalibrate once advance next slide i'd happen each time panel opened or closed. i've tried adding both margin , padding, neither makes difference. ideas? https://jsfiddle.net/mhigley/dpf7mlpl/ html: <button type="button" id="button"><i class="fa fa-arrow-right"></i></button> <aside> <h2>slide in panel</h2> <ol> <li>list item</li> <li>list item</li> <li>list item</li> <li>list item</li> <li>list item</li> </ol> </aside> <main role="main"> <div class="sections"> <section> <article> <h2>first slide</h2> <p>lorem ipsum d...
Read more

jsf - PrimeFaces Datatable - What is f:facet actually doing? -

-
looking through primefaces code in app noticed following line: <f:facet name="header">#{trainsearch.traincount} trains</f:facet> it looks overriding header, makes sense, can explain me in little more detail? what happening line of code? complete code listed below: <p:datatable id = "results" value = "#{trainsearch.trains}" var = "train" rendered="#{not empty trainsearch.trains}" styleclass = "train-search-table horizontal-border"> <f:facet name="header">#{trainsearch.traincount} trains</f:facet> <p:column headertext = "train id"> <p:panelgrid columns="1" styleclass = "train-id-grid" layout = "grid"> <h:outputtext styleclass = "train-id-label" value="#{train.traini}"/> <h:outputtex...
Read more

angular2 services - Angular 2 RC 4 Http post not firing -

-
i trying fire post request app , it's not working, tried multiple ways. don't see request being fired under network tab in chrome. not sure problem is, appreciated. import { injectable } '@angular/core'; import { http, headers } '@angular/http'; @injectable() export class userservice{ private _url="users"; constructor(private _http: http){ } checkifusernameexists(username){ return this._http.get(this._url+"/"+username) .map(response => response.json()) } createuser(user){ let headers = new headers(); headers.append('content-type', 'application/json') console.log(json.stringify(user)); return this._http.post(this._url, json.stringify(user),{headers: headers}) .map(response => response.json()) } } first need capture error , solve error: this._http.post(this._url, json.stringify(user),{headers: headers}) .subscribe( ...
Read more