Client:
Our client is one of the start-ups operating in Africa who are into betting platform.
Challenge:
One of the modules of the betting platform is casino, which includes popular tournaments, jackpot, mega ways, drop and wins, crash, slot, live and table games. We are in partnership with various gaming platforms that provide interface and API structure to play those games. We have initially started with providers like 1×2 network, where there is single place bet request and against that there is single win request. Once this implementation is done, we later implemented various third-party casino interface providers, and we realized that there are different games which will have different place and settlement requests. Challenge was how we can accommodate the same with existing infrastructure.
Our Strategy:
We need to change the structure that we implemented earlier with a 1×2 network, we need to support multiple places against one single round of game play and multiple win requests against that round only. And we also need to take care of the performance of this. We have implemented structure in such a way that you can have all necessary information in the main master table that you can showcase to users in the bet history page as well as in our admin portal, and related child tables to store multiple place and settlement requests against that round of game.
Our Solution:
To generate comprehensive reports across various categories, we leverage a data warehouse database. This allows us to consolidate data from different sources and provide tailored insights on the admin portal. To optimize performance and facilitate analysis, we’ve implemented a background job that automatically transfers processed bets from the live table to a history table. This streamlined approach simplifies data retrieval and query execution.
During the implementation of these enhancements, we encountered several challenges, including timeouts and deadlocks. To address these issues and ensure scalability as we integrate with multiple providers, we’ve deployed multiple instances of our implementation in the production environment. This robust infrastructure enables us to handle increasing workloads and maintain high performance.
Business Outcome:
With these changes, after integrating multiple gaming casino providers, we are now processing millions of bets every day.
Tech Stack:
.NET, SQL Server, AWS Services like SNS, SQS, CloudWatch, Microservice based architecture, Vue JS, Nuxt JS.