PMM MySQL not starting

Percona Monitoring and Management (PMM) PMM 1.x
1

Hi friends at Percona,

So I just reinstalled PMM as a docker image. I have the graphana and mysql data directories linked to mount point /DATA. The weird thing is that the MySQL is not initialized and doesn’t have anything but the ibdata1 file and two iblogfiles. I tried using mysql_install_db to fix the install but it didn’t worl. Docker also has MySQL on a continuous restart loop. I am probably missing something tiny here. Do you have any suggestions for me?

This is how I created the container:
docker create
-v /DATA/prometheus/data:/opt/prometheus/data
-v /DATA/consul-data:/opt/consul-data
-v /DATA/mysql:/var/lib/mysql
-v /DATA/grafana:/var/lib/grafana
–name pmm-data
percona/pmm-server:latest /bin/true

docker run -d -p 443:443
–volumes-from pmm-data
–name pmm-server
-e SERVER_USER=[redacted]
-e SERVER_PASSWORD=[redacted]
–restart always
percona/pmm-server:latest

2

Hi obb76

While we don’t support remapping volumes, technically they should work. Could you share with us: [LIST=1]
[*]The full messages you see when you run the create and run commands?
[/LIST] Thanks!

3

[url]https://www.percona.com/blog/2018/03/20/using-different-mount-points-on-pmm-docker-deployments/[/url]

4

Hi bplegend

Yep I’m familiar with that terrific blog post from Agustín !

MySQL is not initialized and doesn’t have anything but the ibdata1 file and two iblogfiles

Can you share the full messages you see when you run the create and run commands?

Also the contents of the MySQL error file would be helpful as that will tell us why MySQL won’t start.

Thanks