MySQL Forums
Forum List  »  Newbie

Met errors when invoke mysqld_multi to run multiple instances
Posted by: Zhou Daoyu Zhou
Date: August 23, 2016 10:11AM

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.

Options: ReplyQuote


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.