How are services such as AWS Aurora or DigitalOcean’s Managed Postgres architected? Does anyone know of any whitepapers or blog posts about this topic? My intuition tells me the architecture is something like: 1) User signs up for the product, 2) A control plane level service launches a new instance of Postgres and configures it (on k8s, Nomad, whatever) 3) The database credentials are provided to user and the control plane handles replication/instances/etc. Would love any additional reading or resources anyone can provide.
👤 encima Accepted Answer ✓
If you want a demo for https://aiven.io, I would be happy to give a walkthrough (non sales related, purely technical)? Or, if there is enough interest, I could do a short video explanation and upload here.
👤 geoduck14
This is a REALLY deep question. Are you looking to build your own? Are you trying trying make sure a specific use case is secure/reliable/good?
You can, actually, build your own SQL processor on top of your own data (or arbitrary data store) - and the last company I worked for was starting to do this (but they were special!).