Stack Overflow
Stack Overflow

Questions tagged [read-replication]

57 questions
2
votes
0 answers

is this the correct way to setup route53 to point to a specific rds instance? aws

Earlier I was asking about how I can direct a geolocation to use a read replica rds instance in other origin and test it. Route 53 was mentioned and I was then reading the documentation and played around. But I am not sure if I am doing it right,…
Tsuna
  • 2,098
  • 6
  • 24
  • 46
2
votes
1 answer

How can we create cross region RDS read replica using AWS cloud formation template?

I have easily found a way to create RDS read replica in same region using AWS cloud formation, but: 1. Can we create the same in different region using CF template? 2. Also can we promote it to primary using CF template?
Prashant Goel
  • 141
  • 1
  • 7
2
votes
1 answer

Cannot create a cross region unencrypted read replica from encrypted source

I am trying to create a read replica in west region for an RDS data base in east through cloud formation template. I am getting an error: Cannot create a cross region unencrypted read replica from encrypted source. However, I have tried to provide…
Ishu Gupta
  • 1,071
  • 1
  • 19
  • 43
2
votes
0 answers

Unexplained Spike in RDS replica lag

We have a RDS read-replica server. We found some spike in replica lag as shown below: Click here to see the observed replica lag. However, when we checked the general log we did not find any insert,delete,optimize or alter commands. Can anyone…
Subrata Das
  • 121
  • 4
2
votes
0 answers

How to use ReplicationDriver with multiple EntityManager with Spring

I have 2 databases (let's call them User and Stuff), connected to a single Spring-java-web-application via 2 different EntityManager. Stuff has read-replica associated with it. When I'm using com.mysql.jdbc.Driver to connect to both the dbs, it's…
thekosmix
  • 1,705
  • 21
  • 35
1
vote
1 answer

Aws RDS MySql master and slave as EC2 MySql replica for Data sync

Is it possible to configure Aws RDS Mysql version 8+ as Master and Slave as mysql replica installed in EC2 machine for data sync purpose ?? Tried syncing with RDS master and mysql installed in Ec2 replica but failed, getting error in GTID.
Ajith R
  • 11
  • 1
1
vote
1 answer

RDS Blue/Green deployment not working with instances having read replica

I was experimenting with RDS Blue/Green deployment , it worked fine with normal instance but when I tried with instance having read replicas in different region , after clicking on Create Blue/Green deployment it's just showing loader eg . Main…
Life Of Traveller
  • 11
  • 2
1
vote
1 answer

ActiveRecord::ConnectionTimeoutError for background jobs with read replica

We recently implemented a read-replica in our Rails 6 application. We are only using it for specific transactions by wrapping them in a block: ActiveRecord::Base.connected_to(role: :reading) do # read query here end In application_record.rb we…
hummmingbear
  • 2,294
  • 5
  • 25
  • 42
1
vote
2 answers

What is the replication method used for the GCP CloudSQL Read Replica for Postgresql

Based on the descriptions it seems that for the Read Replicas for Postgresql, the Write-Ahead Log Shipping is used. Is it logical? I have tables without primary keys, however when I spin up a read replica I have no problems so wonder what is being…
gkatzioura
  • 2,655
  • 2
  • 26
  • 39
1
vote
1 answer

AWS RDS MySQL Read Replica - do I need to update my API to point to the replica for any URIs that are only reading?

This is the first time I have worked with a read replica so please bare with me. I tried multiple searches on here and google to no avail. I know how a primary database instance and a read replica on RDS. Replication is working great, I can connect…
OperationVoid
  • 61
  • 8
1
vote
1 answer

What happens with AWS Aurora Read Replica in case of AZ failure

I can't seem to find anywhere the answer to this question. We have an AWS Aurora cluster with a R/W instance and a read replica (multi-AZ). What happens with the read replica in case of a failure of it's AZ? What would the DR plan be? Will AWS…
Dan Nemes
  • 300
  • 3
  • 16
1
vote
1 answer

Amazon DynamoDB read latency while writing

I have an Amazon DynamoDB table which is used for both read and write operations. Write operations are performed only when the batch job runs at certain intervals whereas Read operations are happening consistently throughout the day. I am facing a…
Tyr1on
  • 1,999
  • 2
  • 13
  • 20
1
vote
1 answer

Best practices for balancing between Google Cloud SQL postgres read replicas for App Engine App

We are making a move towards cloud deployment right now, and in that process would like to create some read replicas for our database. I am confused as to what the suggested method for balancing requests between Cloud SQL read replicas. It seems…
Ben Dunk
  • 11
  • 2
1
vote
1 answer

AWS RDS Read Replica

I have dotNet core application and it's MySQL RDS database configured in London AWS region, used by UK users. I now have users connecting from Australia who are experiencing slow performance when using the UK app. I would like to improve the…
DiegoChicken
  • 23
  • 6
1
vote
2 answers

MySQL JDBC driver not able to insert data into temporary table on read-replica

I am connecting to read-replica instance of MySQL (actually, Google Cloud SQL). The JDBC driver seems to be able to create temporary table but not able to insert data into it. But, using another client (in my case MySQL workbench), I am able to…
Learner
  • 533
  • 5
  • 18
1
2
3 4