Stack Overflow
Stack Overflow

Questions tagged [read-replication]

57 questions
0
votes
1 answer

Read replica database connection never used, goes back to default

I'm following the documentation here https://symfony.com/doc/current/reference/configuration/doctrine.html about setting up alternative database connections for the purpose of read replication. For reference I'm using AWS Aurora PostgreSQL with end…
Rudiger
  • 6,749
  • 13
  • 51
  • 102
0
votes
1 answer

AWS RDS Read Replica but with different storage class/type

I have a master db in one region.. and I want to create a read replica of it in another region just for disaster recovery practices. I do not want it to be that costly, but I want the replication to work. My current master db has db.t2.medium. My…
devgirl
  • 671
  • 3
  • 16
  • 39
0
votes
1 answer

What is the best design for read optimized replica?

I need to design a scalable, read optimized access to a set of data we replicate from outside. For some of the data queried we have to keep in mind that it is not just data but code and data. If you take the example of hierarchies you will see that…
coders
  • 719
  • 1
  • 11
  • 35
0
votes
0 answers

Redis in-memory read replica of an RDS master

I have a high traffic web service. Each request SELECTs some data from an MSSQL RDS. The relevant tables in the RDS are very small, update/inserts will only happen few times a day. In order to minimize each request time, I wanted to have some sort…
Ben
  • 793
  • 2
  • 13
  • 29
0
votes
1 answer

What happens to Cloud SQL replicas on a restart/failover or instance increase

I have a highly available PostgreSQL instance on google cloud. Also there are some read replicas set for this database. In case of upgrading the Cloud SQL instance and adding more cores and memory a restart is needed. What will happen to the Read…
gkatzioura
  • 2,655
  • 2
  • 26
  • 39
0
votes
0 answers

spring boot database connection for master and slave databases

I have spring boot microservices running on AWS ECS. I am using aws rds postgress and spring boot. I have 3 microservices and so 3 different databases.. Now I want to implement read replica of rds in my spring boot application. How to configure so…
Mihir Shah
  • 1,799
  • 3
  • 29
  • 49
0
votes
1 answer

AWS RDS read-only machine -- how to add new user

I have two RDS mysql servers running, one is the main (master) rds server and the other is the read-only slave, which was created through the RDS console. How would I create a new user account for the read-only machine, that would not have access to…
David542
  • 104,438
  • 178
  • 489
  • 842
0
votes
1 answer

Are read replicas heavy read affect masterDB?

We have a very heavy load in Read side with large DB tables in 2 hours per day that affect to Db so as solutions I have created read replica for it. If application fetches large heavy data on read replica, is MasterDB affect with that havy load or…
MANISHDAN LANGA
  • 2,227
  • 6
  • 29
  • 43
0
votes
1 answer

Data missing from my new CloudSQL read replica following restore on the master

I just had a colleague blow away a table by accidentally running a unit test in an environment with a real database (which is a good opportunity to add a sanity check to that particular piece of code ;- ) No problem, I restored my database from…
jorfus
  • 2,804
  • 27
  • 23
0
votes
1 answer

Google Cloud SQL Read replica's in other regions within platform

I am looking to have a Cloud SQL MySQL instance have a read-replica in another region - within Cloud Sql. I'm aware I can create an 'external replica' but I'm unaware / unable to create an 'external replica that is Cloud Sql'. It would be very ugly…
Jonathan Beardall
  • 1
0
votes
1 answer

Sequelize connection for read replicas, how to connect to different ports?

I am trying to access MySQL databases from Sequelize. The MySQL setup is such that read nodes have different port compared to write. I could only find this from docs page. Sequelize read replica connection . What would a correct json connection file…
Perpetualcoder
  • 13,501
  • 9
  • 64
  • 99
-1
votes
1 answer

How to connect Postgres ReadRepica for Reads without affecting the application source code

I have an application which has read and write inline queries in the code, I am facing a challenge while pointing the read and write queries to respective Databases. Is there any best of doing it for Go application? My thought is to have two ORMs up…
Govardhan Pagidi
  • 1
  • 4
1 2 3
4