Sfrgttk

Can a stoichiometric mixture of oxygen and methane exist as a liquid at standard pressure and some (low) temperature?

Does malloc reserve more space while allocating memory?

Quoting Keynes in a lecture

What is going on with 'gets(stdin)' on the site coderbyte?

How do you make your own symbol when Detexify fails?

What does chmod -u do?

Is there a RAID 0 Equivalent for RAM?

Limits and Infinite Integration by Parts

How to hide some fields of struct in C?

Keeping a ball lost forever

Angel of Condemnation - Exile creature with second ability

A social experiment. What is the worst that can happen?

What is Cash Advance APR?

Can I say "fingers" when referring to toes?

Creepy dinosaur pc game identification

Why is it that I can sometimes guess the next note?

Extract more than nine arguments that occur periodically in a sentence to use in macros in order to typset

On a tidally locked planet, would time be quantized?

Non-trope happy ending?

Does IPv6 have similar concept of network mask?

Why would a new[] expression ever invoke a destructor?

Does the Linux kernel need a file system to run?

How much character growth crosses the line into breaking the character

15% tax on $7.5k earnings. Is that right?

MariaDB Galera Cluster - first node won't reconnect after restart… Ever

Galera Cluster with MariaDB 10 and asynchronous slaveMariaDB Galera cluster node won't startMariadb galera cluster nodes won't stay joinedmariadb galera cluster stop one node automaticlyMariaDB Galera Cluster Replication1 Node crashed of 3 node mariadb galera clusterHow to restart MariaDB Galera cluster?Node unable to join a MariaDB Galera ClusterMariaDB Galera Cluster node fail to start after stoppingThird node cannot join Galera cluster after mariadb update

0

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

share|improve this question

asked Dec 20 '18 at 14:24

Mike MikeMike Mike

1

bumped to the homepage by Community♦ 3 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 | 

0

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

share|improve this question

asked Dec 20 '18 at 14:24

Mike MikeMike Mike

1

bumped to the homepage by Community♦ 3 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

share|improve this question

asked Dec 20 '18 at 14:24

Mike MikeMike Mike

1

share|improve this question

asked Dec 20 '18 at 14:24

Mike MikeMike Mike

1

share|improve this question

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 Answer
1

active

oldest

votes

0

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.

share|improve this answer

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
});


}
});

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

0

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.

share|improve this answer

answered Dec 22 '18 at 23:54

dbdemondbdemon

3,1672725

add a comment | 

0

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.

share|improve this answer

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.

share|improve this answer

answered Dec 22 '18 at 23:54

dbdemondbdemon

3,1672725

share|improve this answer

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