maria-discuss team mailing list archive

Thread
Date

New Question: Table replication with xtra column on slave

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: AskMonty KB <noreply@xxxxxxxxxxxx>
Date: Tue, 01 Sep 2015 07:55:03 -0000

Hello,

A new question has been asked in "MariaDB Community" by rahularman. Please answer it at http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
I have one table DailyMetrics on Interim server like below.
Mater DB->Secondary DB--> Interim DB
Master DB: Table DailyMetrics ( a char,b char
Secondary DB: Table DailyMetrics ( a char,b char
Interim DB: Table DailyMetrics ( a char,b char, InsertTime timestamp default current_timestamp)
 
Replication is working fine but added column InsertTime on interim DB is storing 000.000.00 00-00-00 value. It is not storing current system timestamp.
When I issue separate insert statement on slave side, it is storing system time but nor with replication.
Can anyone suggest me how to achieve system timestamp on slave side.
 
Other details as follows:
MySQl DB: MariaDB 5.5.23
Replication Type: Row based.
Platform: Linux
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/