{"id":6442,"date":"2020-06-16T11:40:18","date_gmt":"2020-06-16T04:40:18","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/gioi-thieu-ban-sao-lien-vung-cho-cloud-sql\/"},"modified":"2023-04-19T11:18:21","modified_gmt":"2023-04-19T04:18:21","slug":"introducing-cross-region-replica-for-cloud-sql","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/","title":{"rendered":"Introducing cross-region replica for Cloud SQL"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Being responsible for business continuity isn\u2019t easy. You must consider a wide variety of failure scenarios, including the outage of a Google region. In the event of a regional outage, you want your application and database to quickly start serving your customers in another available region if a Google Cloud region fails.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google has worked closely with its customers <a href=\"https:\/\/gcloudvn.com\/en\/cloud-sql\/\">Cloud SQL<\/a> faces business continuity challenges to simplify experiences, and we&#039;re excited to launch multi-region replication of Cloud SQL, available for MySQL and PostgreSQL database engines.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/#Ban_sao_lien_vung_cho_Cloud_SQL_la_gi\" >What is a cross-region replica for Cloud SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/#Su_dung_ban_sao_lien_vung_cua_Cloud_SQL\" >Using Cloud SQL cross-region replicas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/#Don_gian_va_an_toan_theo_mac_dinh\" >Simple and secure, by default<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/#Quan_ly_hoan_toan\" >Fully managed\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/#Mang_Google_Cloud\" >Google Cloud networking<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/#Bao_mat_va_quyen_rieng_tu_cua_Cloud_SQL\" >Cloud SQL security and privacy<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/introducing-cross-region-replica-for-cloud-sql\/#Bat_dau_voi_ban_sao_xuyen_khu_vuc\" >Getting started with cross-region replica<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ban_sao_lien_vung_cho_Cloud_SQL_la_gi\"><\/span><b>What is a cross-region replica for Cloud SQL?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">Cross-region replica makes it easy to create a fully managed read replica in a different region than that of the primary instance. You can create a replica in any Google Cloud region.<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">Google has heard from Major League Baseball (MLB) that cross-region replicas have been useful. \u201cWe store all our important tracking information such as location of player, pitch velocity, and even the wind data on Cloud SQL for PostgreSQL,\u201d<\/span><\/i><i><span style=\"font-weight: 400;\">says Greg Cain, MLB vice president, Baseball Data.<\/span><\/i><i><span style=\"font-weight: 400;\"> We take great pride as the national pastime with millions of fans across the U.S., but we also have a large fanbase beyond that which spans all seven continents around the world. Our global audiences enjoy watching games at all times of day on MLB.com and our different consumer products. Cross-region replication was a very critical feature for us to implement to provide uninterrupted services to our fans.\u201d<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16090 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2020\/06\/NEws-9.png\" alt=\"Introducing cross-region replication for Cloud SQL 1\" width=\"1000\" height=\"540\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_ban_sao_lien_vung_cua_Cloud_SQL\"><\/span><b>Using Cloud SQL cross-region replicas<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">With cross-region replica, you can:<\/span><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Minimize recovery point objective (RPO): Cross-region replicas are copies of the master that reflect changes to the master in real time, so data loss is minimal in the event of one occurring. error in one <a href=\"https:\/\/gcloudvn.com\/en\/google-cloud-platform\/\">Google Cloud<\/a> Region.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Minimize recovery time objective (RTO): Cross-region replica maintains an online copy of your data in another region. In the event of Google Cloud region failure, a replica can be promoted within minutes.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Make globally distributed applications faster: Read replicas are closer to their application in another region.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Migrate data between regions: Use cross-region replicas to minimize downtime when moving data between regions.<\/span><\/li>\n<\/ol>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Don_gian_va_an_toan_theo_mac_dinh\"><\/span><b>Simple and secure, by default<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cloud SQL multi-region replication reduces operational costs and is fully integrated with Google Cloud&#039;s security and privacy features.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\">\n<h3><span class=\"ez-toc-section\" id=\"Quan_ly_hoan_toan\"><\/span><b>Fully managed\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Easily set up, maintain, manage, and administer replicas in any region on Google Cloud.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\">\n<h3><span class=\"ez-toc-section\" id=\"Mang_Google_Cloud\"><\/span><b>Google Cloud networking<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Creating a cross-region replica requires no networking setup. Global VPC uses private IP for replication traffic between regions\u2014eliminating the need of complex VPN and VPC configuration, which would be otherwise needed to set up cross-region networking.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cross-region replication traffic uses reliable, high-performing, and scalable Google Cloud networking.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Network monitoring, verification, and optimization is simplified using proactive network operations with Network Intelligence Center.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\">\n<h3><span class=\"ez-toc-section\" id=\"Bao_mat_va_quyen_rieng_tu_cua_Cloud_SQL\"><\/span><b>Cloud SQL security and privacy<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Data at rest in replicas is encrypted using <\/span><a href=\"https:\/\/cloud.google.com\/sql\/docs\/mysql\/cmek\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">customer-managed encryption keys (CMEK)<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cross-region replication traffic remains private, without access to and from the public internet, when a private IP option is used.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cross-region replicas are supported as part of Access Transparency, which represents Google\u2019s long-term commitment to security and transparency by providing you with logs that capture the actions Google personnel take when accessing your content.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Connection org policy control provides centralized control of the public IP settings of Cloud SQL to reduce the security attack surface of Cloud SQL instances from the internet.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cloud SQL will enforce the data residency policy you define. Replicas can only be created in permitted regions.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau_voi_ban_sao_xuyen_khu_vuc\"><\/span><strong>Getting started with cross-region replica<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Creating a cross-region replica is as simple as creating a read replica.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16091 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2020\/06\/news-10.png\" alt=\"Introducing cross-region replication for Cloud SQL 2\" width=\"512\" height=\"268\" \/><\/p>\n<p style=\"text-align: right;\"><strong>Source: Gimasys<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Ch\u1ecbu tr\u00e1ch nhi\u1ec7m cho ho\u1ea1t \u0111\u1ed9ng kinh doanh li\u00ean t\u1ee5c th\u1eadt kh\u00f4ng d\u1ec5 d\u00e0ng. B\u1ea1n ph\u1ea3i xem x\u00e9t nhi\u1ec1u t\u00ecnh hu\u1ed1ng th\u1ea5t b\u1ea1i kh\u00e1c nhau, bao g\u1ed3m c\u1ea3 vi\u1ec7c ng\u1eebng ho\u1ea1t \u0111\u1ed9ng c\u1ee7a m\u1ed9t region Google. Trong tr\u01b0\u1eddng h\u1ee3p m\u1ed9t&hellip;<\/p>","protected":false},"author":1,"featured_media":6443,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6442","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=6442"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6442\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/6443"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=6442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=6442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=6442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}