Comments - Table replication with xtra column on slave
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hello,
You can investigate a new 10.1 feature made for this case. https://mariadb.com/kb/en/mariadb/running-triggers-on-the-slave-for-row-based-events/
Such architecture looks complex to maintain as the middle slave data will be in definition different from the master. If you reload the master from a logical backup, it should be ok to get the new reload time in the slave ?
/svar
Ultimate goal is to record time whenever there is any insert into table. That is why new column InsertTime is introduced with TIMESTAMP default current_timestamp.
Can you please suggest how can I keep track of inserts on table?
I saw and found that your 10.1 is alpha version that means it can't be used for production env. how can you suggest to use alpha version of db?
The latest MariaDB 10.1 release is not an alpha, it's a release candidate.