MySQL Forums
Forum List  »  Replication

Materialized view on mysql replica.
Posted by: Miguel Alvarez
Date: November 30, 2020 01:31PM

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.

Options: ReplyQuote

Written By
Materialized view on mysql replica.
November 30, 2020 01:31PM

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.