Unable to get any data of 2nd mysql server in QAN

[sawan_singh]

Hi,
i have configured two Mysql Databases on PMM but i am only able to see 1 nodes in QAN or 1 Database (CMS), i am unable to see 2nd DB which is Staging.
kindly help me through this as i want both DB queries.
for more clarifiaction, i have attached ScreenShots below

[matthewb]

How did you set up pmm-client on the 2nd server? Please provide exact commands and terminal output.

[sawan_singh]

. Download Percona Repo Package

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb

2. Install Percona Repo Package

sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb

3. Update apt cache

sudo apt-get update

4. Install Percona Monitoring and Management Client

sudo apt-get install pmm2-client

the output of the command “sudo apt-get install pmm2-client” attached below

at last i used this command
sudo pmm-admin config --server-insecure-tls --server-url=https://admin:<password>@pmm.example.com
after that i opend PMM from url
then from settings
i added instance to PMM,then i configured my MYSQL Database

[matthewb]

If you have ssh access, you should have added mysql via pmm-admin. Why did you add it via the UI?

[sawan_singh]

but why can’t i add mysql DB via UI, one of my sql server was configured with UI and its working, why not 2nd one, can you please explain.

[matthewb]

You can, it is just not as optimal when you have SSH access to the MySQL server itself. Did you test the connection in the UI before adding? Have you tried removing it and adding again?