Migrating from Postgres RDS to Aurora without changing endpoint

David

1/15/23, 11:32 AM

I have around 40 micro services that connect to my Postgres RDS database. Now I am considering migrating to Amazon Aurora. Each of the connections connect to the RDS endpoint and modifying that across 40 micro services will mean that there will be quite significant downtime, coordination and stress. I am assuming that there would be a smarter way to do this, where I can somehow keep the endpoint and just redirect it from RDS to Aurora. I have looked into Amazon RDS Proxy, and it would be great to change all the micro services to use that as an endpoint, but it seems like I am adding a lot of complexity for this small purpose.

Researching this did not get me far, which makes me believe that I am missing something obvious, but I don't understand what it is.

0 + 0

postgresql

amazon-web-services

amazon-rds

Tim

1/15/23, 6:13 PM

I can't help with RDS proxy but you could read the docs / try it out. I will share one observation that may be interesting though. If I create an RDS Oracle database, delete the DB, and create another Oracle RDS DB the database URL for the second is the same as the first. Of course if I don't delete the first database the second DB URL is different. I wonder if in a new account you could create a PostgresDB, delete it, then create Aurora and see if the endpoint is the same. I doubt it will work, but it shouldn't take long to try.

Tim

1/15/23, 6:19 PM

The docs for RDS Proxy say it's for one database. I suspect you're going to have to change your microservice configurations. Using RDS Proxy might help availability in future, but I suspect it won't help the migration.

David

1/15/23, 9:33 PM

@Tim The endpoint for Aurora seem to be different than RDS, and they actually contain "aurora" hardcoded into them, it seems. Like [my_instance_name]-cluster.cluster-cbktrbeczmex.eu-central-1.rds.amazonaws.com So it does not seem like I could rename it to the endpoint as I used on RDS

Tim

1/15/23, 10:54 PM

That's annoying, but I think you may just have to accept that you need to change the URL unfortunately. Migration is an exercise.

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Migrating from Postgres RDS to Aurora without changing endpoint

TH: การโอนย้ายจาก Postgres RDS ไปยัง Aurora โดยไม่เปลี่ยนปลายทาง

RO: Migrarea de la Postgres RDS la Aurora fără a schimba punctul final

RU: Миграция с Postgres RDS на Aurora без изменения конечной точки

VI: Di chuyển từ Postgres RDS sang Aurora mà không thay đổi điểm cuối

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.