- Run MySQL via Docker:
docker run -p 3306:3306 --name kelnerhax-mysql -e MYSQL_ROOT_PASSWORD=<password> -d mysql:latest
docker inspect <container-name>
to get the container ip from `NetworkSettings.IPAddress"docker exec -it <container-name> /bin/bash
to get on the docker container- Follow https://docs.datadoghq.com/integrations/mysql/#prepare-mysql
mysql -u root --password=<password>
CREATE USER 'datadog'@'%' IDENTIFIED BY '<dd-mysql-password>';
GRANT REPLICATION CLIENT ON *.* TO 'datadog'@'%' WITH MAX_USER_CONNECTIONS 5;
GRANT PROCESS ON *.* TO 'datadog'@'%';
exit
- Use https://github.com/ckelner/datadog-mysql-vagrant to spin up to vagrants and configure the mysql check
- Use the special virtualbox IP
10.0.2.2
to connect to the mysql instance via the host on port3306
- Spin up a second vagrant the same way using
./second_vagrant/Vagrantfile
in the repo
- Use the special virtualbox IP
This will result in hosts reporting the same metric (duplicate) as seen here: