Introducing cross-region replica for Cloud SQL

Being responsible for business continuity isn’t 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.

Google đã hợp tác chặt chẽ với các khách hàng của Cloud SQL đối mặt với các thách thức liên tục trong kinh doanh để đơn giản hóa trải nghiệm và chúng tôi rất vui mừng ra mắt bản sao đa vùng của Cloud SQL, có sẵn cho các công cụ cơ sở dữ liệu MySQL và PostgreQuery.

What is a cross-region replica for Cloud SQL?

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.

Google has heard from Major League Baseball (MLB) that cross-region replicas have been useful. “We store all our important tracking information such as location of player, pitch velocity, and even the wind data on Cloud SQL for PostgreSQL,”says Greg Cain, MLB vice president, Baseball Data. 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.”

Using Cloud SQL cross-region replicas

With cross-region replica, you can:

1. Giảm thiểu mục tiêu điểm khôi phục (RPO): Bản sao giữa các region là bản sao của bản chính phản ánh các thay đổi đối với bản chính trong thời gian thực, do đó, mất dữ liệu là rất nhỏ trong trường hợp xảy ra lỗi ở một Google Cloud Region.
2. 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.
3. Make globally distributed applications faster: Read replicas are closer to their application in another region.
4. Migrate data between regions: Use cross-region replicas to minimize downtime when moving data between regions.

Simple and secure, by default

Bản sao đa vùng của Cloud SQL giúp giảm chi phí hoạt động và được tích hợp hoàn toàn với các tính năng bảo mật và bảo mật của Cloud của Google.

• Fully managed 

  • Easily set up, maintain, manage, and administer replicas in any region on Google Cloud.

• Google Cloud networking

  • Creating a cross-region replica requires no networking setup. Global VPC uses private IP for replication traffic between regions—eliminating the need of complex VPN and VPC configuration, which would be otherwise needed to set up cross-region networking.
  • Cross-region replication traffic uses reliable, high-performing, and scalable Google Cloud networking.
  • Network monitoring, verification, and optimization is simplified using proactive network operations with Network Intelligence Center.

• Cloud SQL security and privacy

  • Data at rest in replicas is encrypted using customer-managed encryption keys (CMEK).
  • Cross-region replication traffic remains private, without access to and from the public internet, when a private IP option is used.
  • Cross-region replicas are supported as part of Access Transparency, which represents Google’s long-term commitment to security and transparency by providing you with logs that capture the actions Google personnel take when accessing your content. 
  • 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.
  • Cloud SQL will enforce the data residency policy you define. Replicas can only be created in permitted regions.

Getting started with cross-region replica

Creating a cross-region replica is as simple as creating a read replica.

Source: Gimasys