{"id":31529,"date":"2021-01-14T11:51:27","date_gmt":"2021-01-14T11:51:27","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=31529"},"modified":"2022-03-21T10:51:18","modified_gmt":"2022-03-21T10:51:18","slug":"high-availability-and-failover-design","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/","title":{"rendered":"High availability and failover design"},"content":{"rendered":"\n<p><strong><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/google-certified-professional-cloud-architect\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to GCP Tutorials<\/a><\/strong><\/p>\n\n\n\n<p>In this, we will learn about High availability and failover design.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>HA configuration overview<\/strong><\/h4>\n\n\n\n<p>Data redundancy is provided by the HA configuration, sometimes known as a cluster. A regional instance is a Cloud SQL instance that has been configured for high availability and is hosted in a primary and secondary zone within the defined region. Within a regional instance, however, the setup consists of a primary and a backup instance. All writes to the primary instance are replicated to the standby instance through synchronous replication to each zone&#8217;s persistent disc. This arrangement also decreases downtime in the case of an instance or zone failure, and your data remains accessible to client applications.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Failover overview<\/strong><\/h4>\n\n\n\n<p>Cloud SQL automatically switches to providing data from the standby instance if a HA-configured instance becomes unresponsive. This is referred to as a failover.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Process<\/strong><\/h4>\n\n\n\n<p>The following process occurs:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, the primary instance or zone fails.<ul><li>Each second, the primary instance writes to a system database as a heartbeat signal. However, if multiple heartbeats aren&#8217;t detected, failover is initiated. This occurs if the primary instance is unresponsive for approximately 60 seconds or the zone containing the primary instance experiences an outage.<\/li><\/ul><\/li><li>Secondly, the standby instance now serves data upon reconnection.<ul><li>Through a shared static IP address with the primary instance, the standby instance now serves data from the secondary zone.<\/li><\/ul><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/google-cloud-certified-professional-cloud-architect-free-practice-test\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"117\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-prac-tests-750x117.png\" alt=\"gcp cloud architect practice tests\" class=\"wp-image-31460\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-prac-tests-750x117.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-prac-tests.png 961w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Requirements<\/strong><\/h4>\n\n\n\n<p>For Cloud SQL to allow a failover, the configuration must meet the following requirements:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, the primary instance must be in a normal operating state (not stopped, undergoing maintenance, or performing a long-running Cloud SQL instance operation such as a backup, import or export operation).<\/li><li>Secondly, the secondary zone and standby instance must both be in a healthy state. When the standby instance is unresponsive and\/or replication to the secondary zone is interrupted, failover operations are blocked. Further, when Cloud SQL repairs the standby instance and the secondary zone is available, replication resumes and Cloud SQL allows failover.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Backup and restore<\/strong><\/h4>\n\n\n\n<p>Automated backups and point-in-time recovery must be enabled for high availability (point-in-time recovery uses binary logging).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Applications and instances<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Because there is no difference between dealing with non-HA and HA instances, your application does not require any special configuration. <\/li><li>Any existing connections to the primary instance, as well as read replicas, are closed when failover occurs. It will take around 2-3 minutes to reestablish connections to the primary instance. It may take longer to connect to copies. <\/li><li>As a result, your application reconnects using the same connection string or IP address, and you won&#8217;t have to adjust it after the failover.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Maintenance downtime<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, maintenance events affect primary instances configured with HA in the same way as any other instance. However, you can expect primary instances to be down during this time. Further, to minimize impact to your service, you can set a maintenance window to control when downtime occurs.<\/li><li>Secondly, when maintenance occurs on an instance, it does not fail over to the standby instance. Maintenance updates are applied to the standby instance at the same time as the primary instance.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Performance<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>The performance of regional persistent discs is influenced by a variety of factors: <ul><li>Examine the size of your vm instance type as well as the input and output of your workload. <\/li><li>Another measure to consider is that regional persistent disc with solid-state drives (SSD) has a greater latency than persistent disc with local SSD. That is, assuming your workload isn&#8217;t a streaming one and you&#8217;re concerned about latency. <\/li><li>Then, because a regional persistent disc with SSD has higher latency than a persistent disc with local SSD, it can&#8217;t achieve the input\/output operations per second (IOPS) limit. <\/li><li>Lastly, because the redundancy required to write two copies increases tail latency, this is the case.<\/li><\/ul><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/google-cloud-certified-professional-cloud-architect-practice-exam\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"117\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-online-course-750x117.png\" alt=\"High availability and failover design GCP cloud architect  online course\" class=\"wp-image-31461\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-online-course-750x117.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-online-course.png 961w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><strong>Reference:<\/strong> <a href=\"https:\/\/cloud.google.com\/sql\/docs\/mysql\/high-availability\" target=\"_blank\" rel=\"noreferrer noopener\">Google Documentation<\/a><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/google-certified-professional-cloud-architect\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to GCP Tutorials<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Go back to GCP Tutorials In this, we will learn about High availability and failover design. HA configuration overview Data redundancy is provided by the HA configuration, sometimes known as a cluster. A regional instance is a Cloud SQL instance that has been configured for high availability and is hosted in a primary and secondary&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-31529","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>High availability and failover design - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Enhance your skills about High availability and failover design using the Google Certified Professional Cloud Architect Course Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"High availability and failover design - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Enhance your skills about High availability and failover design using the Google Certified Professional Cloud Architect Course Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-21T10:51:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-prac-tests-750x117.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/\",\"name\":\"High availability and failover design - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-14T11:51:27+00:00\",\"dateModified\":\"2022-03-21T10:51:18+00:00\",\"description\":\"Enhance your skills about High availability and failover design using the Google Certified Professional Cloud Architect Course Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"High availability and failover design\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"High availability and failover design - Testprep Training Tutorials","description":"Enhance your skills about High availability and failover design using the Google Certified Professional Cloud Architect Course Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/","og_locale":"en_US","og_type":"article","og_title":"High availability and failover design - Testprep Training Tutorials","og_description":"Enhance your skills about High availability and failover design using the Google Certified Professional Cloud Architect Course Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2022-03-21T10:51:18+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Google-Certified-Professional-Cloud-Architect-prac-tests-750x117.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/","name":"High availability and failover design - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-14T11:51:27+00:00","dateModified":"2022-03-21T10:51:18+00:00","description":"Enhance your skills about High availability and failover design using the Google Certified Professional Cloud Architect Course Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-and-failover-design\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"High availability and failover design"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/31529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=31529"}],"version-history":[{"count":9,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/31529\/revisions"}],"predecessor-version":[{"id":53250,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/31529\/revisions\/53250"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=31529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=31529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=31529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}