Skip to content

Instantly share code, notes, and snippets.

@gitschaub

gitschaub/data_replication.md

Created November 26, 2018 21:31
Show Gist options
  • Save gitschaub/0a3015f34a6bad70a0c43af06afc8cca to your computer and use it in GitHub Desktop.
Save gitschaub/0a3015f34a6bad70a0c43af06afc8cca to your computer and use it in GitHub Desktop.
Download ZIP
Raw
data_replication.md

Data Replication Strategies for Multi Cluster

=============================================

Amazon RDS

https://aws.amazon.com/rds/

Deploy read-only replicas to increase read performance. Available for MySQL, MariaDB, PostgreSQL, Amazon Aurora. Support for running active-standby instances

Provides synchronous replication and mirroring based on each engine's capabilities. Aurora provides primary failover as well as promotion of read-only replicas in the event of a failure.

AWS S3

S3 provides policy to copy objects across different AWS regions.

GCE SQL

https://cloud.google.com/sql/

PostgreSQL & MySQL for SQL services, deployed as managed GCE instances. Supports read replication. Does not support reader upgrades for HA as in AWS.

GCE Storage

https://cloud.google.com/storage/

Cloud storage is block. Four storage classes, Multi-Regional is geo-redundant. No specific placement, i.e. region is only granular to us or eu, etc. Can achieve targeted placement with dual-regional locations that merge multiple locations into a single "region", i.e. us-1 == us-west + us-central.

Azure

https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy

Local, Zone, and Regional replication.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment