# error in adding multiple instances

**URL:** <https://forums.percona.com/t/error-in-adding-multiple-instances/5369>\
**Category:** PMM 1.x\
**Created:** [January 25, 2017, 12:17pm UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369 "2017-01-25T12:17:49Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![govindareddy20](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@govindareddy20](https://forums.percona.com/u/govindareddy20)\
**Post date:** [January 25, 2017, 12:17pm UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/1 "2017-01-25T12:17:49Z")

</div>

Hi,  
We are using an EC2 instance to monitor RDS aurora clusters and the instance class of EC2 is t2.large. I’ve been added 10 clusters out of that, 7 are working fine. The rest are showing running state as NO. I haven’t get any error while adding but seeing that running state as NO. I removed them and tried to add again, still the same. what am I missing in this process?

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 25, 2017, 12:26pm UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/2 "2017-01-25T12:26:55Z")

</div>

Hi govindareddy20,

the first idea - network connectivity or firewall settings.

- are all clusters located in the one region?
- are all clusters located in the one availability zone?
- are all clusters have the same VPC ID?
- are all clusters located in the same Subnet ID?
- can you check security groups?

---

<div class="post-metadata">

**Author:** ![govindareddy20](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@govindareddy20](https://forums.percona.com/u/govindareddy20)\
**Post date:** [January 25, 2017, 3:52pm UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/3 "2017-01-25T15:52:44Z")

</div>

Hi Mykola,  
They are all under same region, availability zone, VPC, subnets and using same security group.

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 26, 2017, 6:21am UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/4 "2017-01-26T06:21:57Z")

</div>

Hi govindareddy20,

can you make screenshot what exactly is not working?

---

<div class="post-metadata">

**Author:** ![govindareddy20](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@govindareddy20](https://forums.percona.com/u/govindareddy20)\
**Post date:** [January 26, 2017, 11:40am UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/5 "2017-01-26T11:40:16Z")

</div>

Below are the clusters I added, We can see from the bottom which the running state showing as “NO”. When I’m running add mysql command, the output showing as OK for linux:metrics, mysql:metrics and mysql:queries. When I see the list, Running state showing as NO. Though, I can see that cluster in QAN window but it is not showing up in Grafana. The rest are all working fine in both QAN and Grafana.

linux:metrics abcde 42000 YES  
mysql:metrics bcdef 42002 YES  
mysql:metrics cdefg 42003 YES  
mysql:metrics defgh 42004 YES  
mysql:metrics efghi 42005 YES  
mysql:metrics fghij 42006 YES  
mysql:metrics ghijk 42007 YES  
mysql:metrics hijkl 42008 YES  
mysql:metrics ijklm 42009 YES  
mysql:metrics jklmn 42010 YES  
mysql:metrics klmno 42011 NO   
mysql:metrics lmnop 42012 YES

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 26, 2017, 1:35pm UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/6 "2017-01-26T13:35:16Z")

</div>

Are aurora instances (not clusters) user the same “Parameter Groups” ?

Can you try to remove broken instance and add it again?

```auto

sudo pmm-admin remove mysql:metrics klmno 
sudo pmm-admin add mysql:metrics --host klmo.host.com --user pmm --password pass klmno

```

can you check instance credentials before add?

```auto

mysql -h klmo.host.com -u pmm -p pass

```

---

<div class="post-metadata">

**Author:** ![govindareddy20](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@govindareddy20](https://forums.percona.com/u/govindareddy20)\
**Post date:** [January 27, 2017, 9:22am UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/7 "2017-01-27T09:22:12Z")

</div>

I tried to remove and add, but still the same after adding. The user is same for all instances I added. If the credentials are incorrect, It should threw an error while adding but it shows that all metrics are OK.

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 27, 2017, 11:42am UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/8 "2017-01-27T11:42:17Z")

</div>

pmm-admin checks credentials during first add, but they can be changed.

Are aurora instances (not clusters) use the same “Parameter Groups” in AWS?

it is hard to get down service after after remove-adding…  
can you start service manually?

```auto
pmm-admin start mysql:metrics klmno

```

---

<div class="post-metadata">

**Author:** ![govindareddy20](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@govindareddy20](https://forums.percona.com/u/govindareddy20)\
**Post date:** [January 27, 2017, 2:17pm UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/9 "2017-01-27T14:17:46Z")

</div>

That’s working, what might be the issue stopping this here?

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 27, 2017, 2:32pm UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/10 "2017-01-27T14:32:06Z")

</div>

hard to guess ☹  
systemd glitch, selinux, not enough RAM, reboot etc

---

<div class="post-metadata">

**Author:** ![govindareddy20](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@govindareddy20](https://forums.percona.com/u/govindareddy20)\
**Post date:** [January 30, 2017, 10:19am UTC](https://forums.percona.com/t/error-in-adding-multiple-instances/5369/11 "2017-01-30T10:19:50Z")

</div>

Thanks Mykola…!!!
