The OTT sports broadcasting platform's legacy code could not cope with the sudden surge in traffic and DDoS attacks. And its database became the platform's bottleneck, consuming all of the available Microsoft Azure resources. Even though the platform’s original developers had implemented advanced database replication techniques from the onset, it was practically impossible to scale the solution — either vertically by adding more computing resources or horizontally by adding more servers.
To optimize the OTT platform's performance, we did the following:
●
Erased excessive information from the database and enabled data caching. The platform's database contained a lot of irrelevant data. For instance, in one of the tables, there were a whopping 20 million inaccurate or unnecessary entries, while another included seven million such entries. By removing this information, the ITRex significantly reduced the pressure on the system. And more improvements came with data caching. We started with re-configuring Varnish, a web accelerator for content-heavy dynamic websites, so that the system could use its computing resources effectively when receiving similar requests from multiple users. We also set up a load balancer to distribute requests correctly between server instances. When doing so, the ITRex team calculated the optimum ratio of proxy servers to API instances that handle back-end requests. This helped reduce the number of instances simultaneously retrieving information from the database, further minimizing the workload on the system.
●
Implemented sufficient DDoS attack protection. The older version of the OTT platform lacked a modern content delivery network (CDN) with advanced DDoS attack protection mechanisms. We solved the problem by writing custom configuration scripts for the Nginx server, creating black and white lists for servers and user IP addresses, and introducing time-bound limits on API requests. At the moment of writing this case study, the ITRex team has already swapped Nginx and proxy cache for Microsoft solutions, including Azure Front Door, a modern cloud-based content delivery network. Even though the implementation process is still in full swing, we’ve already achieved sufficient protection against DDoS attacks alongside new OTT platform performance milestones
We're currently working with the Microsoft team to implement new services — for instance, Azure Front Door, a modern cloud-based content delivery network — to achieve new performance milestones. Subsequently, we've changed the configuration of application gateways and integrations with third-party services, such as sports news aggregators.