0

On my Ubuntu server, there are two mysql instances running at the same time.

  • A default, normal mysql instance
  • A secondary mysql instance running with mysqld_multi.

The command sudo service mysql status correctly states the mysql service is active.

I want to check the secondary instance's status so I use this command :

sudo mysqld_multi report

...and I get :

MySQL server from group: mysqld1 is not running

which seems pretty inconsistent since I can connect to this mysql instance from my DB client.

Why does mysqld_multi tell me the instance is not running ?

2
  • If I am not mistaken, the support of mysql_multi was dropped long ago. The popular way to do it today is with Docker.
    – Rick James
    Mar 31, 2020 at 22:31
  • @RickJames I haven't seen anything about an end of support. Mysqld_multi is still provided with mysql 8 and I see no warning in documentation. I'd have liked to use docker but I couldn't at the time I made this... Apr 1, 2020 at 7:42

1 Answer 1

1

Check creation mysql instance dir, confirm mysql rights and install instance in dir

mkdir -p /u01/data/mysql/mysql1 && chown mysql:mysql /u01/data/mysql /u01/data/mysql/mysql1
mysql_install_db --user=mysql --datadir=/u01/data/mysql/mysqld1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.