Comments (2)
Thanks for the quick reply @denisgcm. I followed your instructions but it didn't work until I created a mySQL user with 127.0.0.1 instead of localhost. Also, set the permissions according to the previously existing mysqld_exporter:localhost user. See below. The good news is things appear to be working as expected. Looking forward to using this tool as its improves, I just wish I had setup my Galera cluster with it initially so I could use more of the features.
CREATE USER 'mysqld_exporter'@'127.0.0.1' IDENTIFIED BY 'monitoringpwd';
GRANT SELECT, PROCESS, REPLICATION CLIENT ON *.* TO 'mysqld_exporter'@'127.0.0.1';
from galera-manager-support.
There is an issue that we should fix. As a temporary workaround I can suggest that you log in to the Galera Manager server via ssh and run gmc cluster list
(you will have to enter your Galera Manager admin user and password). You will get a similar output:
user@ip:~$ gmc cluster list
Enter auth name: admin
Enter auth password:
+----+---------+------+--------------+--------------+-------------+---------------+---------------------+------------------+
| ID | NAME | UUID | SYSTEM | DB ENGINE | HOSTS/NODES | ROOT PASSWORD | MONITORING PASSWORD | BACKUP PASSWORD |
+----+---------+------+--------------+--------------+-------------+---------------+---------------------+------------------+
| 2 | sample | | ubuntu:20.04 | mariadb:10.5 | 3/3 | rootpwd | monitoringpwd | backupgpwd |
+----+---------+------+--------------+--------------+-------------+---------------+---------------------+------------------+
Pick your value for monitoringpwd
and update the password for the mysqld_exporter
user accordingly. After you do that, the stats should start working.
Please let me know if it helped.
from galera-manager-support.
Related Issues (20)
- No monitoring or logs in new install 1.8.4 / Ubuntu 22.04 + Mariadb 10.11.7 HOT 9
- Licensing details HOT 1
- support mariadb 11
- WS Socket connection failed. HOT 2
- package galera-manager HOT 4
- Repositories seem to be broken HOT 4
- Support Ubuntu 24.04
- Galera Manager installation is Failing HOT 3
- when add a node(Monitor existing cluster),it said “failed to install node”
- In-life OS support HOT 2
- GMA : http2: frame too large HOT 6
- Galera Manager could not show Galera Node status HOT 2
- No monitoring or logs after upgrade from 1.6.5 to 1.8.3 HOT 2
- Request feature Galera Arbitrator HOT 2
- Galera Manager Continuous Start/Recover Cluster with "Error failed to get the most advance" HOT 1
- RHEL 9 support HOT 2
- galera manager not starting without external connectivity | also posted on codership google group HOT 3
- Changing domain HOT 1
- Cant monitor my clusters because my debian/mysql version arent supported in GM even tho it works just fine HOT 2
- Syslog messages at every sec HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from galera-manager-support.