I think the answer to this right now is either:
- DynamoDB
- Aurora
In my case I am going to go with Aurora as I am deploying Django applications with Lambda
Dynomodb for nosql managed dB, or Aurora with read replicas and multi - AZ for high availability.