MariaDB Galera Cluster - first node won't reconnect after restart… Ever
Firewalls disabled, replication worked fine, IP's accessible..
All config copied from here:
https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04
As soon I try to restart the first node it won't reconnect.
I cannot restart the whole cluster as it supposed to be serving content 24/7 with at least 3 nodes available at all times...
Any idea how I can setup Galera so it would survive a restart of ANY node? (restart of a cluster is a pretty much fatal crash as leads to losses going in xx k of $ and the main reason behind selecting Galera was the low cost vs Microsoft (which can survive without a problem any number of resets while setup correctly)...
As I am trying to push Galera instead of Windows, I have to prove that indeed it is a commercially viable solution (which means that it have to survive main node restart, especially that we have dozens of "main" servers so "first" node is strictly theoretical).
I was testing in ~ 2 weeks ago and unfortunately, it ended up with a restart and data loss (due to having test servers offline)
mariadb galera
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
Firewalls disabled, replication worked fine, IP's accessible..
All config copied from here:
https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04
As soon I try to restart the first node it won't reconnect.
I cannot restart the whole cluster as it supposed to be serving content 24/7 with at least 3 nodes available at all times...
Any idea how I can setup Galera so it would survive a restart of ANY node? (restart of a cluster is a pretty much fatal crash as leads to losses going in xx k of $ and the main reason behind selecting Galera was the low cost vs Microsoft (which can survive without a problem any number of resets while setup correctly)...
As I am trying to push Galera instead of Windows, I have to prove that indeed it is a commercially viable solution (which means that it have to survive main node restart, especially that we have dozens of "main" servers so "first" node is strictly theoretical).
I was testing in ~ 2 weeks ago and unfortunately, it ended up with a restart and data loss (due to having test servers offline)
mariadb galera
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Please provide the commands/settings used for the initial setup, plus how they were changed when trying to reconnect.
– Rick James
Dec 20 '18 at 17:19
Which version of MariaDB? Which OS and version? What error messages are you getting?
– dbdemon
Dec 22 '18 at 23:14
add a comment |
Firewalls disabled, replication worked fine, IP's accessible..
All config copied from here:
https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04
As soon I try to restart the first node it won't reconnect.
I cannot restart the whole cluster as it supposed to be serving content 24/7 with at least 3 nodes available at all times...
Any idea how I can setup Galera so it would survive a restart of ANY node? (restart of a cluster is a pretty much fatal crash as leads to losses going in xx k of $ and the main reason behind selecting Galera was the low cost vs Microsoft (which can survive without a problem any number of resets while setup correctly)...
As I am trying to push Galera instead of Windows, I have to prove that indeed it is a commercially viable solution (which means that it have to survive main node restart, especially that we have dozens of "main" servers so "first" node is strictly theoretical).
I was testing in ~ 2 weeks ago and unfortunately, it ended up with a restart and data loss (due to having test servers offline)
mariadb galera
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
Firewalls disabled, replication worked fine, IP's accessible..
All config copied from here:
https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04
As soon I try to restart the first node it won't reconnect.
I cannot restart the whole cluster as it supposed to be serving content 24/7 with at least 3 nodes available at all times...
Any idea how I can setup Galera so it would survive a restart of ANY node? (restart of a cluster is a pretty much fatal crash as leads to losses going in xx k of $ and the main reason behind selecting Galera was the low cost vs Microsoft (which can survive without a problem any number of resets while setup correctly)...
As I am trying to push Galera instead of Windows, I have to prove that indeed it is a commercially viable solution (which means that it have to survive main node restart, especially that we have dozens of "main" servers so "first" node is strictly theoretical).
I was testing in ~ 2 weeks ago and unfortunately, it ended up with a restart and data loss (due to having test servers offline)
mariadb galera
mariadb galera
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
asked Dec 20 '18 at 14:24
Mike MikeMike Mike
1
1
bumped to the homepage by Community♦ 4 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♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Please provide the commands/settings used for the initial setup, plus how they were changed when trying to reconnect.
– Rick James
Dec 20 '18 at 17:19
Which version of MariaDB? Which OS and version? What error messages are you getting?
– dbdemon
Dec 22 '18 at 23:14
add a comment |
Please provide the commands/settings used for the initial setup, plus how they were changed when trying to reconnect.
– Rick James
Dec 20 '18 at 17:19
Which version of MariaDB? Which OS and version? What error messages are you getting?
– dbdemon
Dec 22 '18 at 23:14
Please provide the commands/settings used for the initial setup, plus how they were changed when trying to reconnect.
– Rick James
Dec 20 '18 at 17:19
Please provide the commands/settings used for the initial setup, plus how they were changed when trying to reconnect.
– Rick James
Dec 20 '18 at 17:19
Which version of MariaDB? Which OS and version? What error messages are you getting?
– dbdemon
Dec 22 '18 at 23:14
Which version of MariaDB? Which OS and version? What error messages are you getting?
– dbdemon
Dec 22 '18 at 23:14
add a comment |
1 Answer
1
active
oldest
votes
With not so much detail in the question, I can't give a detailed answer, but I'd recommend starting with MariaDB's documentation about Galera Cluster since you're using MariaDB. See e.g. Getting Started with MariaDB Galera Cluster. The DigitalOcean documentation you referred to is for MySQL 5.6, so there may be details in there that works slightly differently on MariaDB.
Maybe the most crucial question about your specific problem is: What error message are you getting? And I mean the actual error message in the MariaDB error log, which is not necessarily what systemctl will show you in the shell when you run the start/restart/status commands. Once you have this, try your favourite search engine to find the answer. If that doesn't work, come back to DBA.SE and ask a more specific question which includes the error message(s).
Galera Cluster is an excellent technology, but if you don't have much experience with it yet, make sure to read carefully about its limitations, and make sure they're not in conflict with your particular use-case. There is a lot to learn, so be prepared to invest sufficient time and effort.
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
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%2f225477%2fmariadb-galera-cluster-first-node-wont-reconnect-after-restart-ever%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
With not so much detail in the question, I can't give a detailed answer, but I'd recommend starting with MariaDB's documentation about Galera Cluster since you're using MariaDB. See e.g. Getting Started with MariaDB Galera Cluster. The DigitalOcean documentation you referred to is for MySQL 5.6, so there may be details in there that works slightly differently on MariaDB.
Maybe the most crucial question about your specific problem is: What error message are you getting? And I mean the actual error message in the MariaDB error log, which is not necessarily what systemctl will show you in the shell when you run the start/restart/status commands. Once you have this, try your favourite search engine to find the answer. If that doesn't work, come back to DBA.SE and ask a more specific question which includes the error message(s).
Galera Cluster is an excellent technology, but if you don't have much experience with it yet, make sure to read carefully about its limitations, and make sure they're not in conflict with your particular use-case. There is a lot to learn, so be prepared to invest sufficient time and effort.
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
add a comment |
With not so much detail in the question, I can't give a detailed answer, but I'd recommend starting with MariaDB's documentation about Galera Cluster since you're using MariaDB. See e.g. Getting Started with MariaDB Galera Cluster. The DigitalOcean documentation you referred to is for MySQL 5.6, so there may be details in there that works slightly differently on MariaDB.
Maybe the most crucial question about your specific problem is: What error message are you getting? And I mean the actual error message in the MariaDB error log, which is not necessarily what systemctl will show you in the shell when you run the start/restart/status commands. Once you have this, try your favourite search engine to find the answer. If that doesn't work, come back to DBA.SE and ask a more specific question which includes the error message(s).
Galera Cluster is an excellent technology, but if you don't have much experience with it yet, make sure to read carefully about its limitations, and make sure they're not in conflict with your particular use-case. There is a lot to learn, so be prepared to invest sufficient time and effort.
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
add a comment |
With not so much detail in the question, I can't give a detailed answer, but I'd recommend starting with MariaDB's documentation about Galera Cluster since you're using MariaDB. See e.g. Getting Started with MariaDB Galera Cluster. The DigitalOcean documentation you referred to is for MySQL 5.6, so there may be details in there that works slightly differently on MariaDB.
Maybe the most crucial question about your specific problem is: What error message are you getting? And I mean the actual error message in the MariaDB error log, which is not necessarily what systemctl will show you in the shell when you run the start/restart/status commands. Once you have this, try your favourite search engine to find the answer. If that doesn't work, come back to DBA.SE and ask a more specific question which includes the error message(s).
Galera Cluster is an excellent technology, but if you don't have much experience with it yet, make sure to read carefully about its limitations, and make sure they're not in conflict with your particular use-case. There is a lot to learn, so be prepared to invest sufficient time and effort.
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
With not so much detail in the question, I can't give a detailed answer, but I'd recommend starting with MariaDB's documentation about Galera Cluster since you're using MariaDB. See e.g. Getting Started with MariaDB Galera Cluster. The DigitalOcean documentation you referred to is for MySQL 5.6, so there may be details in there that works slightly differently on MariaDB.
Maybe the most crucial question about your specific problem is: What error message are you getting? And I mean the actual error message in the MariaDB error log, which is not necessarily what systemctl will show you in the shell when you run the start/restart/status commands. Once you have this, try your favourite search engine to find the answer. If that doesn't work, come back to DBA.SE and ask a more specific question which includes the error message(s).
Galera Cluster is an excellent technology, but if you don't have much experience with it yet, make sure to read carefully about its limitations, and make sure they're not in conflict with your particular use-case. There is a lot to learn, so be prepared to invest sufficient time and effort.
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
answered Dec 22 '18 at 23:54
dbdemondbdemon
3,1672725
3,1672725
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%2f225477%2fmariadb-galera-cluster-first-node-wont-reconnect-after-restart-ever%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
Please provide the commands/settings used for the initial setup, plus how they were changed when trying to reconnect.
– Rick James
Dec 20 '18 at 17:19
Which version of MariaDB? Which OS and version? What error messages are you getting?
– dbdemon
Dec 22 '18 at 23:14