We’d like to use a more traditional RDBMS like MySQL or Postgres and Aurora appears to be the best serverless option.
I’ve created an Aurora DB and I’m able to connect to it with the Amazon Cloud9 IDE. However, when I try to connect to it using a Netlify Lambda function I get an error that the “cluster does not belong to the calling account id”. This makes sense. I think it will only allow connections from within the same VPC by default. However, it also seems like there should be a way around it since the Aurora Data API is HTTP based. Unfortunately I haven’t had any luck and I can’t find anything in the Amazon docs (which are somewhat overwhelming.)
Has anyone else done this? I’d really appreciate some pointers or even a definitive “no it’s not possible because X” so that I can just move on.
EDIT: I’m trying to use the Aurora “Serverless” option. It’s possible to make the other types publicly accessible.