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
How did you set up pmm-client on the 2nd server? Please provide exact commands and terminal output.
. Download Percona Repo Package
wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
- Install Percona Repo Package
sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
- Update apt cache
sudo apt-get update
- 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
If you have ssh access, you should have added mysql via pmm-admin. Why did you add it via the UI?
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.
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?