Brazil’s leading provider of messaging solutions, Group Ótima Digital, seamlessly integrates Readyset’s database scaling platform to scale their existing MySQL infrastructure with ZERO code changes
Based in Brazil, Grupo Ótima Digital is a leading provider of unified messaging solutions, specializing in communication management and automation for both the public and private sectors in the region. The company offers a range of services designed to enhance organizational communication strategies to deliver efficient and effective messaging solutions across a variety of channels including text and voice through an integrated platform.
The company offers a comprehensive suite of messaging solutions designed to enhance communication strategies for organizations through its GOChat, GOTalk and GOSolution platforms.
As operations continued to grow at Grupo Ótima Digital, the company was starting to face significant database performance challenges. The application architecture relied on powerful database servers with 72 vCPUs, but as query volume grew, few issues became apparent:
- High CPU and disk usage – A subset of queries were consuming the majority of the resources
- Scalability bottlenecks – Despite using a significantly large server, utilization regularly hovered around 80% and unpredictable spikes kept pushing it all the way during peak hours
- Performance degradation – Frequent slow queries impacted application responsiveness
When addressing the challenge of repetitive computations, it’s essential to implement a caching solution that stores query result sets rather than just raw data. This approach minimizes redundant processing and enhances application performance. Ótima Digital needed a scalable caching solution that could offload expensive queries without disrupting their existing system.
The team started by looking at Redis, a popular choice for database caching, but soon realized that integrating Redis for query result caching often necessitates substantial application modifications. Additionally, Redis primarily relies on Time-To-Live (TTL) settings for cache expiration, which can lead to challenges in maintaining data freshness. Applications that can only tolerate minimal stale data may find it difficult to manage appropriate TTL values, potentially resulting in either outdated information or excessive cache invalidations.
The Ótima Digital team also explored the ProxySQL Query Cache, which offers the advantage of not requiring extensive application rewrites. ProxySQL operates as an intermediary between the application and the database, caching query results to reduce direct database load. However, similar to Redis, ProxySQL’s caching mechanism is also based on TTL configurations. This means that cached data remains valid for the duration specified by the cache_ttl parameter, regardless of any underlying data changes. Therefore, while ProxySQL mitigates the need for application-level changes, it doesn’t fully address the challenges associated with TTL-based cache invalidation.
After evaluating several options, the Ótima Digital team decided to choose Readyset as their ultimate solution to address the database scalability challenge. With Readyset in place, Ótima Digital was able to cache 48 queries and successfully reduced their database load by over 30% in less than a week, significantly improving system performance and stability.
- Major reduction in server load with zero application rewrites.
- Seamless integration with MySQL and ProxySQL query router
- Intelligent caching of the most expensive queries, reducing repeated computations.
- Rapid support and iteration—Readyset’s team worked closely with Ótima Digital to help save even more by expanding the deployment very quickly from just 5 queries to 48
By choosing Readyset, Ótima Digital optimized its database performance while maintaining a scalable, low-maintenance architecture—ensuring they’re prepared for future growth.
“Integrating Readyset was seamless. Despite initial challenges due to our application’s high data ingestion volume, the Readyset team collaborated closely with us to identify bottlenecks. Within days, they were able to help us get up and running in production. Implementing Readyset’s automatic query cache integration, which analyzed our workload and cached the most resource-intensive queries, resulted in major reduction in server load.” - Henrique Müller, Senior Software Engineer, Grupo Ótima Digital
Here are some results from the production environment after Readyset was deployed.
Readyset in a normal day of operations, outbounding about 1Gb/s of caches, while still using less than 50% of CPU (4 vCPUs)
Readyset handles about ~4k qps during the same timeframe while using only 10GB of memory.
Readyset is a revolutionary database scaling platform and SQL query cache that helps optimize database queries, reduce server load, and eliminate scaling issues. All while cutting database costs by up to 70% and without additional code changes.
Interested in Readyset, please reach out to sales@readyset.io or Book a Demo!
