Improve speed of GCP SQL FailoverImprove Speed of MySQL Database ImportHow to improve the update speed of...
Why is Acetic acid (pKa = 4.76) stronger than carbonic acid (pKa = 6.36)?
Was Opportunity's last message to Earth "My battery is low and it's getting dark"?
How to deal with an underperforming subordinate?
Running away from a conflict
What is wrong with my use of "find -print0"?
Performance and power usage for Raspberry Pi in the Stratosphere
How to regain lost focus?
How can I handle players killing my NPC outside of combat?
Using Ansible, how can I take actions on each file in a specific location?
Third wheel character
Is "accuse people to be racist" grammatical?
Is practicing on a digital piano harmful to an experienced piano player?
Why don't you get burned by the wood benches in a sauna?
show notifications of new e-mails without displaying the content
How to wrap a figure in exam document?
Why can't I set the 'prototype' of a function created using 'bind'?
What is an efficient way to digitize a family photo collection?
What could cause an entire planet of humans to become aphasic?
Did ancient Germans take pride in leaving the land untouched?
What happened to Hermione’s clothing and other possessions after she wiped her parents’ memories of her?
Why write a book when there's a movie in my head?
Connecting to SMTP server from AWS Lambda
How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?
Why do single electrical receptacles exist?
Improve speed of GCP SQL Failover
Improve Speed of MySQL Database ImportHow to improve the update speed of large tables?MySQL compression on Google Cloud SQLHow to speed up datetime MySQL queries or improve db scheme for time series data?How to improve speed of MYSQL queryIs using innodb_file_per_table improve speed of alter table command?Durability of storage in second generation google cloud sqlWill performance and speed improve when retrieving data from a .txt file instead of the Database?Why use Failover replica on Google Cloud RDS?Binary log CLOUD SQL
I've been trying out GCPs SQL high availability options. Is there a way to improve the fail over speed?
Attempting manual failovers through the UI takes literally over 5 minutes where mysql is completely unavailable.
I am using the smallest second generation 5.7 instances possible currently with no traffic hitting it.
It looks like it's actually stopping and starting instances. I'm having trouble seeing how this is an option for "HA" meaning minimal downtime.
mysql google-cloud-sql
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
New contributor
Mike Siekkinen 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 |
I've been trying out GCPs SQL high availability options. Is there a way to improve the fail over speed?
Attempting manual failovers through the UI takes literally over 5 minutes where mysql is completely unavailable.
I am using the smallest second generation 5.7 instances possible currently with no traffic hitting it.
It looks like it's actually stopping and starting instances. I'm having trouble seeing how this is an option for "HA" meaning minimal downtime.
mysql google-cloud-sql
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
New contributor
Mike Siekkinen 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 |
I've been trying out GCPs SQL high availability options. Is there a way to improve the fail over speed?
Attempting manual failovers through the UI takes literally over 5 minutes where mysql is completely unavailable.
I am using the smallest second generation 5.7 instances possible currently with no traffic hitting it.
It looks like it's actually stopping and starting instances. I'm having trouble seeing how this is an option for "HA" meaning minimal downtime.
mysql google-cloud-sql
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
New contributor
Mike Siekkinen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I've been trying out GCPs SQL high availability options. Is there a way to improve the fail over speed?
Attempting manual failovers through the UI takes literally over 5 minutes where mysql is completely unavailable.
I am using the smallest second generation 5.7 instances possible currently with no traffic hitting it.
It looks like it's actually stopping and starting instances. I'm having trouble seeing how this is an option for "HA" meaning minimal downtime.
mysql google-cloud-sql
mysql google-cloud-sql
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
New contributor
Mike Siekkinen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
New contributor
Mike Siekkinen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
New contributor
Mike Siekkinen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
asked 3 mins ago
Mike SiekkinenMike Siekkinen
1
1
New contributor
Mike Siekkinen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Mike Siekkinen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Mike Siekkinen 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
});
}
});
Mike Siekkinen 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%2f230583%2fimprove-speed-of-gcp-sql-failover%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
Mike Siekkinen is a new contributor. Be nice, and check out our Code of Conduct.
Mike Siekkinen is a new contributor. Be nice, and check out our Code of Conduct.
Mike Siekkinen is a new contributor. Be nice, and check out our Code of Conduct.
Mike Siekkinen 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.
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%2f230583%2fimprove-speed-of-gcp-sql-failover%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
