I would like to have a Postgres database which is in sync with my production database like a read-replica, but I would also like to write to that database. AWS provides read-replicas to be writable for MySQL and MariaDB but not Postgres. Is there any other way to achieve this?
Sync AWS RDS postgres db with writable RDS postgres db
2.6k Views Asked by codeKashmir At
1
There are 1 best solutions below
Related Questions in POSTGRESQL
- Why does adding a JOIN completely modify the query planner behaviour?
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Aggregate and count in PostgreSQL
- Rails HABTM: Select everything a that a record 'has'
- Trigger using data from inserted row
- Select results where joined table contains records with an attribute, but without another
- DB candidate as CouchDB/Schema replacement
- How do I properly add data in SQLAlchemy?
- Postgres in Conda Environment (Ubuntu 14.04)
- How to customize the output of the Postgres Pseudo Encrypt function?
- Split a large query (2 days) into pieces to increase the speed in Postgres
- Why does pg_search prefix not work like I expect?
- extracting meta info from a table psql using information_schema
- How to query a table in the database and copy it's data into one one?
- Update a table using info from a second table and a condition from a third table in Postgresql
Related Questions in AMAZON-WEB-SERVICES
- "Access Denied" - User's Permissions to S3 Bucket
- Cohort analysis with Amazon Redshift / PostgreSQL
- Using Amazon KMS service on Heroku
- can't ssh in after cloning an EC2 instance on Amazon AWS
- Using HDFS with Apache Spark on Amazon EC2
- How can I access Mule ESB Community edition via browser?
- AWS EC2: Migrating from Windows to Linux Server
- AWS ELB Load Balancer: is it possible to set multiple session cookies?
- AWS Flow Framework: Can we run activity worker and activity task on different EC2 instances
- Unable to access files from public s3 bucket with boto
- Cloudfront stream only part of the video
- s3cmd not working as cron-task when echos/dates are added
- How to deploy django 1.8 on Elastic Beanstalk using Docker
- InstanceProfile is required for creating cluster - create python function to install module
- How to fix WordPress HTTPS issues when behind an Amazon Load Balancer?
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 READ-REPLICATION
- Google Cloud SQL Read replica's in other regions within platform
- How Can I calculate Read Replica lag in RDS postgres?
- AWS RDS Read Replica but with different storage class/type
- Read replica database connection never used, goes back to default
- Streaming large result sets from an RDS postgres read replica and sqlalchemy terminates prematurely
- AWS RDS read-only machine -- how to add new user
- Amazon RDS Read Replica configuration Postgres database from an spring boot application deployed on PCF?
- Best practices for balancing between Google Cloud SQL postgres read replicas for App Engine App
- is this the correct way to setup route53 to point to a specific rds instance? aws
- MySQL Stored Procedure Read Replica Issue - Strange Stored Procedure/Function Behavior
- AWS RDS Read Replica on a different VPC
- MySQL JDBC driver not able to insert data into temporary table on read-replica
- What happens to Cloud SQL replicas on a restart/failover or instance increase
- Can we promote RDS read replica to primary using cloud formation template?
- How can we create cross region RDS read replica using AWS cloud formation template?
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?
Well, by definition, read replicas are not writable, so I'm afraid I don't think you'll have much luck with that approach.
Amazon themselves state that read replicas are for read only traffic:
Now, as you say, for MySQL read replicas can be promoted to masters (and therefore become writable), but pay special attention to the "when needed" below:
However, RDS itself does not support multi-master deployments for MySQL.
For PostgreSQL things are even "worse". AWS RDS for Postgres does not (at the time of writing this) support automatic promotion of read-replicas, leaving you with Multi-AZ as your only option.
Outside RDS, multi-master deployments of PostgreSQL (which sounds like what you're looking for) require an even more elaborate setup. You can find more information in the clustering section of their wiki.
As a general note, horizontally scaling relational / SQL databases is probably not something you'll have a lot of fun with and you're bound to run into problems along the way.
That's because they were simply not designed for horizontal scaling the same way that newer "NoSQL" databases are (take a look at MongoDB or Cassandra, etc.). You are far better off scaling them vertically, for as far as that will take you (and it will take you quite some way).
The only relational database that I know of that's (being) built to scale out is CockroachDB, but albeit a very promising solution, that's still in beta -- there's no 1.0 release of it yet.