Can't launch multiple instances of MySQL in Linuxmysql cannot start because of init.d folder?mysqld - cannot...
How do I implement a file system driver driver in Linux?
Using a siddur to Daven from in a seforim store
Can I rely on this github repository files?
Can the Supreme Court overturn an impeachment?
Does the Mind Blank spell prevent the target from being frightened?
How much character growth crosses the line into breaking the character
Greatest common substring
Are all species of CANNA edible?
How should I respond when I lied about my education and the company finds out through background check?
Global amount of publications over time
Fly on a jet pack vs fly with a jet pack?
Why does Async/Await work properly when the loop is inside the async function and not the other way around?
How do ground effect vehicles perform turns?
Why is Arduino resetting while driving motors?
How can "mimic phobia" be cured or prevented?
How do I extrude a face to a single vertex
Can somebody explain Brexit in a few child-proof sentences?
How to color a curve
In Star Trek IV, why did the Bounty go back to a time when whales are already rare?
Diode in opposite direction?
Varistor? Purpose and principle
What does the Rambam mean when he says that the planets have souls?
Transformation of random variables and joint distributions
Would it be legal for a US State to ban exports of a natural resource?
Can't launch multiple instances of MySQL in Linux
mysql cannot start because of init.d folder?mysqld - cannot connect to socket after changing datadir locationmysqld_safe version different than mysqld?MySQL InnoDB Configuration with 60Gb of MemoryMySQL replication - ibdata1 hugeMysql server does not start if binary logging is disabledWould the error log for MySQL for the IBM i be in mysql.general_log?Issue with MySQL server start (install)Specific install of MySQL 5.6MySQL: initialize the Data Directory (--data-dir) for Operating System user other than mysql
I'm in real trouble here. First, thank you to all of you that will take the time to read my post.
So, I've followed tones and tone of tutorial to create multiple MySQL instances.
On the paper, it's not complicated. I've followed this tutorial (in french, sorry, but it's not complicated to understand) http://www.bocciolesi.fr/tutoriels-et-cours/installer-plusieurs-instances-de-mysql/
I've created a separated my.cnf that I've named multi_my.cnf. Here is the content :
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = multi_admin
password = multi_admin
log = /var/log/mysqld_multi.log
[mysqld2]
socket = /tmp/mysql.sock2
port = 3307
pid-file = /var/lib/mysql2/hostname.pid1
datadir = /var/lib/mysql2
#language = /usr/share/mysql-8.0/mysql/french
user = cube
Of course, I did a copy of the /var/lib/mysql folder to /var/lib/mysql2 and managed the permissions. In this side, I think everything is good. Also, my multi_admin user is configured.
But, when I run the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf start
And then, the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf report
I end up having :
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The same thing happens when I try to put the content of multi_my.cnf on the my.cnf file.
Here is the content of /var/log/mysqld_multi.log :
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:56 2018
Starting MySQL servers
2018-09-24T09:53:56.129051Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2018-09-24T09:53:56.140844Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2018-09-24T09:53:56.389354Z mysqld_safe mysqld from pid file /var/lib/mysql2/hostname.pid2 ended
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:58 2018
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The thing that brings my attention here is that in the log, we can see that the daemon tries to use the databases from /var/lib/mysql. Shouldn't it be /var/lib/mysql2 ?
Any explanation would be much appreciated !
Thank you.
mysql linux
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Sep 24 '18 at 10:37
This question came from our site for professional and enthusiast programmers.
add a comment |
I'm in real trouble here. First, thank you to all of you that will take the time to read my post.
So, I've followed tones and tone of tutorial to create multiple MySQL instances.
On the paper, it's not complicated. I've followed this tutorial (in french, sorry, but it's not complicated to understand) http://www.bocciolesi.fr/tutoriels-et-cours/installer-plusieurs-instances-de-mysql/
I've created a separated my.cnf that I've named multi_my.cnf. Here is the content :
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = multi_admin
password = multi_admin
log = /var/log/mysqld_multi.log
[mysqld2]
socket = /tmp/mysql.sock2
port = 3307
pid-file = /var/lib/mysql2/hostname.pid1
datadir = /var/lib/mysql2
#language = /usr/share/mysql-8.0/mysql/french
user = cube
Of course, I did a copy of the /var/lib/mysql folder to /var/lib/mysql2 and managed the permissions. In this side, I think everything is good. Also, my multi_admin user is configured.
But, when I run the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf start
And then, the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf report
I end up having :
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The same thing happens when I try to put the content of multi_my.cnf on the my.cnf file.
Here is the content of /var/log/mysqld_multi.log :
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:56 2018
Starting MySQL servers
2018-09-24T09:53:56.129051Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2018-09-24T09:53:56.140844Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2018-09-24T09:53:56.389354Z mysqld_safe mysqld from pid file /var/lib/mysql2/hostname.pid2 ended
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:58 2018
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The thing that brings my attention here is that in the log, we can see that the daemon tries to use the databases from /var/lib/mysql. Shouldn't it be /var/lib/mysql2 ?
Any explanation would be much appreciated !
Thank you.
mysql linux
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Sep 24 '18 at 10:37
This question came from our site for professional and enthusiast programmers.
This question has nothing to do with programming, this is pure admin task. You may get assistance on the DBA sister site of SO.
– Shadow
Sep 24 '18 at 10:14
IIRC, mysql_multi stopped being supported several years ago.
– Rick James
Oct 10 '18 at 4:27
add a comment |
I'm in real trouble here. First, thank you to all of you that will take the time to read my post.
So, I've followed tones and tone of tutorial to create multiple MySQL instances.
On the paper, it's not complicated. I've followed this tutorial (in french, sorry, but it's not complicated to understand) http://www.bocciolesi.fr/tutoriels-et-cours/installer-plusieurs-instances-de-mysql/
I've created a separated my.cnf that I've named multi_my.cnf. Here is the content :
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = multi_admin
password = multi_admin
log = /var/log/mysqld_multi.log
[mysqld2]
socket = /tmp/mysql.sock2
port = 3307
pid-file = /var/lib/mysql2/hostname.pid1
datadir = /var/lib/mysql2
#language = /usr/share/mysql-8.0/mysql/french
user = cube
Of course, I did a copy of the /var/lib/mysql folder to /var/lib/mysql2 and managed the permissions. In this side, I think everything is good. Also, my multi_admin user is configured.
But, when I run the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf start
And then, the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf report
I end up having :
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The same thing happens when I try to put the content of multi_my.cnf on the my.cnf file.
Here is the content of /var/log/mysqld_multi.log :
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:56 2018
Starting MySQL servers
2018-09-24T09:53:56.129051Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2018-09-24T09:53:56.140844Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2018-09-24T09:53:56.389354Z mysqld_safe mysqld from pid file /var/lib/mysql2/hostname.pid2 ended
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:58 2018
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The thing that brings my attention here is that in the log, we can see that the daemon tries to use the databases from /var/lib/mysql. Shouldn't it be /var/lib/mysql2 ?
Any explanation would be much appreciated !
Thank you.
mysql linux
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
I'm in real trouble here. First, thank you to all of you that will take the time to read my post.
So, I've followed tones and tone of tutorial to create multiple MySQL instances.
On the paper, it's not complicated. I've followed this tutorial (in french, sorry, but it's not complicated to understand) http://www.bocciolesi.fr/tutoriels-et-cours/installer-plusieurs-instances-de-mysql/
I've created a separated my.cnf that I've named multi_my.cnf. Here is the content :
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = multi_admin
password = multi_admin
log = /var/log/mysqld_multi.log
[mysqld2]
socket = /tmp/mysql.sock2
port = 3307
pid-file = /var/lib/mysql2/hostname.pid1
datadir = /var/lib/mysql2
#language = /usr/share/mysql-8.0/mysql/french
user = cube
Of course, I did a copy of the /var/lib/mysql folder to /var/lib/mysql2 and managed the permissions. In this side, I think everything is good. Also, my multi_admin user is configured.
But, when I run the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf start
And then, the command :
mysqld_multi -–defaults-file=/etc/mysql/multi_my.cnf report
I end up having :
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The same thing happens when I try to put the content of multi_my.cnf on the my.cnf file.
Here is the content of /var/log/mysqld_multi.log :
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:56 2018
Starting MySQL servers
2018-09-24T09:53:56.129051Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2018-09-24T09:53:56.140844Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2018-09-24T09:53:56.389354Z mysqld_safe mysqld from pid file /var/lib/mysql2/hostname.pid2 ended
mysqld_multi log file version 2.16; run: lun. sept. 24 11:53:58 2018
Reporting MySQL servers
MySQL server from group: mysqld2 is not running
The thing that brings my attention here is that in the log, we can see that the daemon tries to use the databases from /var/lib/mysql. Shouldn't it be /var/lib/mysql2 ?
Any explanation would be much appreciated !
Thank you.
mysql linux
mysql linux
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
asked Sep 24 '18 at 9:58
Antonin JacobAntonin Jacob
1
1
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Sep 24 '18 at 10:37
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Sep 24 '18 at 10:37
This question came from our site for professional and enthusiast programmers.
This question has nothing to do with programming, this is pure admin task. You may get assistance on the DBA sister site of SO.
– Shadow
Sep 24 '18 at 10:14
IIRC, mysql_multi stopped being supported several years ago.
– Rick James
Oct 10 '18 at 4:27
add a comment |
This question has nothing to do with programming, this is pure admin task. You may get assistance on the DBA sister site of SO.
– Shadow
Sep 24 '18 at 10:14
IIRC, mysql_multi stopped being supported several years ago.
– Rick James
Oct 10 '18 at 4:27
This question has nothing to do with programming, this is pure admin task. You may get assistance on the DBA sister site of SO.
– Shadow
Sep 24 '18 at 10:14
This question has nothing to do with programming, this is pure admin task. You may get assistance on the DBA sister site of SO.
– Shadow
Sep 24 '18 at 10:14
IIRC, mysql_multi stopped being supported several years ago.
– Rick James
Oct 10 '18 at 4:27
IIRC, mysql_multi stopped being supported several years ago.
– Rick James
Oct 10 '18 at 4:27
add a comment |
1 Answer
1
active
oldest
votes
The mysqld_multi manual states:
Usage: mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR,GNR,GNR...]
or mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR-GNR,GNR,GNR,GNR,...]
Where GNR is the group number. So to start the mysqld2 server you should try:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 2
And to start both:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 1,2
You could also view an example mysqld_multi config to validate against yours with:
mysqld_multi --example
answered Sep 24 '18 at 21:14
socairesocaire
794
Hello, Thanks for your answer. Unfortunately, I've tried "start 2" tons of times, and the result is the same. EDIT : Here are the two conf files compared : Mine is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 user = cubeand the example one is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 language = /usr/share/mysql-8.0/mysql/english user = unix_user1
– Antonin Jacob
Sep 25 '18 at 6:19
You could check the parameters mysql using to start up. Client: my_print_defaults --defaults-file=/etc/multi_my.cnf mysql2 - Server: my_print_defaults --defaults-file=/etc/multi_my.cnf mysqld2 - or - mysqld --defaults-file=/etc/multi_my.cnf --defaults-group-suffix=2 --print-defaults - You can also try spawning the mysqld manually on the console to check if it really does start up successfully: mysqld --defaults-file=/etc/multi_my.cnf --user cube
– socaire
Sep 25 '18 at 13:48
Hi. There is only a mysqld_multi.log file in the /var/lib/ dir, but nothing in it. I've checked again /var/log/mysqld_multi.log and the exact sames lines as in my post appears, and the /var/log/mysql/error.log don't give any info about my instances.
– Antonin Jacob
Sep 25 '18 at 14:04
Ok, I just answered to your previous message before you edit it. I'm gonna check what you said tomorrow, I have to leave my workplace now. Thank you, I'll keep you in touch !
– Antonin Jacob
Sep 25 '18 at 14:06
Hi again. Sorry for the long wait. So I've tried different things, now my conf are all in my.cnf. I haven't changed the datadir, but I tried couple time to set them in a different location, just to see what happens. I finally decided to reinstall Mysql after getting tons of errors, and now, the "normal" service works fine but mysqld --user [whatever] seems to load for a minute (I can't write anything on the console) and then, nothing.
– Antonin Jacob
Oct 1 '18 at 9:03
|
show 2 more comments
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f218403%2fcant-launch-multiple-instances-of-mysql-in-linux%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The mysqld_multi manual states:
Usage: mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR,GNR,GNR...]
or mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR-GNR,GNR,GNR,GNR,...]
Where GNR is the group number. So to start the mysqld2 server you should try:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 2
And to start both:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 1,2
You could also view an example mysqld_multi config to validate against yours with:
mysqld_multi --example
answered Sep 24 '18 at 21:14
socairesocaire
794
Hello, Thanks for your answer. Unfortunately, I've tried "start 2" tons of times, and the result is the same. EDIT : Here are the two conf files compared : Mine is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 user = cubeand the example one is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 language = /usr/share/mysql-8.0/mysql/english user = unix_user1
– Antonin Jacob
Sep 25 '18 at 6:19
You could check the parameters mysql using to start up. Client: my_print_defaults --defaults-file=/etc/multi_my.cnf mysql2 - Server: my_print_defaults --defaults-file=/etc/multi_my.cnf mysqld2 - or - mysqld --defaults-file=/etc/multi_my.cnf --defaults-group-suffix=2 --print-defaults - You can also try spawning the mysqld manually on the console to check if it really does start up successfully: mysqld --defaults-file=/etc/multi_my.cnf --user cube
– socaire
Sep 25 '18 at 13:48
Hi. There is only a mysqld_multi.log file in the /var/lib/ dir, but nothing in it. I've checked again /var/log/mysqld_multi.log and the exact sames lines as in my post appears, and the /var/log/mysql/error.log don't give any info about my instances.
– Antonin Jacob
Sep 25 '18 at 14:04
Ok, I just answered to your previous message before you edit it. I'm gonna check what you said tomorrow, I have to leave my workplace now. Thank you, I'll keep you in touch !
– Antonin Jacob
Sep 25 '18 at 14:06
Hi again. Sorry for the long wait. So I've tried different things, now my conf are all in my.cnf. I haven't changed the datadir, but I tried couple time to set them in a different location, just to see what happens. I finally decided to reinstall Mysql after getting tons of errors, and now, the "normal" service works fine but mysqld --user [whatever] seems to load for a minute (I can't write anything on the console) and then, nothing.
– Antonin Jacob
Oct 1 '18 at 9:03
|
show 2 more comments
The mysqld_multi manual states:
Usage: mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR,GNR,GNR...]
or mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR-GNR,GNR,GNR,GNR,...]
Where GNR is the group number. So to start the mysqld2 server you should try:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 2
And to start both:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 1,2
You could also view an example mysqld_multi config to validate against yours with:
mysqld_multi --example
answered Sep 24 '18 at 21:14
socairesocaire
794
Hello, Thanks for your answer. Unfortunately, I've tried "start 2" tons of times, and the result is the same. EDIT : Here are the two conf files compared : Mine is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 user = cubeand the example one is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 language = /usr/share/mysql-8.0/mysql/english user = unix_user1
– Antonin Jacob
Sep 25 '18 at 6:19
You could check the parameters mysql using to start up. Client: my_print_defaults --defaults-file=/etc/multi_my.cnf mysql2 - Server: my_print_defaults --defaults-file=/etc/multi_my.cnf mysqld2 - or - mysqld --defaults-file=/etc/multi_my.cnf --defaults-group-suffix=2 --print-defaults - You can also try spawning the mysqld manually on the console to check if it really does start up successfully: mysqld --defaults-file=/etc/multi_my.cnf --user cube
– socaire
Sep 25 '18 at 13:48
Hi. There is only a mysqld_multi.log file in the /var/lib/ dir, but nothing in it. I've checked again /var/log/mysqld_multi.log and the exact sames lines as in my post appears, and the /var/log/mysql/error.log don't give any info about my instances.
– Antonin Jacob
Sep 25 '18 at 14:04
Ok, I just answered to your previous message before you edit it. I'm gonna check what you said tomorrow, I have to leave my workplace now. Thank you, I'll keep you in touch !
– Antonin Jacob
Sep 25 '18 at 14:06
Hi again. Sorry for the long wait. So I've tried different things, now my conf are all in my.cnf. I haven't changed the datadir, but I tried couple time to set them in a different location, just to see what happens. I finally decided to reinstall Mysql after getting tons of errors, and now, the "normal" service works fine but mysqld --user [whatever] seems to load for a minute (I can't write anything on the console) and then, nothing.
– Antonin Jacob
Oct 1 '18 at 9:03
|
show 2 more comments
The mysqld_multi manual states:
Usage: mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR,GNR,GNR...]
or mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR-GNR,GNR,GNR,GNR,...]
Where GNR is the group number. So to start the mysqld2 server you should try:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 2
And to start both:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 1,2
You could also view an example mysqld_multi config to validate against yours with:
mysqld_multi --example
answered Sep 24 '18 at 21:14
socairesocaire
794
The mysqld_multi manual states:
Usage: mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR,GNR,GNR...]
or mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR-GNR,GNR,GNR,GNR,...]
Where GNR is the group number. So to start the mysqld2 server you should try:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 2
And to start both:
mysqld_multi --defaults-file=/etc/mysql/multi_my.cnf start 1,2
You could also view an example mysqld_multi config to validate against yours with:
mysqld_multi --example
answered Sep 24 '18 at 21:14
socairesocaire
794
answered Sep 24 '18 at 21:14
socairesocaire
794
answered Sep 24 '18 at 21:14
socairesocaire
794
answered Sep 24 '18 at 21:14
socairesocaire
794
794
Hello, Thanks for your answer. Unfortunately, I've tried "start 2" tons of times, and the result is the same. EDIT : Here are the two conf files compared : Mine is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 user = cubeand the example one is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 language = /usr/share/mysql-8.0/mysql/english user = unix_user1
– Antonin Jacob
Sep 25 '18 at 6:19
You could check the parameters mysql using to start up. Client: my_print_defaults --defaults-file=/etc/multi_my.cnf mysql2 - Server: my_print_defaults --defaults-file=/etc/multi_my.cnf mysqld2 - or - mysqld --defaults-file=/etc/multi_my.cnf --defaults-group-suffix=2 --print-defaults - You can also try spawning the mysqld manually on the console to check if it really does start up successfully: mysqld --defaults-file=/etc/multi_my.cnf --user cube
– socaire
Sep 25 '18 at 13:48
Hi. There is only a mysqld_multi.log file in the /var/lib/ dir, but nothing in it. I've checked again /var/log/mysqld_multi.log and the exact sames lines as in my post appears, and the /var/log/mysql/error.log don't give any info about my instances.
– Antonin Jacob
Sep 25 '18 at 14:04
Ok, I just answered to your previous message before you edit it. I'm gonna check what you said tomorrow, I have to leave my workplace now. Thank you, I'll keep you in touch !
– Antonin Jacob
Sep 25 '18 at 14:06
Hi again. Sorry for the long wait. So I've tried different things, now my conf are all in my.cnf. I haven't changed the datadir, but I tried couple time to set them in a different location, just to see what happens. I finally decided to reinstall Mysql after getting tons of errors, and now, the "normal" service works fine but mysqld --user [whatever] seems to load for a minute (I can't write anything on the console) and then, nothing.
– Antonin Jacob
Oct 1 '18 at 9:03
|
show 2 more comments
Hello, Thanks for your answer. Unfortunately, I've tried "start 2" tons of times, and the result is the same. EDIT : Here are the two conf files compared : Mine is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 user = cubeand the example one is[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 language = /usr/share/mysql-8.0/mysql/english user = unix_user1
– Antonin Jacob
Sep 25 '18 at 6:19
You could check the parameters mysql using to start up. Client: my_print_defaults --defaults-file=/etc/multi_my.cnf mysql2 - Server: my_print_defaults --defaults-file=/etc/multi_my.cnf mysqld2 - or - mysqld --defaults-file=/etc/multi_my.cnf --defaults-group-suffix=2 --print-defaults - You can also try spawning the mysqld manually on the console to check if it really does start up successfully: mysqld --defaults-file=/etc/multi_my.cnf --user cube
– socaire
Sep 25 '18 at 13:48
Hi. There is only a mysqld_multi.log file in the /var/lib/ dir, but nothing in it. I've checked again /var/log/mysqld_multi.log and the exact sames lines as in my post appears, and the /var/log/mysql/error.log don't give any info about my instances.
– Antonin Jacob
Sep 25 '18 at 14:04
Ok, I just answered to your previous message before you edit it. I'm gonna check what you said tomorrow, I have to leave my workplace now. Thank you, I'll keep you in touch !
– Antonin Jacob
Sep 25 '18 at 14:06
Hi again. Sorry for the long wait. So I've tried different things, now my conf are all in my.cnf. I haven't changed the datadir, but I tried couple time to set them in a different location, just to see what happens. I finally decided to reinstall Mysql after getting tons of errors, and now, the "normal" service works fine but mysqld --user [whatever] seems to load for a minute (I can't write anything on the console) and then, nothing.
– Antonin Jacob
Oct 1 '18 at 9:03
Hello, Thanks for your answer. Unfortunately, I've tried "start 2" tons of times, and the result is the same. EDIT : Here are the two conf files compared : Mine is
[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 user = cube and the example one is [mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 language = /usr/share/mysql-8.0/mysql/english user = unix_user1– Antonin Jacob
Sep 25 '18 at 6:19
Hello, Thanks for your answer. Unfortunately, I've tried "start 2" tons of times, and the result is the same. EDIT : Here are the two conf files compared : Mine is
[mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 user = cube and the example one is [mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /var/lib/mysql2/hostname.pid2 datadir = /var/lib/mysql2 language = /usr/share/mysql-8.0/mysql/english user = unix_user1– Antonin Jacob
Sep 25 '18 at 6:19
You could check the parameters mysql using to start up. Client: my_print_defaults --defaults-file=/etc/multi_my.cnf mysql2 - Server: my_print_defaults --defaults-file=/etc/multi_my.cnf mysqld2 - or - mysqld --defaults-file=/etc/multi_my.cnf --defaults-group-suffix=2 --print-defaults - You can also try spawning the mysqld manually on the console to check if it really does start up successfully: mysqld --defaults-file=/etc/multi_my.cnf --user cube
– socaire
Sep 25 '18 at 13:48
You could check the parameters mysql using to start up. Client: my_print_defaults --defaults-file=/etc/multi_my.cnf mysql2 - Server: my_print_defaults --defaults-file=/etc/multi_my.cnf mysqld2 - or - mysqld --defaults-file=/etc/multi_my.cnf --defaults-group-suffix=2 --print-defaults - You can also try spawning the mysqld manually on the console to check if it really does start up successfully: mysqld --defaults-file=/etc/multi_my.cnf --user cube
– socaire
Sep 25 '18 at 13:48
Hi. There is only a mysqld_multi.log file in the /var/lib/ dir, but nothing in it. I've checked again /var/log/mysqld_multi.log and the exact sames lines as in my post appears, and the /var/log/mysql/error.log don't give any info about my instances.
– Antonin Jacob
Sep 25 '18 at 14:04
Hi. There is only a mysqld_multi.log file in the /var/lib/ dir, but nothing in it. I've checked again /var/log/mysqld_multi.log and the exact sames lines as in my post appears, and the /var/log/mysql/error.log don't give any info about my instances.
– Antonin Jacob
Sep 25 '18 at 14:04
Ok, I just answered to your previous message before you edit it. I'm gonna check what you said tomorrow, I have to leave my workplace now. Thank you, I'll keep you in touch !
– Antonin Jacob
Sep 25 '18 at 14:06
Ok, I just answered to your previous message before you edit it. I'm gonna check what you said tomorrow, I have to leave my workplace now. Thank you, I'll keep you in touch !
– Antonin Jacob
Sep 25 '18 at 14:06
Hi again. Sorry for the long wait. So I've tried different things, now my conf are all in my.cnf. I haven't changed the datadir, but I tried couple time to set them in a different location, just to see what happens. I finally decided to reinstall Mysql after getting tons of errors, and now, the "normal" service works fine but mysqld --user [whatever] seems to load for a minute (I can't write anything on the console) and then, nothing.
– Antonin Jacob
Oct 1 '18 at 9:03
Hi again. Sorry for the long wait. So I've tried different things, now my conf are all in my.cnf. I haven't changed the datadir, but I tried couple time to set them in a different location, just to see what happens. I finally decided to reinstall Mysql after getting tons of errors, and now, the "normal" service works fine but mysqld --user [whatever] seems to load for a minute (I can't write anything on the console) and then, nothing.
– Antonin Jacob
Oct 1 '18 at 9:03
|
show 2 more comments
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f218403%2fcant-launch-multiple-instances-of-mysql-in-linux%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
This question has nothing to do with programming, this is pure admin task. You may get assistance on the DBA sister site of SO.
– Shadow
Sep 24 '18 at 10:14
IIRC, mysql_multi stopped being supported several years ago.
– Rick James
Oct 10 '18 at 4:27