unthinkable
Case study · Clientela, New York, US · e-commerce CRM and clienteling provider

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.

New York, United StatesStore & omnichannel

What stood in the way

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

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 it shows

What this work shows about us.

Data that keeps up with the business

Throughput, scaling, query tuning and connection limits were each fixed where the load arrived.

Done without stopping

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

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.

Finding it

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.

Where is my order

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.

Ask Unthinkable

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

Required

Thanks. A senior AI engineer will reply to you.
u
Ask UnthinkableClarity first, then the right team
Your conversation

An AI agent. This prototype uses prepared answers and sends nothing.