output log for RDS stored procedure

Question

Hi Team,

I have an RDS MySQL DB (one aurora serverless and one is normal MYSQL RDS), I created a stored procedure in my DB in which I do some logs outputs :

```
log("begin of my procedure")

.....

log("bla bla bla....")

....

log("End of my procedure")
```

where can I find the output log after my stored procedure is successfully finished?

in RDS console => logs & event;  is empty no log there

in the DB cluster parameter group I enabled :  ```slow_log, server_audit_logging, general_log```

I see some logs in cloud watch but not my custom logs " "begin of my procedure", "End of my procedure"

also in RDS console => logs & event section I only see events, no logs generated

any ideas please to see my custom logs printed by my stored procedure in CWL or in rds logs & event?     thanks a lot

Answer

Hi,

The standard logging mechanisms: general/slow/audit logs do not capture query results. Since RDS/Aurora do not provide access to the host, it would not be possible to access files that are written locally, so you will need to write to a file externally to a service like S3, for example.

- Call the stored procedure from a local machine or Lambda and write the execution details to a log file. [Configure a Lambda function to query the database and write the output to a log file](https://docs.aws.amazon.com/lambda/latest/dg/services-rds-tutorial.html) has more on this. This might be the best option for your use case since you want to log more than just the result of the execution
-  If you only need the output of the procedure, you can feed it into a table and setup a pipeline to [Export MySQL Data to Amazon S3 Using AWS Data Pipeline](https://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-copydata-mysql.html)
- For Aurora MySQL, you can add [SELECT INTO OUTFILE S3](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.SaveIntoS3.html) to the procedure and save the result directly into text files stored in an Amazon S3 bucket. Note that this option doesn't support Aurora Serverless or RDS MySQL

output log for RDS stored procedure

관련 콘텐츠