Retail brands on Clientela's CRM stay connected to their customers at peak hours, without the database slowing down.
Clientela wanted the brands on its CRM to reach their customers at any hour, with integrations that stay fast and available as more brands join.
What stood in the way.
Clientela had completed more than 100 integrations with brands, and its database had to keep up during peak hours.
Slow queries, storage limits, a cap on concurrent connections and the risk of downtime threatened those integrations.
What we built.
- Provisioned IOPS and added throughput, so peak-hour and I/O-heavy workloads stay predictable.
- RDS storage auto scaling that adds capacity when usage crosses the threshold, using existing instances.
- Query analysis with RDS Performance Insights, and tuning of the slowest and most frequent queries to cut CPU and I/O waits.
- A higher maximum of concurrent MySQL connections, and end-to-end logging with encryption through AWS KMS.
- Amazon RDS
- MySQL
- RDS Performance Insights
- AWS KMS
- AWS CLI
What this work shows about us.
Throughput, scaling, query tuning and connection limits were each fixed where the load arrived.
The database stayed up through the work, which the client credits for winning more retail partners (as reported).
Want to re-engineer your CRM database on Amazon RDS 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 Clientela asked us now, this is what we would add, step by step.
An agent would answer a brand associate's question about a customer's history and preferences from the CRM, so they can suggest the right product. The associate still talks to the customer.
An agent would watch query times and connections during sales peaks and warn the team before customers feel a slowdown. Engineers still decide the fix.
Where this work fits.
- Brands & retailYour brand is meant to help every shopper find what they want and buy it, without wondering.
- Store & omnichannelShoppers find the item in any store or online, get help at the shelf to choose it, and know when what they bought will arrive.
- A Bahrain hyperlocal marketplaceShoppers in Bahrain get local orders delivered on time, by a driver assigned the moment they order.
- National NutritionNational Nutrition's shoppers find a store that stays up and keeps pace when demand rises.
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