amplify-flutter icon indicating copy to clipboard operation
amplify-flutter copied to clipboard
verified publisher icon aws-amplify

S3 to RDS mySql

Open Intelbis opened this issue 3 years ago • 1 comments

Description

Hi Im developing an app using amplify studio which is super usefull. But it has dynamoredb by default which is a noSequal database. Im developing an app with a relational database. How to get my data from the amplify content to aws rds?

Categories

  • [ ] Analytics
  • [ ] API (REST)
  • [X] API (GraphQL)
  • [ ] Auth
  • [X] Authenticator
  • [X] DataStore
  • [X] Storage

Steps to Reproduce

e

Screenshots

No response

Platforms

  • [ ] iOS
  • [X] Android
  • [ ] Web
  • [ ] macOS
  • [ ] Windows
  • [ ] Linux

Android Device/Emulator API Level

API 22, API 32+

Environment

e

Dependencies

e

Device

Pixel 5

OS

15.1

Deployment Method

Amplify CLI

CLI Version

9.1.0

Additional Context

dee

Amplify Config

dee

Intelbis avatar Sep 25 '22 10:09 Intelbis

Hello @Intelbis - This isn't something that is currently supported. However, there is an open Request for Comment (RFC) which proposes adding support for this. You can read about it here: https://github.com/aws-amplify/amplify-category-api/issues/815

Jordan-Nelson avatar Sep 25 '22 12:09 Jordan-Nelson

@Intelbis - I see you included S3 in the issue title. Can you clarify how you would like to use S3?

Jordan-Nelson avatar Sep 26 '22 14:09 Jordan-Nelson

Hey Jordan I have data objects stored in S3 and its currently saving to DynamoreDB. Can export the existing S3 from my environment to an aurora mysql serverless cluster? Im from Melbourne but my rds region is us-east-1

@Intelbis - I see you included S3 in the issue title. Can you clarify how you would like to use S3?

Intelbis avatar Sep 28 '22 11:09 Intelbis

Hi @Intelbis I don't work Aurora MySQL so not sure, however have you tried contacting the Amazon Aurora team here?

https://aws.amazon.com/contact-us/sales-support-rds/

fjnoyp avatar Oct 01 '22 16:10 fjnoyp

Can export the existing S3 from my environment to an aurora mysql serverless cluster?

@Intelbis - Please see the Amazon Aurora docs on migrating to Aurora. I believe in this case you would want to use AWS Database Migration Service.

Note that support for using Amplify GraphQL API with existing Relational Databases has been proposed, but not implemented. See the RFC linked above for more info.

Let us know if you have any other questions.

Jordan-Nelson avatar Nov 08 '22 17:11 Jordan-Nelson

@Intelbis - I am going to close this out since we have not heard back. I encourage you to look at the Aurora docs linked above as well as the RFC.

Jordan-Nelson avatar Nov 14 '22 16:11 Jordan-Nelson