Stack Overflow
Stack Overflow

Questions tagged [read-replication]

57 questions
8
votes
1 answer

Spring Boot and AWS RDS Read Replica

Here I am trying to achieve the below in AWS RDS. I have a MySQL database instance running. I am thinking of creating a read replica so that I will have some extra load sharing capabilities. I have a Spring Boot application running on EC2. Currently…
dharam
  • 7,882
  • 15
  • 65
  • 93
8
votes
3 answers

Difference between "Multi-AZ Deployment" and "Read Replica Verison Multi-AZ Deployment"

Summary Amazon RDS has two main different types of replicas, Multi-AZ Replica and Read Replica, and it's easily to find their difference. However, Read Replica had supported Multi-AZ deployment at JAN, 2018. What is the main difference between…
Chumicat
  • 162
  • 1
  • 1
  • 7
8
votes
3 answers

Creating Users on RDS MySQL Read Replicas

Is it possible/advisable to create users that only have access to a RDS MySQL Read Replica and not to the main database server? I have a number of power users I'd like to grant access so they can run slow running queries, but don't want to give them…
Eli
  • 36,793
  • 40
  • 144
  • 207
7
votes
2 answers

Streaming large result sets from an RDS postgres read replica and sqlalchemy terminates prematurely

I'm trying to run a large query using SQLAlchemy with the following code on a Postgres 9.4 RDS server set up as a read replica. # self.sa_engine is a SQLAlchemy engine with self.sa_engine.connect() as conn: conn =…
Sterling Paramore
  • 403
  • 7
  • 15
6
votes
1 answer

How to re-sync AWS RDS read replica

Is there a way to fix a read replica that has stopped syncing with the master database? I am already in the process of deleting it and creating a new one since I could not find this answer, but it would be nice to know if it happens again. The…
James
  • 3,765
  • 4
  • 48
  • 79
6
votes
3 answers

Confused about AWS RDS read replica databases. Why can I edit rows?

Edit: I'm not trying to edit the read replica. I'm saying I did edit it and I'm confused on why I was able to. I have a database in US-West. I made a read replica in Mumbai, so the users in India don't experience slowness. Out of curiosity, I tried…
AskYous
  • 4,332
  • 9
  • 46
  • 82
5
votes
2 answers

Can we promote RDS read replica to primary using cloud formation template?

We can easily promote RDS read replica using console and CLI, but is there a way to give master access means promote to primary using cloud formation?
Prashant Goel
  • 141
  • 1
  • 7
4
votes
4 answers

django, multi-databases (writer, read-reploicas) and a sync issue

So... in response to an API call I do: i = CertainObject(paramA=1, paramB=2) i.save() now my writer database has a new record. Processing can take a bit and I do not wish to hold off my response to the API caller, so the next line I am transferring…
JasonGenX
  • 4,952
  • 27
  • 106
  • 198
3
votes
1 answer

Does migration in a DB automatically gets reflected in read replica?

I created a read replica from Postgres DB in AWS RDS. Now if I run a migration in main DB will the read replica automatically migrate?
Sarwar
  • 415
  • 4
  • 10
3
votes
1 answer

AWS RDS Read Replica on a different VPC

I am trying to create an rds mysql read replica in a different vpc in the same region. This doesn't seem to work. I am getting the below error. I am able to create a cross region read replica, here obviously the vpcs are different. But it works…
SPK
  • 31
  • 2
3
votes
1 answer

Index not used in Postgresql read-replica. Why?

I have a relatively large table on an Amazon RDS production database (in the range of 2M records). I wish to group on a number of fields, including the month of a date (server_time) in the table. To speed things up a bit, I have created an index on…
Yves V.
  • 775
  • 1
  • 7
  • 20
3
votes
1 answer

Sync AWS RDS postgres db with writable RDS postgres db

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…
codeKashmir
  • 77
  • 10
2
votes
1 answer

How to get credentials for a RDS read replica?

I have created a read replica for my Production RDS instance, However I don't know where can I see the log-in credentials of the replica. When I go to the secrets manages screen and try to create a new secret the replica instance is not present. And…
moshevi
  • 4,999
  • 5
  • 33
  • 50
2
votes
0 answers

AWSCLI: Can't specify db parameter group when creating mysql read replica

Using awscli, I'm trying to create a cross-region read replica, in us-west-1, of a mysql RDS in us-east-1. The db must have the lower_case_table_names parameter set to 1(default is 0). I have created a custom db parameter group with this setting.…
Todd Meder
  • 21
  • 3
2
votes
1 answer

Symfony and RDS Replication lag

I have a project actually running on Symfony 3.4, and I use AWS RDS Master/Slaves config on a MySQL database. Sometimes during the day, I have the replication lag increasing for short period. I would like to know if there was a smart way to disable…
Floran
  • 136
  • 14
1
2 3 4