[3rd Party apps] Cost data not available for Amazon RDS

[DamienCSFR]

Description

The cloud Optimizer is not showing any data for an Amazon RDS entities or on the Workloads section

Assessment

The issue here with the cost is maybe only a configuration issue. There is something not communicating to identify the customers engines to grab costs from an API so no calculations can be rendered.

Steps to Reproduce

On the Amazon RDS entities, it show 21 entities but when we click , there is no data

When clicking on the workload section, we can choose the dedicated workload created for the occasion but it ask to enter manualy the costs.

Expected

We were expected to get the cost data automatically

[jpvajda]

Evaluating urgency on this issue with @DamienCSFR

[jpvajda]

from @LizBaker i’ve been poking around and when i impersonate the user i see a lot of console logs saying the instances have no pricing data. i checked out their rds entities and i see none of them have an engine listed. the app needs to know the engine being used (mysql, redis, etc) in order to get the pricing data. however, i’m not sure how new relic normally gets the engine. seems like something that would happen automatically with integration, but maybe it’s something you set in a configuration.

[jpvajda]

@Kav91 may have some insights into this issue.

[Kav91]

Hi @DamienCSFR can you share what database/engine setup you are experiencing the issue with? Trying to think how best to replicate your situation so we can debug this one better.

[biohazardvos]

Hello, @Kav91! We're using MariaDB RDS. None of reported to the NewRelic instances has pricing information.

[Kav91]

@biohazardvos I'm not able to replicate the issue I just spun up a db.t3.micro mariadb RDS instance and it appears with pricing information.

Can you click on Amazon RDS, then show optimization candidates and then screenshot the table below or at least the row where the mariadb instance is, or share that it isn't in that table.

Also are you able to do the below NRQL Query update the database name, change the chart type to JSON and then provide me the output please.

SELECT * FROM DatastoreSample WHERE provider='RdsDbInstance' AND entityName = 'yourDatabaseName' LIMIT 1

The third screenshot you have is a feature you should not be using for RDS cost analysis, this is to help estimate on-premise based costs. So do not use that for this scenario.

[biohazardvos]

Hello! @Kav91 here are the results:

• Page loading
• Page data
• Query result

[Kav91]

@biohazardvos if you're not getting anything from the query result your issue is not to do with Cloud Optimize at all then. You need to check if the AWS integration is correctly configured for your account, and the entity is reporting in the platform. If the entity is reporting then you need to confirm if DatastoreSample's are being generated for that entity as you were doing above.

[biohazardvos]

@Kav91 it is configured -- I can see EC2 instances info and total number of RDS instances. How can I check if DatastoreSample's are being generated?

[Kav91]

@biohazardvos with that same query above but you need to update the query with your database/entity name instead.

[biohazardvos]

@Kav91 When I'm filling in the entityName = '', it shows me all ARNs of our RDS instances. But when I'm choosing any of them -- the result of the query is the same as on the screenshot above.

[jpvajda]

@Kav91 👋 I was just checking in on this issue to see if you still had some time to assist @biohazardvos. It was reported to still be an issue on this related bug that was resolved in October. Let me know if there is anything I can do to assist in this resolution.

[jpvajda]

After discussing this issue with @DamienCSFR and @Kav91 the next steps are that @DamienCSFR is going to look to find someone at New Relic who can assist on this question.