2
votes
0answers
39 views

Is there a way to replicate Postgres databases in Amazon RDS between regions?

We have a Postgres RDS instance in the AWS Oregon Region. For some supposed legal reasons, we have to host our client's European data in the Ireland AWS Region, but we need that data synchronized to ...
0
votes
2answers
34 views

Mysql replication with c

I have huge database on MySql and It's become more and more huge. So, Now I am facing performance issues with my database. Some of tables has millions of records in it. like my login detail table ...
2
votes
1answer
268 views

Replication from EC2 Master to RDS Slave - Connecting to master

I am migrating my company's database from an EC2 instance to an RDS instance. I have already migrated a snapshot of data and am now trying to set up replication to get the data that has been added ...
0
votes
1answer
96 views

Is it possible to recover from a LOST_EVENTS incident from an RDS read replica?

I was setting up a read replica of an RDS database for a reporting project, and issued an incorrect GRANT statement when configuring a user. My RDS read replica stopped, with an error message on the ...
0
votes
1answer
130 views

Looking for suggestions to Migrate Amazon RDS Large Instance to non-amazon host - Live

We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated without having to take our website down or minimize downtime to less than a couple of hours. And I am ...
5
votes
1answer
841 views

Best strategies to have a backup of an RDS MySQL database

I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited. I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup. I know ...
5
votes
1answer
145 views

How to schedule PostgreSQL replication?

I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has arrisen. I'll be using postgres internal replication solution but as far as I ...