Ok so... I provide instructions on how to install Releem
You need to create a free account with Releem which has a limit for 3 free database servers.
You can do this here: https://app.releem.com/?signup
You then need to create a user in the database for Releem
Execute the following commands:
docker exec -it mysqlcd /bin/bash
mysql -uroot -p
You can find the password for root in /var/local/enhance/mysqlcd-data/login_root.cnf
Now you still need to find the IP address for mysql.
docker inspect mysqlcd
At the end, find a line along the following line - "Gateway": "199.99.88.1",
This is the IP address for Mysql on your server.
Now create a releem user with your password.
CREATE USER 'releem'@'199.99.88.1' identified by 'yourpassword';
GRANT SELECT, PROCESS,EXECUTE, REPLICATION CLIENT,SHOW DATABASES,SHOW VIEW ON *.* TO 'releem'@'199.99.88.1';
We will now run docker Releem
docker run -d -ti --restart unless-stopped --network=enhance-network --name 'releem-agent' -e DB_HOST="199.99.88.1" -e DB_PORT="3306" -e DB_PASSWORD="yourpassword" -e DB_USER="releem" -e RELEEM_API_KEY="your_api_key" -e MEMORY_LIMIT=1000 -e RELEEM_HOSTNAME="server_name" -v /etc/mysql/releem.conf.d:/etc/mysql/releem.conf.d -v /opt/releem/conf:/opt/releem/conf releem/releem-agent:1.2.0
RELEEM_API_KEY - you can find in Releem dashboard > Add new server
MEMORY_LIMIT - set your own max RAM usage limit for MySQL tuning
RELEEM_HOSTNAME - friendly server name displayed in the dashboard Releem
When you start the Releem docker, it should already be visible in the Releem dashboard after a few seconds.
It may take some time to generate the tuning variables.
The proposed tuning can be found in dashboard Releem - "Recomended configuration" or on the server in /opt/releem/conf/z_aiops_mysql.cnf
Of course, you have to add these changes manually on each server role with the Mysql - Server > Database settings
PS - performance_schema in database settings must be enabled for proper Releem operation.
If there are any questions, I will be happy to answer them.
