Mysqlfailover command - No slave is listed in health status
I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command.
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc
I have got the following results. No slave is listed.
MySQL Replication Failover Utility
Failover Mode = auto Next Interval = Tue May
Master Information
------------------
Binary Log File Position Binlog_Do_DB Binlog
mysql-bin.000016 9568
GTID Executed Set
8fe8b710-cd34-11e4-824d-fa163e52e544:1-1143
Replication Health Status
0 Rows Found.
Q-quit R-refresh H-health G-GTID Lists U-UUIDs U
But when I execute the mysqlrplcheck and mysqlrplshow commands, the slave is listed.
Is this normal?
mysql replication failover
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
asked May 11 '15 at 11:48
AneeshaAneesha
262
add a comment |
I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command.
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc
I have got the following results. No slave is listed.
MySQL Replication Failover Utility
Failover Mode = auto Next Interval = Tue May
Master Information
------------------
Binary Log File Position Binlog_Do_DB Binlog
mysql-bin.000016 9568
GTID Executed Set
8fe8b710-cd34-11e4-824d-fa163e52e544:1-1143
Replication Health Status
0 Rows Found.
Q-quit R-refresh H-health G-GTID Lists U-UUIDs U
But when I execute the mysqlrplcheck and mysqlrplshow commands, the slave is listed.
Is this normal?
mysql replication failover
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
asked May 11 '15 at 11:48
AneeshaAneesha
262
how to solve that?
– Amitābha
Nov 5 '15 at 9:50
add a comment |
I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command.
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc
I have got the following results. No slave is listed.
MySQL Replication Failover Utility
Failover Mode = auto Next Interval = Tue May
Master Information
------------------
Binary Log File Position Binlog_Do_DB Binlog
mysql-bin.000016 9568
GTID Executed Set
8fe8b710-cd34-11e4-824d-fa163e52e544:1-1143
Replication Health Status
0 Rows Found.
Q-quit R-refresh H-health G-GTID Lists U-UUIDs U
But when I execute the mysqlrplcheck and mysqlrplshow commands, the slave is listed.
Is this normal?
mysql replication failover
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
asked May 11 '15 at 11:48
AneeshaAneesha
262
I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command.
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc
I have got the following results. No slave is listed.
MySQL Replication Failover Utility
Failover Mode = auto Next Interval = Tue May
Master Information
------------------
Binary Log File Position Binlog_Do_DB Binlog
mysql-bin.000016 9568
GTID Executed Set
8fe8b710-cd34-11e4-824d-fa163e52e544:1-1143
Replication Health Status
0 Rows Found.
Q-quit R-refresh H-health G-GTID Lists U-UUIDs U
But when I execute the mysqlrplcheck and mysqlrplshow commands, the slave is listed.
Is this normal?
mysql replication failover
mysql replication failover
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
asked May 11 '15 at 11:48
AneeshaAneesha
262
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
asked May 11 '15 at 11:48
AneeshaAneesha
262
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
edited Jan 5 '17 at 15:58
mustaccio
9,02772136
9,02772136
asked May 11 '15 at 11:48
AneeshaAneesha
262
asked May 11 '15 at 11:48
AneeshaAneesha
262
asked May 11 '15 at 11:48
AneeshaAneesha
262
262
how to solve that?
– Amitābha
Nov 5 '15 at 9:50
add a comment |
how to solve that?
– Amitābha
Nov 5 '15 at 9:50
how to solve that?
– Amitābha
Nov 5 '15 at 9:50
how to solve that?
– Amitābha
Nov 5 '15 at 9:50
add a comment |
2 Answers
2
active
oldest
votes
Workaround for this is to give slave details also:
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc --slaves=root:abc@<host>, root:abc@<host>
where is IP or hostname of slaves.
answered Jul 13 '16 at 10:05
RohitMRohitM
1
add a comment |
I'm also facing that problems!
answered 11 mins ago
chanchan
11
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
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%2f101158%2fmysqlfailover-command-no-slave-is-listed-in-health-status%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Workaround for this is to give slave details also:
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc --slaves=root:abc@<host>, root:abc@<host>
where is IP or hostname of slaves.
answered Jul 13 '16 at 10:05
RohitMRohitM
1
add a comment |
Workaround for this is to give slave details also:
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc --slaves=root:abc@<host>, root:abc@<host>
where is IP or hostname of slaves.
answered Jul 13 '16 at 10:05
RohitMRohitM
1
add a comment |
Workaround for this is to give slave details also:
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc --slaves=root:abc@<host>, root:abc@<host>
where is IP or hostname of slaves.
answered Jul 13 '16 at 10:05
RohitMRohitM
1
Workaround for this is to give slave details also:
mysqlfailover --master=root:abc@10.24.184.12:3306 --discover-slaves-login=root:abc --slaves=root:abc@<host>, root:abc@<host>
where is IP or hostname of slaves.
answered Jul 13 '16 at 10:05
RohitMRohitM
1
answered Jul 13 '16 at 10:05
RohitMRohitM
1
answered Jul 13 '16 at 10:05
RohitMRohitM
1
answered Jul 13 '16 at 10:05
RohitMRohitM
1
1
add a comment |
add a comment |
I'm also facing that problems!
answered 11 mins ago
chanchan
11
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm also facing that problems!
answered 11 mins ago
chanchan
11
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm also facing that problems!
answered 11 mins ago
chanchan
11
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm also facing that problems!
answered 11 mins ago
chanchan
11
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 11 mins ago
chanchan
11
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 11 mins ago
chanchan
11
answered 11 mins ago
chanchan
11
11
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
chan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
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%2f101158%2fmysqlfailover-command-no-slave-is-listed-in-health-status%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
how to solve that?
– Amitābha
Nov 5 '15 at 9:50