MySQL Forums
Forum List  »  Stored Procedures

Find all procs that inserted/updated data at least once against AWS RDS
Posted by: Michael Zatkovetsky
Date: June 15, 2023 02:09PM

Hi! Perhaps it is not the right forum and I greatly appreciate in advance if you point me in the right direction or relocate my question.

We made a problem a while ago with making an AWS MySQL RDS Replica writable so we can run some jobs to update some tables on Replica with calculated results without sending the calculation results to Master(or Source) to be replicated back to Replica. This is how we temporarily reduced the workload from Master.

I need to find out all stored procs that are doing inserts/updates to the Replica. The issue is we do not have a dedicated set of procs just for Replicas - we create all procs on the Master and then the procs are replicated to the Replicas.
Is there a system view I can query for all DML operations that are not SELECT on Replicas?
Is there a view to see which procs execute on the Replicas as oppose to being dormant?

Many thanks in advance,

Options: ReplyQuote

Written By
Find all procs that inserted/updated data at least once against AWS RDS
June 15, 2023 02:09PM

Sorry, only registered users may post in this forum.

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.