Mysql And Galera cluster mariaDB , Private and Public IP Addresses multisite
I am just wondering has anyone come accross this before and the best method to go about doing it.
We have a customer that wants multi site replication over a galera cluster.
I am familiar with setting this up but not in the way they are asking for.
First of all the client has a dedicated L2 connection between the datacentres so I have set up the cluster with Private IP addresses going across the dedicated L2 link, the issue is if the L2 link goes down they loose the replication between sites, So I was thinking of natting the nodes private IP addresses to Public IPs.
My question is: Is there a way I can set the galera cluster so that if it cant reach the private IPs it will go out over the internet through the firewall and hit the public IPs?
Could I maybe put the private and public IPs of each site within this setting:
wsrep_cluster_address=gcomm://server1private_IP1,server1public_IP1,server2private_IP1,server2public_ip1 etc
Saying that server1 is local in my datacentre and server2 is in another datacentre.
Or would that write the data twice over the 2 links?
Thanks in advance for any help that is thrown my way.
mysql mariadb galera
edited Dec 14 '16 at 9:15
hot2use
8,15952055
asked Dec 13 '16 at 16:56
JamesGJamesG
61
bumped to the homepage by Community♦ 2 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 |
I am just wondering has anyone come accross this before and the best method to go about doing it.
We have a customer that wants multi site replication over a galera cluster.
I am familiar with setting this up but not in the way they are asking for.
First of all the client has a dedicated L2 connection between the datacentres so I have set up the cluster with Private IP addresses going across the dedicated L2 link, the issue is if the L2 link goes down they loose the replication between sites, So I was thinking of natting the nodes private IP addresses to Public IPs.
My question is: Is there a way I can set the galera cluster so that if it cant reach the private IPs it will go out over the internet through the firewall and hit the public IPs?
Could I maybe put the private and public IPs of each site within this setting:
wsrep_cluster_address=gcomm://server1private_IP1,server1public_IP1,server2private_IP1,server2public_ip1 etc
Saying that server1 is local in my datacentre and server2 is in another datacentre.
Or would that write the data twice over the 2 links?
Thanks in advance for any help that is thrown my way.
mysql mariadb galera
edited Dec 14 '16 at 9:15
hot2use
8,15952055
asked Dec 13 '16 at 16:56
JamesGJamesG
61
bumped to the homepage by Community♦ 2 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 |
I am just wondering has anyone come accross this before and the best method to go about doing it.
We have a customer that wants multi site replication over a galera cluster.
I am familiar with setting this up but not in the way they are asking for.
First of all the client has a dedicated L2 connection between the datacentres so I have set up the cluster with Private IP addresses going across the dedicated L2 link, the issue is if the L2 link goes down they loose the replication between sites, So I was thinking of natting the nodes private IP addresses to Public IPs.
My question is: Is there a way I can set the galera cluster so that if it cant reach the private IPs it will go out over the internet through the firewall and hit the public IPs?
Could I maybe put the private and public IPs of each site within this setting:
wsrep_cluster_address=gcomm://server1private_IP1,server1public_IP1,server2private_IP1,server2public_ip1 etc
Saying that server1 is local in my datacentre and server2 is in another datacentre.
Or would that write the data twice over the 2 links?
Thanks in advance for any help that is thrown my way.
mysql mariadb galera
edited Dec 14 '16 at 9:15
hot2use
8,15952055
asked Dec 13 '16 at 16:56
JamesGJamesG
61
I am just wondering has anyone come accross this before and the best method to go about doing it.
We have a customer that wants multi site replication over a galera cluster.
I am familiar with setting this up but not in the way they are asking for.
First of all the client has a dedicated L2 connection between the datacentres so I have set up the cluster with Private IP addresses going across the dedicated L2 link, the issue is if the L2 link goes down they loose the replication between sites, So I was thinking of natting the nodes private IP addresses to Public IPs.
My question is: Is there a way I can set the galera cluster so that if it cant reach the private IPs it will go out over the internet through the firewall and hit the public IPs?
Could I maybe put the private and public IPs of each site within this setting:
wsrep_cluster_address=gcomm://server1private_IP1,server1public_IP1,server2private_IP1,server2public_ip1 etc
Saying that server1 is local in my datacentre and server2 is in another datacentre.
Or would that write the data twice over the 2 links?
Thanks in advance for any help that is thrown my way.
mysql mariadb galera
mysql mariadb galera
edited Dec 14 '16 at 9:15
hot2use
8,15952055
asked Dec 13 '16 at 16:56
JamesGJamesG
61
edited Dec 14 '16 at 9:15
hot2use
8,15952055
asked Dec 13 '16 at 16:56
JamesGJamesG
61
edited Dec 14 '16 at 9:15
hot2use
8,15952055
edited Dec 14 '16 at 9:15
hot2use
8,15952055
edited Dec 14 '16 at 9:15
hot2use
8,15952055
8,15952055
asked Dec 13 '16 at 16:56
JamesGJamesG
61
asked Dec 13 '16 at 16:56
JamesGJamesG
61
asked Dec 13 '16 at 16:56
JamesGJamesG
61
61
bumped to the homepage by Community♦ 2 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♦ 2 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 |
add a comment |
1 Answer
1
active
oldest
votes
Maybe you can reach what you want changing gcomm ip addresses to custom non-FQDN hostnames (db1, db2, dbN). Then you can play a little bit with DNS resolution just updating your hosts file on each db node.
This is not official nor valuable solution anyway ;)
answered Jan 3 '18 at 14:07
fab23fab23
11
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%2f158060%2fmysql-and-galera-cluster-mariadb-private-and-public-ip-addresses-multisite%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
Maybe you can reach what you want changing gcomm ip addresses to custom non-FQDN hostnames (db1, db2, dbN). Then you can play a little bit with DNS resolution just updating your hosts file on each db node.
This is not official nor valuable solution anyway ;)
answered Jan 3 '18 at 14:07
fab23fab23
11
add a comment |
Maybe you can reach what you want changing gcomm ip addresses to custom non-FQDN hostnames (db1, db2, dbN). Then you can play a little bit with DNS resolution just updating your hosts file on each db node.
This is not official nor valuable solution anyway ;)
answered Jan 3 '18 at 14:07
fab23fab23
11
add a comment |
Maybe you can reach what you want changing gcomm ip addresses to custom non-FQDN hostnames (db1, db2, dbN). Then you can play a little bit with DNS resolution just updating your hosts file on each db node.
This is not official nor valuable solution anyway ;)
answered Jan 3 '18 at 14:07
fab23fab23
11
Maybe you can reach what you want changing gcomm ip addresses to custom non-FQDN hostnames (db1, db2, dbN). Then you can play a little bit with DNS resolution just updating your hosts file on each db node.
This is not official nor valuable solution anyway ;)
answered Jan 3 '18 at 14:07
fab23fab23
11
answered Jan 3 '18 at 14:07
fab23fab23
11
answered Jan 3 '18 at 14:07
fab23fab23
11
answered Jan 3 '18 at 14:07
fab23fab23
11
11
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%2f158060%2fmysql-and-galera-cluster-mariadb-private-and-public-ip-addresses-multisite%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
