Red3i provides business intelligence by acquiring, analyzing, and processing media data better to help clients improve customer acquisition through multichannel marketing campaigns, online and offline. Helping clients understand the digital marketing landscape and the performance of their marketing campaigns requires using quality data for real-time intelligence, historical trend analysis, detailed segmentation, and predictive modeling.
The marketing agency was using AWS Aurora for a mission-critical processing platform for 6 TB of ever-growing data. However, the company discovered that running analytics queries to gauge marketing campaign performance took too much time and effort because data had to be transferred to a separate relational database. Expenses and complexity were rising for the company, along with demand for data and insights from clients to increase return on advertising investments.
We successfully migrated our 6 TB database and in-house digital marketing and media management applications from AWS Aurora to MySQL HeatWave, which reduced our costs by 60% and improved performance for complex queries by more than 1,000X and 85% of overall workloads. In addition, we didn't have to make any changes to our application. Automatic recovery has minimized downtime, and we can now scale to thousands of cores because we have an ever-growing need.
Cofounder and CTO, Red3i
After evaluating Google BigQuery, Snowflake, and AWS Redshift, red3i migrated from AWS Aurora to MySQL HeatWave on Oracle Cloud Infrastructure (OCI) to significantly accelerate analytical queries, reduce costs, and improve ease of use. MySQL HeatWave easily enables red3i staff to run OLTP and OLAP workloads directly from the MySQL database in-memory, eliminating the need for data movement and integration with a separate analytics database.
Using MySQL HeatWave increased complex queries for red3i by as much as 1,000X for real-time analytics and by 85% for overall workloads without changing code to its applications. IT costs dropped by 60% by eliminating multiple middleware tools and analytical platforms. Automatic recovery minimized downtime for high availability.
Scalability from MySQL HeatWave enables red3i to scale its ever-growing 6 TB database from its cluster of 12 nodes to thousands of cores at constant costs and administration.
We work tirelessly to over-deliver on our clients' expectations. With strong support from Oracle, MySQL HeatWave can continue to help clients make better decisions and optimize their media and advertising investments.
Cofounder and CTO, Red3i