Organisations using a low-code data app keep working through traffic peaks and server maintenance.
The provider wanted its clients, from federal agencies to large companies, to rely on their data app at any hour, at a lower running cost.
What changed
What stood in the way.
- The low-code application faced problems with availability, replica synchronisation, rising costs and security gaps.
- Connections to the database were set up again and again, and servers struggled at peak hours.
- 30%lower RDS infrastructure cost (as reported)
What we built.
- Read-write replication on AWS Aurora MySQL, to serve heavy read traffic and scale without data loss.
- Storage auto scaling, and security checks with AWS Security Hub, GuardDuty and Config rules, with quick remediation.
- Cost tracking with AWS Cost Explorer to find idle and costly resources, and ProxySQL as a single endpoint with connection pooling, load balancing and automatic failover.
- Amazon RDS
- Aurora MySQL
- ProxySQL
- AWS Security Hub
- GuardDuty
- AWS Cost Explorer
What this work shows about us.
Replicas, auto scaling and failover keep the app up, while cost tracking removes idle spend.
Non-compliant or unencrypted resources are found and fixed as they appear.
Want to modernise the database behind your app like this? Tell us what you want to change. Our AI assistant, Ask Unthinkable, helps you define your requirements, then connects you with the right team.
Start your plan ↗If we built it today, with AI.
This work came before today's AI. If the US grants management software provider asked us now, this is what we would add, step by step.
An agent would watch load, replicas and costs, explain an unusual spike in plain words and propose a fix. Engineers still decide what changes.
An agent would group security alerts, draft the fix for each and open it for review.
Where this work fits.
Facts and figures from the project records; nothing added.
Want this for your business?
Tell us what you run or what you're building. Our AI assistant, Ask Unthinkable, helps you define your requirements, then connects you with a senior AI engineer.
Send us a note instead
An AI agent. This prototype uses prepared answers and sends nothing.
We use essential cookies to run this site. With your consent we also use analytics cookies to see which pages help. Privacy policy