I have two MYSQL RDS Instance in Ohio and Mumbai region. Both RDS instance should sync each other. Does AWS have any services to enable sync between RDS Database? else should we configure to achieve? Both RDS should sync by hourly or daily. Can any one please advice on this?
How to sync RDS database across regions in AWS
1.6k Views Asked by Lakshminarayanan S At
1
There are 1 best solutions below
Related Questions in AMAZON-RDS
- Installing the Kmeans PostgreSQL extension on Amazon RDS
- How do I Start/Stop AWS RDS Instances using Boto?
- AWS RDS: how to monitor data transfer out
- RDS instance storage limit handling
- Connecting to SQL Server on AWS RDS
- AWS RDS on Eclipse
- Using an AWS RDS instance across multiple VPC
- Controlling EC2 and RDS access for third party
- Can dumping and restoring database make it slower?
- Communication between Android and EC2 with RDS
- Is there any way to point ELB URL to RDS?
- Cant create postgres base type (with hstore/pgcrypto extensions) on amazon RDS
- Create user with no privileges in RDS for MySQL fails, error 1396
- How to have multiple RDS read replicas in Magento?
- How to take a backup of data to a local machine from the AWS?
Related Questions in AWS-DATASYNC
- Which permissions for a cross-accounts transfert across two s3 with aws-datasync
- AWS DataSync Agent Key Generation with VPC Endpoint
- Recurrent auto-sync of assets from one S3 bucket to another in separate account
- Describing ENI error when executing DataSync task in Fargate/Lambda
- How to set schedule of DataSync Task to "Not Scheduled" from AWS Lambda?
- Sync S3 Objects Across Bucket with Intelligent Tiering
- How can i access error individual attributes in golang
- ECS Fargate with EFS Volume update data
- AWS DataSync agent ran into an error connecting to AWS
- AWS Autosync : moving data from FTP server to S3
- Invalid parameter: ARN account () must match authenticated user.",
- AWS Datasync S3 -> S3 cross account, confused about destination role/account
- AWS data sync vs storage gateway use case
- DataSync agent ran into an error connecting to AWS
- Ensure data is not lost during AWS S3 sync
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You cannot setup bi-directional replication with 2 RDS instances. However, you can provision an RDS instance in one region as writer, and create a read replica for it in another region. It can be used only for reading purposes. You can make it writable, but it would not sync data back to first region, and can also cause replication issues.
Even a somewhat manual method to sync data can cause data consistency issues.