Blue/Green via AlwaysOn
Full disclosure, definitely not a DBA. However, I've put together the following solution design to try to achieve a Blue/Green SQL Deployment.
See for Definition of Blue/Green: https://martinfowler.com/bliki/BlueGreenDeployment.html
Back Story:
We currently have 2 servers already setup in AlwaysOn, and my design is based upon a modification of what we currently have. The Goal here would be to add a 3rd Replica, another AlwaysOn Group with Dedicated Blue and Green endpoints.
I do not know if this is physically feasible though.
Questions:
- Can I have two Groups like this on the same server?
- Can I remove a Replica w/o destroying it?
- How long does it take to remove a Replica?
- Can I add a Replica as a Primary, w/o destroying it?
- How Long does it take to Add a Replica?
- How Long does it take for Replication from Primary to Secondary take? (This is obviously a loaded question w/o knowing how large are DBs are.)
Acceptance Criteria:
- The off-color database is still accessible, but read-only
- Green has a dedicated endpoint, that does not change.
- Blue has a dedicated endpoint, that does not change.
User Story:
- As an administrator, I want my blue/green databases at sync at all times (except during the release), so that I can deploy at any given time, without the need to backup and restore.
- As an administrator, I want the ability to switch databases sync direction in under 5-10 minutes, so that I can release without prior notice and little downtime.
sql-server sql-server-2014 availability-groups
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
New contributor
Devin Gleason Lambert 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 |
Full disclosure, definitely not a DBA. However, I've put together the following solution design to try to achieve a Blue/Green SQL Deployment.
See for Definition of Blue/Green: https://martinfowler.com/bliki/BlueGreenDeployment.html
Back Story:
We currently have 2 servers already setup in AlwaysOn, and my design is based upon a modification of what we currently have. The Goal here would be to add a 3rd Replica, another AlwaysOn Group with Dedicated Blue and Green endpoints.
I do not know if this is physically feasible though.
Questions:
- Can I have two Groups like this on the same server?
- Can I remove a Replica w/o destroying it?
- How long does it take to remove a Replica?
- Can I add a Replica as a Primary, w/o destroying it?
- How Long does it take to Add a Replica?
- How Long does it take for Replication from Primary to Secondary take? (This is obviously a loaded question w/o knowing how large are DBs are.)
Acceptance Criteria:
- The off-color database is still accessible, but read-only
- Green has a dedicated endpoint, that does not change.
- Blue has a dedicated endpoint, that does not change.
User Story:
- As an administrator, I want my blue/green databases at sync at all times (except during the release), so that I can deploy at any given time, without the need to backup and restore.
- As an administrator, I want the ability to switch databases sync direction in under 5-10 minutes, so that I can release without prior notice and little downtime.
sql-server sql-server-2014 availability-groups
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
New contributor
Devin Gleason Lambert 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 |
Full disclosure, definitely not a DBA. However, I've put together the following solution design to try to achieve a Blue/Green SQL Deployment.
See for Definition of Blue/Green: https://martinfowler.com/bliki/BlueGreenDeployment.html
Back Story:
We currently have 2 servers already setup in AlwaysOn, and my design is based upon a modification of what we currently have. The Goal here would be to add a 3rd Replica, another AlwaysOn Group with Dedicated Blue and Green endpoints.
I do not know if this is physically feasible though.
Questions:
- Can I have two Groups like this on the same server?
- Can I remove a Replica w/o destroying it?
- How long does it take to remove a Replica?
- Can I add a Replica as a Primary, w/o destroying it?
- How Long does it take to Add a Replica?
- How Long does it take for Replication from Primary to Secondary take? (This is obviously a loaded question w/o knowing how large are DBs are.)
Acceptance Criteria:
- The off-color database is still accessible, but read-only
- Green has a dedicated endpoint, that does not change.
- Blue has a dedicated endpoint, that does not change.
User Story:
- As an administrator, I want my blue/green databases at sync at all times (except during the release), so that I can deploy at any given time, without the need to backup and restore.
- As an administrator, I want the ability to switch databases sync direction in under 5-10 minutes, so that I can release without prior notice and little downtime.
sql-server sql-server-2014 availability-groups
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
New contributor
Devin Gleason Lambert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Full disclosure, definitely not a DBA. However, I've put together the following solution design to try to achieve a Blue/Green SQL Deployment.
See for Definition of Blue/Green: https://martinfowler.com/bliki/BlueGreenDeployment.html
Back Story:
We currently have 2 servers already setup in AlwaysOn, and my design is based upon a modification of what we currently have. The Goal here would be to add a 3rd Replica, another AlwaysOn Group with Dedicated Blue and Green endpoints.
I do not know if this is physically feasible though.
Questions:
- Can I have two Groups like this on the same server?
- Can I remove a Replica w/o destroying it?
- How long does it take to remove a Replica?
- Can I add a Replica as a Primary, w/o destroying it?
- How Long does it take to Add a Replica?
- How Long does it take for Replication from Primary to Secondary take? (This is obviously a loaded question w/o knowing how large are DBs are.)
Acceptance Criteria:
- The off-color database is still accessible, but read-only
- Green has a dedicated endpoint, that does not change.
- Blue has a dedicated endpoint, that does not change.
User Story:
- As an administrator, I want my blue/green databases at sync at all times (except during the release), so that I can deploy at any given time, without the need to backup and restore.
- As an administrator, I want the ability to switch databases sync direction in under 5-10 minutes, so that I can release without prior notice and little downtime.
sql-server sql-server-2014 availability-groups
sql-server sql-server-2014 availability-groups
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
New contributor
Devin Gleason Lambert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
New contributor
Devin Gleason Lambert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 51 mins ago
Devin Gleason Lambert
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
New contributor
Devin Gleason Lambert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
asked 59 mins ago
Devin Gleason LambertDevin Gleason Lambert
1063
1063
New contributor
Devin Gleason Lambert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Devin Gleason Lambert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Devin Gleason Lambert 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 |
0
active
oldest
votes
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
});
}
});
Devin Gleason Lambert is a new contributor. Be nice, and check out our Code of Conduct.
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%2f226716%2fblue-green-via-alwayson%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Devin Gleason Lambert is a new contributor. Be nice, and check out our Code of Conduct.
Devin Gleason Lambert is a new contributor. Be nice, and check out our Code of Conduct.
Devin Gleason Lambert is a new contributor. Be nice, and check out our Code of Conduct.
Devin Gleason Lambert is a new contributor. Be nice, and check out our Code of Conduct.
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f226716%2fblue-green-via-alwayson%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
