Airflow-on-Fargate icon indicating copy to clipboard operation
Airflow-on-Fargate copied to clipboard

Why not choose Aurora Serverless instead of RDS?

Open readybuilderone opened this issue 3 years ago • 4 comments

It's cool to run the workload on Serverless Fargate, but why not use Aurora Serverless to replace the RDS? so the total solution would be serverless, is that a good idea?

readybuilderone avatar Aug 09 '21 06:08 readybuilderone

That's a valid point. We too considered adding Aurora Serverless as default offering. Aurora Serverless is useful when the traffic is low (dev/beta environments) or unpredictable. For continuous/steady/huge traffic, it will be costlier compared to RDS (reserved RDS will be much cheaper)

Metadata DB will have regular/continuous traffic in the form of heartbeat and other DAG/Task execution data. So, we went ahead in favor of RDS (a smaller, free-tier instance)

Being said that, it is easy to swap out RDS with Aurora Serverless. We have to replace this block of code with something like this Feel free to submit a PR, maybe a new branch, if you end up using Aurora Serverless instead of RDS.

thechaithanya avatar Aug 09 '21 18:08 thechaithanya

Thanks @thechaithanya for your suggestion. I am a solution architecture in AWS from China, since Managed Airflow hasn't been launched in China yet, the solution is extremely important, I'd like to submit a PR to replace RDS using Aurora Serverless, thanks again.

readybuilderone avatar Aug 12 '21 15:08 readybuilderone

@readybuilderone you should make it an option, to choose aurora or RDS, not eliminate RDS

cloneluke avatar Dec 06 '21 21:12 cloneluke

Yes, I will eventually tackle this as well but its lower down my priority list for this repo

cloneluke avatar Dec 10 '21 22:12 cloneluke