PostgreSQL on Kubernetes on Azure Local
Databases can run well on Kubernetes when they are set up carefully. We run PostgreSQL in production on AKS on Azure Local with replicas and connection pooling.
Scope of the work
- Deploy PostgreSQL with an operator and multiple replicas
- Place databases on a dedicated node pool with suitable storage
- Add connection pooling
- Configure continuous backup and test point-in-time restore
- Plan version upgrades and failover tests
- A replicated PostgreSQL service on your cluster
- A measured restore and failover record
- A database operations runbook
Billed at $150.00 per hour. Ask Keith for an estimate.
What we check first.
Dedicated nodes
Databases share poorly. A node pool reserved for them keeps latency steady.
Pooling
Applications that open many connections exhaust PostgreSQL. A pooler in front fixes it.
Restore test
We restore to a point in time before calling the service ready.
Four steps, written down.
A call with Keith
You describe the goal, the estate and the deadline. Keith turns it into a written scope with an hour estimate at the hourly rate.
A written design by Gus
Gus reviews the environment and gives you a written design with each decision and its reason.
Hands-on implementation
Gus implements in your tenant and your racks, remotely or on site, with every change logged as it is made.
Documents and a named contact
You receive the as-built record and the runbooks. Keith stays on as your account and project manager.
Asked before every engagement.
Should databases run on Kubernetes at all?
For teams already running Kubernetes, yes, with an operator and good storage. For a single large database with no Kubernetes skills, a virtual machine can be the better choice.
Can you run SQL Server instead?
Yes, as virtual machines on Azure Local or through Arc-enabled data services where they fit. We discuss the options in scoping.
What does the consulting cost?
Consulting is billed at $150.00 per hour. Keith sends a written hour estimate after the scoping call, and work starts when you approve it.
Often scoped together.
One rate. Two people.
Consulting is billed at $150.00 per hour. Keith runs sales, project management and your account. Gus does the architecture, the design and the implementation.
per consulting hour, for every consulting service