Multi-Subnet Network SetupAlwaysOn Multi Subnet ConfigurationAlwaysON Availability Groups - IP address &...
Can I legally make a website about boycotting a certain company?
Why didn't Lorentz conclude that no object can go faster than light?
Why do climate experts from the UN/IPCC rarely mention Grand Solar Minimum?
Symbolism of number of crows?
I hate taking lectures, can I still survive in academia?
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
How changes in personality/values of a person who turned into a vampire can be explained?
Sing Baby Shark
Pictures from Mars
Run a command that requires sudo after a time has passed
Ethernet cable only works in certain positions
Should you blow through the final approach course if the ATC forgot about you?
Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once
Buying a "Used" Router
Ramanujan's radical and how we define an infinite nested radical
Can a planet be tidally unlocked?
Is layered encryption more secure than long passwords?
What happens if you declare more than $10,000 at the US border?
Is there any physical or computational justification for non-constructive axioms such as AC or excluded middle?
Discouraging missile alpha strikes
Why don't reads from /dev/zero count as IO?
find command cannot find my files which do exist
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
Why is opening a file faster than reading variable content?
Multi-Subnet Network Setup
AlwaysOn Multi Subnet ConfigurationAlwaysON Availability Groups - IP address & subnet change of secondary replica nodeServices Cannot Connect to Multi-Subnet Availability Group After FailoverHow to configure multi-site SQL Server 2014 Always On Availability Group for DRAG listener issues with ApplicationIntent=ReadOnlyAvailability Groups using Multi-Subnet Clustering: Preferred Owners for Roles and Possible Owners for AG Listener IPsMulti-Subnet AG - DNS flips to secondary IPAvailability Groups using Multi-Subnet Clustering: AG listener failed pingFailover from Primary to Asyn Secondary ReplicaAG Group failover and quorum
We currently have a 4 Node cluster used for our Availability Groups. 2 nodes in local data center and 2 nodes in remote data center.
Currently the 2 nodes local are Synchronous and the 2 remote nodes are ASynchronous.
They are setup in a multi-subnet network.
We are wanting to make one of the remote nodes Synchronous so that we can manually failover to the remote data center to run production traffic.
Our testing turned up a network issue that we did not think about.
We use DNS aliases to connect to the listener. (ex. product.company.com) that resolves to the primary through the listener IP address. When we failover manually to the remote node the listener IP stays in the local subnet IP.
My question is how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options.
Below is a crude diagram I tried to work up.
sql-server availability-groups
asked Jul 20 '17 at 11:31
user761786user761786
1831210
bumped to the homepage by Community♦ 5 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 |
We currently have a 4 Node cluster used for our Availability Groups. 2 nodes in local data center and 2 nodes in remote data center.
Currently the 2 nodes local are Synchronous and the 2 remote nodes are ASynchronous.
They are setup in a multi-subnet network.
We are wanting to make one of the remote nodes Synchronous so that we can manually failover to the remote data center to run production traffic.
Our testing turned up a network issue that we did not think about.
We use DNS aliases to connect to the listener. (ex. product.company.com) that resolves to the primary through the listener IP address. When we failover manually to the remote node the listener IP stays in the local subnet IP.
My question is how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options.
Below is a crude diagram I tried to work up.
sql-server availability-groups
asked Jul 20 '17 at 11:31
user761786user761786
1831210
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Did you configure the AG listener with two IP addresses, one for each subnet? And set RegisterAllIPs to 1 in the WSFC, as well as use the MultiSubnetFailover flag in the client connection string?
– Nic
Jul 20 '17 at 19:31
Yes, we have two IP's on the listener. One in each subnet. We have not messed with the RegisterAll setting on this cluster. The apps that can utilize the multisubnet flag do use it.
– user761786
Jul 20 '17 at 19:54
Adjust the register all, and that should resolve your problem (provided that you're using the multisubnet flag)
– Nic
Jul 21 '17 at 13:42
add a comment |
We currently have a 4 Node cluster used for our Availability Groups. 2 nodes in local data center and 2 nodes in remote data center.
Currently the 2 nodes local are Synchronous and the 2 remote nodes are ASynchronous.
They are setup in a multi-subnet network.
We are wanting to make one of the remote nodes Synchronous so that we can manually failover to the remote data center to run production traffic.
Our testing turned up a network issue that we did not think about.
We use DNS aliases to connect to the listener. (ex. product.company.com) that resolves to the primary through the listener IP address. When we failover manually to the remote node the listener IP stays in the local subnet IP.
My question is how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options.
Below is a crude diagram I tried to work up.
sql-server availability-groups
asked Jul 20 '17 at 11:31
user761786user761786
1831210
We currently have a 4 Node cluster used for our Availability Groups. 2 nodes in local data center and 2 nodes in remote data center.
Currently the 2 nodes local are Synchronous and the 2 remote nodes are ASynchronous.
They are setup in a multi-subnet network.
We are wanting to make one of the remote nodes Synchronous so that we can manually failover to the remote data center to run production traffic.
Our testing turned up a network issue that we did not think about.
We use DNS aliases to connect to the listener. (ex. product.company.com) that resolves to the primary through the listener IP address. When we failover manually to the remote node the listener IP stays in the local subnet IP.
My question is how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options.
Below is a crude diagram I tried to work up.
sql-server availability-groups
sql-server availability-groups
asked Jul 20 '17 at 11:31
user761786user761786
1831210
asked Jul 20 '17 at 11:31
user761786user761786
1831210
asked Jul 20 '17 at 11:31
user761786user761786
1831210
asked Jul 20 '17 at 11:31
user761786user761786
1831210
asked Jul 20 '17 at 11:31
user761786user761786
1831210
1831210
bumped to the homepage by Community♦ 5 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♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Did you configure the AG listener with two IP addresses, one for each subnet? And set RegisterAllIPs to 1 in the WSFC, as well as use the MultiSubnetFailover flag in the client connection string?
– Nic
Jul 20 '17 at 19:31
Yes, we have two IP's on the listener. One in each subnet. We have not messed with the RegisterAll setting on this cluster. The apps that can utilize the multisubnet flag do use it.
– user761786
Jul 20 '17 at 19:54
Adjust the register all, and that should resolve your problem (provided that you're using the multisubnet flag)
– Nic
Jul 21 '17 at 13:42
add a comment |
Did you configure the AG listener with two IP addresses, one for each subnet? And set RegisterAllIPs to 1 in the WSFC, as well as use the MultiSubnetFailover flag in the client connection string?
– Nic
Jul 20 '17 at 19:31
Yes, we have two IP's on the listener. One in each subnet. We have not messed with the RegisterAll setting on this cluster. The apps that can utilize the multisubnet flag do use it.
– user761786
Jul 20 '17 at 19:54
Adjust the register all, and that should resolve your problem (provided that you're using the multisubnet flag)
– Nic
Jul 21 '17 at 13:42
Did you configure the AG listener with two IP addresses, one for each subnet? And set RegisterAllIPs to 1 in the WSFC, as well as use the MultiSubnetFailover flag in the client connection string?
– Nic
Jul 20 '17 at 19:31
Did you configure the AG listener with two IP addresses, one for each subnet? And set RegisterAllIPs to 1 in the WSFC, as well as use the MultiSubnetFailover flag in the client connection string?
– Nic
Jul 20 '17 at 19:31
Yes, we have two IP's on the listener. One in each subnet. We have not messed with the RegisterAll setting on this cluster. The apps that can utilize the multisubnet flag do use it.
– user761786
Jul 20 '17 at 19:54
Yes, we have two IP's on the listener. One in each subnet. We have not messed with the RegisterAll setting on this cluster. The apps that can utilize the multisubnet flag do use it.
– user761786
Jul 20 '17 at 19:54
Adjust the register all, and that should resolve your problem (provided that you're using the multisubnet flag)
– Nic
Jul 21 '17 at 13:42
Adjust the register all, and that should resolve your problem (provided that you're using the multisubnet flag)
– Nic
Jul 21 '17 at 13:42
add a comment |
1 Answer
1
active
oldest
votes
how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options
So you don't want to configure applications to connect to the AG Listener's Hostname?
If you use a CNAME pointing to the Listener hostname, it should always return both IP addresses, and clients will handle picking between the IP addresses.
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
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%2f180340%2fmulti-subnet-network-setup%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
how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options
So you don't want to configure applications to connect to the AG Listener's Hostname?
If you use a CNAME pointing to the Listener hostname, it should always return both IP addresses, and clients will handle picking between the IP addresses.
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
add a comment |
how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options
So you don't want to configure applications to connect to the AG Listener's Hostname?
If you use a CNAME pointing to the Listener hostname, it should always return both IP addresses, and clients will handle picking between the IP addresses.
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
add a comment |
how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options
So you don't want to configure applications to connect to the AG Listener's Hostname?
If you use a CNAME pointing to the Listener hostname, it should always return both IP addresses, and clients will handle picking between the IP addresses.
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options
So you don't want to configure applications to connect to the AG Listener's Hostname?
If you use a CNAME pointing to the Listener hostname, it should always return both IP addresses, and clients will handle picking between the IP addresses.
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
answered Jul 20 '17 at 20:35
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
11.6k729
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%2f180340%2fmulti-subnet-network-setup%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
Did you configure the AG listener with two IP addresses, one for each subnet? And set RegisterAllIPs to 1 in the WSFC, as well as use the MultiSubnetFailover flag in the client connection string?
– Nic
Jul 20 '17 at 19:31
Yes, we have two IP's on the listener. One in each subnet. We have not messed with the RegisterAll setting on this cluster. The apps that can utilize the multisubnet flag do use it.
– user761786
Jul 20 '17 at 19:54
Adjust the register all, and that should resolve your problem (provided that you're using the multisubnet flag)
– Nic
Jul 21 '17 at 13:42