This interactive marketing and advertising agency helps clients grow with modern, data-centric services. Specializing in email marketing, they recently embarked on a journey to upgrade their database infrastructure to handle transactional batch data more efficiently.
The agency caters to its clients, including major American retailers, by sending personalized emails. To do so, they needed a robust system capable of managing and analyzing large amounts of data.
They combine data-driven analytics with market trend insights to provide impactful marketing solutions. Their core services include:
The firm faced challenges with MySQL’s table-level locking, lack of traceability, and the complexity of managing multiple servers. They also encountered issues achieving optimal query performance with the MySQL setup, particularly for large table export and import.
The issues with MySQL that required resolution included:
These four issues led the agency to migrate its existing MySQL setup to YugabyteDB Managed. The following architecture outlines the campaign data flow from MySQL to YugabyteDB Managed.
The agency’s adoption of YugabyteDB Managed for scaling its email marketing solution highlights their strategic approach to database management, especially when addressing large (and growing) dynamic workloads and efficient system performance. They used horizontal and vertical scaling to achieve optimal performance and scalability to meet application needs and business objectives.
Here’s how they utilized YugabyteDB Managed’s scalability features:
The agency took advantage of YugabyteDB Managed’s capability to scale horizontally (or out). They were able to add more nodes to the database cluster to handle increased load and data. This method is particularly beneficial for handling:
Key Features of Horizontal Scaling in YugabyteDB
Advantages of Horizontal Scaling
The agency also capitalized on the ability to vertically scale (or scale up) easily to upgrade existing node hardware. This involved upgrading the CPU, memory, storage, etc.. This simplified operations by keeping the number of nodes the same.
The marketing agency selected YugabyteDB Managed over MySQL Heatwave, CockroachDB, and Oracle Cloud for its email marketing platform. They needed a scalable database capable of handling transactional batch data for large-scale email campaigns, and YugabyteDB Managed fulfilled and surpassed their requirements.
The main drivers for choosing YugabyteDB Managed included advanced monitoring capabilities to support their small DBA team, efficient data handling features like packed rows and incremental loading, and superior query performance with features like GIN indexing, sharding, and parallel queries. These capabilities, coupled with the challenges they faced with MySQL’s table-level locking, lack of traceability, and complex management, prompted their shift to YugabyteDB Managed.
Learn more about YugabyteDB Managed and the features that this interactive digital marketing agency is leveraging through the following resources:
Leave a Reply