Proud of a long history and deepened its roots originated in the perfume industry and trade, where our launch was the first in Mecca in 1929 was the modest shop in front of the Haram al-Sharif for the sale of the oud, amber and provide distinctive blends of perfume. And soon it is circulating this trade and has evolved to be opening the first showrooms in Jeddah advertisers thus beginning an ambitious process of continuous and the pursuit of success. With persistence, determination, and a clear vision Telmust Ibrahim al-Qurashi group its way steadily to be one of the major perfume companies in the Kingdom of Saudi Arabia and the Gulf.
With persistence, determination, and a clear vision, Ibrahim Al-Qurashi Group steadily touched its way to be one of the largest perfume companies in the Kingdom of Saudi Arabia and the Gulf. During our long journey and our quest to consolidate our leadership in the local and regional market, we spared no effort or hesitate to meet The desires of our customers, which made us gain their satisfaction and gain their trust. We will continue to work constantly, with sincerity and dedication to improve the quality of our products and develop our industry to exceed the expectations of all our customers.
Speed and performance in e-commerce have a direct impact on business revenue.
Hence, these two factors should be essential metrics for all eCommerce merchants. From this perspective, the customer wanted to solve all the problems in his eCommerce website regarding reliability, performance, and latency. After deep investigations and discussions with the customer, the cause was eventually determined to be a Database Problem.
The customer was using MariaDB, and with business growth, this database engine became the main reason for low performance, frequent latency peak, replica lag, the need for many security patches, not to mention the increasing cost without any added value to the business.
With all previous problems and the tremendous effects on the business, the customer was even willing to increase the MariaDB to a considerable size of 12xlarge, which can’t be considered best practice. The customer had four databases, all running on the MariaDB engine with the same essential problems.
During the first month of our engagement, Bespin leveraged AWS well-architecture to assess Ibrahim Alqurashi’s environment. Based on five core pillars—reliability, security, performance efficiency, cost optimization, and operational excellence. Starting from this approach, Bespin identified several quick wins that can be achieved using AWS DMS service to migrate customer databases from MariaDB RDS to Aurora cluster.
Based on Bespin’s evaluation, Aurora RDS was the most efficient engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases.
The first AWS service used was AWS Data Migration Service (DMS) to migrate from MariaDB to Aurora MySQL RDS with almost zero downtime. Bespin 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.
The second AWS service used was Amazon Route 53 and its Domain Name System (DNS) web service. Local DNS Failover enables a variety of low-latency, fault-tolerant architectures. Using Amazon Route 53, we managed the customer’s end-users to be routed to the application’s endpoints and quickly switch the application database connection from MariaDB to Aurora MySQL. The newly created Aurora RDS were encrypted by AWS Key Management Service (KMS) to create and manage keys and control the use of encryption across AWS services to ensure security reliability and built-in auditing.
Also, we used AWS CloudWatch to monitor the RDS and application performance. CloudWatch provides many out-of-the-box dashboards to observe the health and usage of customer cloud deployments like CPU usage, disk read/write, Network in/out, etc.
RESULTS & BENEFITS
Stability, performance cost optimization.
Bespin stabilized and optimized Ibrahim Alqurashi environment by performing migration to the Aurora cluster and applying best practices on all clusters due to Aurora’s High Throughput with Low Jitter, Push-button Compute Scaling, and Storage Auto-scaling with its low-latency read replicas across three Availability Zones (AZs) which can be considered a major feature for customer business need.
In addition, Bespin has also applied all tunning and enhancement on the database level after migration. That included tunning and configuring parameters group on each database, reviewing all application’s queries, build required index, and analyze tables.
After all previous actions, the RDS load decreased, and performance was a boost. Due to these enhancements, we were able to reduce database size from 12xlarge to only a large extent, which saved a lot of cost for the customer with more reliable, stables, and efficient performance for both RDS and eCommerce websites.
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.