hope you all are doing well. I am undergoing a scenario where i need to trigger a lambda function whenever a read replica is promoted. It shouldn't be a failover scenario every time but I can just manually promote and it should trigger the lambda function.
I have tried creating a event of Cloudtrail, RDS, AWS API Call via Cloudtrail. Nothing helps. I looked into logs and still no luck.
Is there a way to solve this problem?