Materialized view on mysql replica.
Hi all,
I have created a materialized view on the replica side expecting that when the newer record being inserted on the master instance, that insert can fire a trigger created on the table of the replica.
Unfortunately for me, this not happen. The fresh records are reflected on the tables of the replica but, it not fired the triggers, and therefore, no updates or inserts are reflected on the materialized view.
I´m trying to do this because, I don´t want to impact the master instance with the triggers to populate the materialized view.
Anybody have faced this problem?
Thank you in advance.
Subject
Views
Written By
Posted
Materialized view on mysql replica.
721
November 30, 2020 01:31PM
334
November 30, 2020 03:09PM
352
December 01, 2020 11:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.