Met errors when invoke mysqld_multi to run multiple instances
I tried to invoke mysqld_multi to run multiple instances but unfortunately met below errors:
root@ubuntu:/home/zhoudaoyu/mysql_multi# mysqld_multi --defaults-file=./my_multi.cnf start 1, 2
Installing new database in /home/zhoudaoyu/mysql_multi/mysql_3301/data/
2016-08-23 23:58:34 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-08-23 23:58:34 [ERROR] Can't locate the server executable (mysqld).
FATAL ERROR: Tried to start mysqld under group [mysqld1],
but no data directory was found or could be created.
data directory used: /home/zhoudaoyu/mysql_multi/mysql_3301/data/
This is the content of file my_multi.cnf
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root
[mysqld1]
socket = /tmp/mysql_3301.sock
port = 3301
pid-file = /home/zhoudaoyu/mysql_multi/mysql_3301/data/mysql_3301.pid
datadir = /home/zhoudaoyu/mysql_multi/mysql_3301/data/
user = mysql
[mysqld2]
socket = /tmp/mysql_3302.sock
port = 3302
pid-file = /home/zhoudaoyu/mysql_multi/mysql_3302/data/mysql_3302.pid
datadir = /home/zhoudaoyu/mysql_multi/mysql_3302/data/
user = mysql
Is there anybody know why that error happens please?
Thanks.
Subject
Written By
Posted
Met errors when invoke mysqld_multi to run multiple instances
August 23, 2016 10:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.