Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
AWS re:Postre:Post

How can we run sql on mysql RDS and get the output on SNS?

0

How can we run sql on mysql RDS and get the output on SNS?

Temas
Migración y modernizaciónAnálisisBase de datos
Etiquetas
Amazon Relational Database ServiceAurora MySQL
Idioma
English
Kanhaiya Sharma
preguntada hace un año247 visualizaciones
2 Respuestas
0

What is your use case? One way to achieve that is by using Lambda that will execute the SQL and then publish to SNS topic but there are probably other ways to achieve that. Depending on what is your desired outcome and the specific use case.

profile pictureAWS
Niko
respondido hace un año
  • Kanhaiya Sharma
    hace un año

    Hi Niko,

    I want to monitor the blocking session and locked tables in the database. Whenever blocking happens in database we should receive an alert with the details of sessions causing blocking. Also if the table is lock for more than defined time duration in my sql script then we should receive an email alert.

  • Niko
    hace un año

    Thanks for proving more context. I am not a DB specialist but I found this article - https://aws.amazon.com/premiumsupport/knowledge-center/rds-aurora-postgresql-query-blocked/ and it explains how to monitor blocked queries. As I mentioned before, you can use Lambda or other means to run a query against pg_stat_activity table to notify your admin about blocking. Hope this helps but if not let us know

0

Thanks Niko. I will try to use lambda for this.

Kanhaiya Sharma
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante