We are using an Aurora AWS Serverless MySQL Cluster.
These serverless clusters cannot be exposed outside of their VPC.
So the options are running self-hosted inside the VPC, or setup an SSH tunnel.
There is a 3rd option here, as this DB is exposed to the outside world - thorough the “AWS RDS Data API”
The configuration to connect to this will require AWS Access Key (like Dynamo), Cluster ARN, Secret ARN (for the mysql user+password), and database name.
So it looks pretty simple and I’m willing to open a PR for it.
Just wondering if there are any thoughts / gotchas / tips / tricks I should be aware of.
Sorry but I don’t think I’ll be able to do that.
I’m barley finding the time to complete this PR.
But I think it will be easier to do after this PR is completed, as this PR takes some things from the MySql source, which will just need to be replaced with code from the PostgreSQL source.
Hey I’ve opened a pull request for this - https://github.com/getredash/redash/pull/5082
I would love some feedback and of course would implement any additional functionality required by the project maintainers.