A Dubai-based company focused on delivering unique and engaging digital experiences, DMN Global reaches over one billion mobile users across emerging and high growth markets in the Middle East, Africa, and Asia. It is next-gen, cloud-native, and API-first unified subscription management platform, DMN Connect, allows telcos, service providers, and other enterprises to develop enhanced, user-centric products and digital content experiences. Partnering with major telco groups and companies, DMN Global launched Kiosk, the first publishers’ hub in MENA to offer a wide range of digital publications to mobile users. Incorporating curated articles and full-issue premium magazines from top local and international publishing houses, subscription-based Kiosk delivers on-the-go access to unlimited content. Following the successful commercial launch of Kiosk in late 2018, DMN introduced Kiosk Madame—a bespoke, white-label version of Kiosk for du customers—in 2019, and, most recently, MTN Kiosk, built exclusively for the MTN Group operating in MEA.
The customer application was built on top of Microsoft SQL Server engine. Due to the continues business growth immerged the need to migrate the data to more cost-effective (licensing overhead), scalable and reliable solution. Another key requirement was ability to split read\write requests between Active & read-replica instances.
The core challenge was in the Microsoft SQL Server license used (standard edition) as it didn’t support provisioning of read replicas. Another important requirement was minimum downtime & migration cost bubble during the migration.
While discussing the solution, another added value was identified in which several optimization actions will take place during the migration (renaming tables & columns, optimizing indexes & table constraints).
Based on AWS recommendation, the company contacted Bespin, an AWS Premier Consulting and Managed Service Partner. the Bespin team worked with the customer to gather requirements, rearchitect, deploy, and test the entire solution, and manage the project.
The proposed solution was to migrate the database using AWS Data Migration Service (DMS) to initially load the data from MSSQL to two MySQL RDS with replicating the ongoing changes. This was managed by applying all remapping actions during the migration process by using separated tasks for each set of mapping actions.
Bespin used AWS Schema Conversion Tool (AWS SCT) that provides a project-based user interface to automatically convert customer’s existing database schema from one database engine to another. by using SCT for each database in the source MSSQL RDS
Bespin was able to provide the customer with the database migration assessment report which included the executive summary and a list of the recommended conversion actions the variated between simple to medium complexity to complex conversion actions.
DMN Global was responsible for applying the needed conversion actions in the target database with the support of Bespin.
Bespin used Native AWS Services as a part of the solution like Relational Database Service. (RDS), AWS Data Migration Service (DMS), AWS Schema Conversion Tool (SCT), Key Management Service (KMS), CloudWatch, and Route53.
First, Bespin used the DMS service to migrate from the Microsoft SQL server database to multiple MySQL RDS with continuous replication for ongoing changes.
Bespin also considered AWS Best practice to connect the source and target databases to an AWS DMS replication instance by configuring a network and connecting two AWS resources in the same virtual private cloud (VPC) as the replication instance.
Second, using AWS Schema Conversion Tool (SCT) to convert MSSQL’s existing database schema to another engine of MySQL.
Another AWS service used is Amazon Route53and its Domain Name System (DNS) web service. Local DNS Failover enables a variety of low-latency, fault-tolerant architectures with minimal downtime during the migration as per customer request.
With Amazon Route53, we managed the application’s endpoints routing to switch the application database connection from MSSQL to MySQL quickly.
In addition, the two MySQL RDS are encrypted by AWS Key Management Service (KMS) to create and manage keys to ensure security reliability. Finally, we used AWS CloudWatch to monitor the RDS and application performance.
RESULTS & BENEFITS
The primary key enhancement was providing replicas for the customer who was inapplicable due to the customer’s MSSQL standard license.
Bespin stabilized and optimized DMN Global environment by migrating and separating the workload into two MySQL RDS.
Bespin provided the best practice on customer structure by tunning and enhancing actions on databases level, including the configuration of parameter group, reviewing all application’s queries, the building required to index, and analyzing tables.
These previous actions ensured the decrease of databases load and saved a lot of cost for the customer with more reliable, stables, and efficient performance for both RDS.
“Once we implemented the new architecture,” states Ibrahim enthusiastically,” our costs dropped 50% overnight compared to the previous deployment. And the intangible benefits in terms of increased availability and reliability were terrific. We’re offering an over-the-top (OTT) consumer product. The new AWS architecture gives us the 24×7 availability our consumers demand.”
About Bespin Global:
An AWS Premier Consulting Partner and AWS Managed Service Partner, BESPIN GLOBAL MEA (Middle East and Africa) is a leading provider of automated cloud solutions and consulting services including cloud strategy, migration, implementation, DevOps, and Big Data. Positioned as a Leader in Gartner’s 2020 Magic Quadrant for Public Cloud Infrastructure Professional and Managed Services, Bespin offers the industry’s most automated, end-to-end cloud management platform. Bespin OpsNow enables customers to consolidate, visualize, and manage distributed, multi-cloud assets within a single solution, optimizing resources and reducing cost by 30% or more.