# CloudQuery issue with missing read-replica in MySQL database

**URL:** <https://community.cloudquery.io/t/cloudquery-issue-with-missing-read-replica-in-mysql-database/459>\
**Category:** CloudQuery Plugins\
**Created:** [January 10, 2024, 3:24pm UTC](https://community.cloudquery.io/t/cloudquery-issue-with-missing-read-replica-in-mysql-database/459 "2024-01-10T15:24:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![model-mutt](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@model-mutt](https://community.cloudquery.io/u/model-mutt)\
**Post date:** [January 10, 2024, 3:24pm UTC](https://community.cloudquery.io/t/cloudquery-issue-with-missing-read-replica-in-mysql-database/459/1 "2024-01-10T15:24:54Z")

</div>

Hey everyone,

I’m running into an issue with CloudQuery when taking an inventory of Amazon RDS instances using AWS (v19.0.0). I notice a single instance (read-replica) is not showing up in my MySQL (v2.2.1) database. All other RDS instances on other AWS accounts seem to populate just fine, even other read replicas.

By manually populating an AWS RDS `describe-db-instances`, I was able to see the instance in question, so I don’t think it’s a user permissions issue.

In my MySQL plugin, I am using:

```yaml
migrate_mode: 'forced'
write_mode: 'overwrite'

```

Any help would be appreciated! Thanks.

---

<div class="post-metadata">

**Author:** ![herman](https://sea1.discourse-cdn.com/flex001/user_avatar/community.cloudquery.io/herman/32/27_2.png) [@herman](https://community.cloudquery.io/u/herman)\
**Post date:** [January 11, 2024, 11:20am UTC](https://community.cloudquery.io/t/cloudquery-issue-with-missing-read-replica-in-mysql-database/459/2 "2024-01-11T11:20:35Z")

</div>

Hi @model-mutt 👋

Thanks, that’s strange, we’ll need to look into this. Could you raise an issue about this on GitHub with any further details you’re able to provide? The full config you’re using for the v19.0.0 AWS plugin and MySQL plugin would be very useful.

I see the primary key on the `aws_rds_instances` table is ARN; so I’m curious if maybe somehow this read replica has the same ARN as another instance? That’s one possibility, although it sounds unlikely. Is there anything else different about this read replica worth mentioning?

You can open a new issue here: [GitHub Issue](https://github.com/cloudquery/cloudquery/issues/new/choose)

---

<div class="post-metadata">

**Author:** ![model-mutt](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@model-mutt](https://community.cloudquery.io/u/model-mutt)\
**Post date:** [January 22, 2024, 9:47pm UTC](https://community.cloudquery.io/t/cloudquery-issue-with-missing-read-replica-in-mysql-database/459/3 "2024-01-22T21:47:31Z")

</div>

The only other thing when using debug logging is that the table sync does show the expected count of resources. Now that you mention it, the ARM is the same except at the end where we added `-reader`. I’ll see if I can add an issue.

---

<div class="post-metadata">

**Author:** ![herman](https://sea1.discourse-cdn.com/flex001/user_avatar/community.cloudquery.io/herman/32/27_2.png) [@herman](https://community.cloudquery.io/u/herman)\
**Post date:** [January 24, 2024, 1:42pm UTC](https://community.cloudquery.io/t/cloudquery-issue-with-missing-read-replica-in-mysql-database/459/4 "2024-01-24T13:42:21Z")

</div>

Thanks, if you could open an issue that would be great!