Aurora Usage when multiple websites are connected to it

0

I have 6 EC2 instances are connected to my Aurora database. Out of those 6, 5 host 1 website, and the last one hosts another website. How do I figure out the Aurora usage of each website separately?

2 Answers
0

as per ref;

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/MonitoringOverview.html

AWS Aurora does not provide a built-in feature to directly measure the usage of each website separately but AWS provides various monitoring tools like Amazon Aurora cluster status, Amazon CloudWatch, Amazon RDS Performance Insights, Amazon RDS Enhanced Monitoring, and others. These tools can help you monitor your AWS resources and take automatic actions when appropriate. For example, Amazon CloudWatch metrics can be used to watch a single Amazon Aurora metric over a specific time period and perform actions based on the value of the metric relative to a threshold you set

profile picture
EXPERT
answered a year ago
  • Apologies for not making my point clear, I have 2 separate schemas within the same database, and I'm unable to get the pricing according to what resources each schema in the database uses.

  • AWS does not provide pricing or resource consumption metrics at the schema level within a single database. AWS RDS, including Aurora, prices based on the resources consumed by the entire database instance, not individual schemas or databases within that instance.

    For example, if you have a single Aurora database instance with multiple databases or schemas within it, AWS does not provide separate resource usage or cost breakdowns for each individual schema. Instead, you're billed for the entire database instance, which includes the compute resources (CPU, RAM) and storage used by all databases or schemas within that instance.

0

Easy way to implement would be Enable "Performance Insights" if not already enabled.

In Performance Insights you can check the load by "Top hosts", If you are using different database or username use "Top databases or Top users"

Enter image description here

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions