You will get PostgreSQL HA Cluster with Patroni, etcd, HAProxy and Keepalived
Project details
Get a production-ready PostgreSQL 16 HA cluster on Rocky Linux 9 with automatic failover, load balancing, and VIP management.
Deliverables:
• 3-node Patroni cluster (Patroni, etcd, PostgreSQL).
• HAProxy with dynamic routing (writes to leader, reads to replicas).
• Keepalived for VIP failover.
• Testing: Failover simulation, connectivity from backends.
• Documentation: Configs, troubleshooting guide.
Ideal for: E-commerce, finance apps needing 99.99% uptime.
Deliverables:
• 3-node Patroni cluster (Patroni, etcd, PostgreSQL).
• HAProxy with dynamic routing (writes to leader, reads to replicas).
• Keepalived for VIP failover.
• Testing: Failover simulation, connectivity from backends.
• Documentation: Configs, troubleshooting guide.
Ideal for: E-commerce, finance apps needing 99.99% uptime.
Database Type
PostgreSQLWhat's included
| Service Tiers |
Starter
$150
|
Standard
$250
|
Advanced
$400
|
|---|---|---|---|
| Delivery Time | 3 days | 5 days | 7 days |
Number of Revisions | 1 | 2 | 3 |
Schema Diagram | - | - | - |
Permissions Setup | - | - | - |
Import/Export Data | - | - | - |
Admin Panel Setup | - | - | - |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$50 - $150
Additional Revision
+$50
2 reviews
(2)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
RE
Robert E.
Nov 2, 2025
DevOps Engineer for Community Platform Development
Hi Sherif, Thank you for your work and helping out :-)
MT
Mark T.
Jul 25, 2023
You will get MySQL Server Replication, Group Replication or InnoDB Cluster.
Sherif is excellent. Great communication. Was available quickly. Helped us quickly resolve our problem.
About SHERIF
PostgreSQL & MySQL Expert | Query Optimization | Replication | AWS RDS
100%
Job Success
Al Mansurah, Egypt - 12:46 pm local time
Your database is the one part of your stack that can't afford a bad day. I make sure it never has one.
I'm a MySQL and PostgreSQL Database Administrator with 10 years of experience keeping production databases fast, secure, and available for SaaS companies, e-commerce stores and startups.
Whether you need a one-time performance rescue or a long-term DBA on retainer, I handle the database so your team can focus on shipping features.
What I can do for you:
⚡ Performance tuning — Slow queries diagnosed and fixed, indexes designed properly, configuration tuned to your actual workload. I've taken queries from [e.g., 40 seconds down to 200ms — use a real number from your experience].
🛡️ Backups & disaster recovery — Automated backup strategies that are actually tested. A backup you've never restored is just a hope. I set up point-in-time recovery so a bad deploy or an accidental DELETE never becomes a company-ending event.
🔁 Replication & high availability — Primary/replica setups, failover automation, connection pooling. MySQL (InnoDB Cluster, Group Replication) and PostgreSQL (streaming replication, Patroni, pgBouncer).
☁️ Cloud & migrations — AWS RDS/Aurora, Google Cloud SQL, DigitalOcean. Zero-downtime (or near-zero) migrations between servers, versions, or engines.
📊 Monitoring — Proactive alerting with [Prometheus/Grafana, PMM, pganalyze — your actual tools], so problems get fixed before your users ever notice them.
🔐 Security — Privilege audits, encryption at rest and in transit, hardening against common misconfigurations.
How I work:
Clear communication in plain English — I explain why, not just what
Every change documented; no mystery fixes you can't maintain later
Responsive for urgent production issues [state real availability, typically within 2 hours
Every engagement starts with a free mini health-check of your database, so you know exactly where you stand
A good fit if you need:
✅ A one-time performance audit or emergency rescue
✅ Ongoing monthly maintenance (monitoring, backups, updates, tuning)
✅ A migration or upgrade done safely
✅ A part-time DBA without the cost of a full-time hire
Send me a short message with your setup (engine, version, hosting, main pain point) and I'll reply with an honest assessment — or tell you straight if I'm not the right fit.
Steps for completing your project
After purchasing the project, send requirements so SHERIF can start the project.
Delivery time starts when SHERIF receives requirements from you.
SHERIF works on your project following the steps below.
Revisions may occur after the delivery date.
Starting the project
In this step we will have a meeting to discuss requirements, deliverables and testing phase
Receiving Full Access to the servers
I nthis step the client will eliver the access credentials to the servers, and I will test them all on the servers and give confirmation that I have access ot he servers and can start working.