With a joint effort, RX Marketing Group and Redwerk managed to complete the project without delays.
We created an ultra-fast redirect service that can be integrated into a company’s mailing platform. That is, every person from the company’s mailing list can receive a message that contains a unique, automatically generated hyperlink. When the receiver follows the link, the app collects all the available information, such as the device OS, browser version, IP address, and then generates the fingerprint based on this data. After that, this fingerprint is tracked every time the user visits one of the conglomerate websites. The data gathered through the device fingerprint is then matched with the user’s email address or phone number to create a comprehensive customer avatar. All these operations are undetectable to the user, including the creation of reserved copies for the backup database.
To find the most appropriate solution, we used two databases and conducted load testing. In the end, we developed a Redis data storage system with the data backup in MySQL, which allowed us to reach high responsiveness and stability of the app. MySQL is also suitable for long-term data storage as it enables keeping statistics for several days, months, and even years.
We also implemented replication in MySQL, which allowed us to significantly decrease the load on the system.
As a result, we created several modules for the large data system: pixel tracker, service of redirects, service of gathering the statistics. The architecture of the application was perfectly structured: each part of the app is a separate and independent microservice.