Manage switchover and data synchronisation between live and alternative

[rija]

User Story

As a website user
I want to not meet downtime whenever a new version of of the GigaDB with infrastructure changes is released
So that I'm not interrupted or delayed when I use GigaDB

Acceptance criteria

Given a release of GigaDB is made involving infrastructure changes
When the infrastructure change are performed
Then there is no visible downtime to website users

Given a release of GigaDB is made involving infrastructure changes
When the infrastructure changes are made
Then it doesn't cause downtime to users of the live bastion users

Additional infos

• Setup on the alternative bastion (bastion-alt.gigadb.host) a daily rclone sync job for keeping user dropboxes in sync between live and alternative #2000
• Make cronjob infrastructure aware of which infrastructure they are running on #2001
• Update documentation on to proceed to switchover between infrastructure #2002

Question: What if a deployment includes new data with regard to the data sync on alternative of live data?

Pre-requisite:

• Have gigadb.org's DNS server is moved to Clouflare

[rija]

Hi @pli888,

Please note the pre-requisite here, we need to be using Cloudflare as the DNS server for the gigadb.org domain.
We don't need to transfer domain. We just need to tell Alibaba Registry we use Clouflare as the DNS server by setting up Alibba registry records with the two name servers address Cloudflare will generate when we add new domain to Cloudflare DNS configuration.

[kencho51]

Hi @rija @pli888,

I found a tool that may be able to sync two rds instance, it is call pgsync, someone has tried to use it to sync 2 rds psql instances

[kencho51]

Regarding the RDS cross region backup, here are some information to note:

1. The source and destination regions have to be followed this table: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReplicateBackups.html

2. The official CentOS AMI only available in some aws region as in here: https://www.centos.org/download/aws-images/#centos-amazon-ami-images, for example, only the following 6 regions in Asia Pacific have the CentOS AMI:

3 Currently,

region	user	services
ap-east-1 (HK)	gigadb	current production gigadb.org
ap-northeast-1 (Tokyo)	Peter	vsftpd_nodemonitor_peter
ap-northeast-2 (Seoul)	Ken	development
ap-southeast-1 (Singapore)	-	gigabyte, gigablog
ap-southeast-2 (Sydney)	gigadb	current alternative gigadb.org
ap-south (Mumbai)	Peter	developemt

4. As discussed in 20/2 VOH, the productions will be deployed to Tokyo and Seoul regions

[kencho51]

Information

• Entry point: Replicating automated backups to another AWS Region

• Video: Managed Disaster Recovery with Amazon RDS for Oracle Cross-Region Automated Backups

• Steps: Enabling cross-Region automated backups for Amazon RDS

• Steps: Restoring to a specified time from a replicated backup for Amazon RDS