By leveraging the power of AWS Cloud, Apvertise has successfully transformed its platform, empowering brands and influencers with increased visibility, global reach, and unparalleled growth opportunities.

‍

By leveraging the power of AWS Cloud, Apvertise has successfully transformed its platform, empowering brands and influencers with increased visibility, global reach, and unparalleled growth opportunities.

‍

By leveraging the power of AWS Cloud, Apvertise has successfully transformed its platform, empowering brands and influencers with increased visibility, global reach, and unparalleled growth opportunities.

‍

Before the migration, Apvertise faced several challenges that necessitated change. Multiple Microsoft SQL-based software products were being developed internally, each crucial to the business. However, limited resources and competing priorities hindered progress. Additionally, Apvertise aimed to reduce its cost footprint, improve application performance, and enable new feature developments in the cloud. These objectives were essential for long-term success, but the internal team lacked the bandwidth to address them effectively.

To address these challenges and implement the online mall feature, we provided a comprehensive solution. Through a Migration Readiness and Planning (MRP) process, we assessed the existing applications and databases, identifying potential roadblocks and migration options. One significant challenge arose with their reliance on database triggers for data auditing, which required a custom solution. We proposed a direct Microsoft SQL to Amazon Aurora MySQL , minimizing application codebase changes and ensuring data compliance.

To ensure a smooth migration and the implementation of the online mall feature, we developed a migration plan, refactoring plan, and quality assurance plan, prioritizing minimal downtime for the applications. The online mall feature required the integration of e-commerce functionality, including product catalogs, shopping carts, and secure payment processing. Qucoon everaged AWS services such as Amazon EC2, Amazon S3, and AWS Lambda to design a scalable and secure online mall infrastructure.

We implemented several AWS services to enhance Apvertise's infrastructure and functionality. By utilizing AWS Lambda for serverless computing, we reduced costs and improved scalability. Amazon EC2 provided resizable compute capacity and hosted the website and database. EC2 Auto Scaling ensured optimal performance during peak usage. Elastic Load Balancer evenly distributed traffic, while Amazon SNS handled notifications for influencers, vendors, and app users. Lastly, Amazon S3 stored and retrieved assets for the online mall feature. These implementations optimized costs, scalability, performance, and user experience.

‍

Testing was critical to guarantee availability, performance, and quality. we proposed a decoupling of application logic from database queries and developed a separate testing application. This allowed for performance baselining, extensibility, and provided a benchmark for comparison between Microsoft SQL and Amazon Aurora MySQL .

The successful execution of the migration and modernization project, along with the implementation of the online mall feature, delivered numerous benefits to Apvertise:

• Increased migration observability, enabling the engineering team to identify shortcomings early on
• Ability to perform production migrations with minimal risk
• Extensible and scalable performance testing suite for validating application performance
• Seamless integration of the online mall feature, providing a robust e-commerce platform for users
• RDS instances with sizing recommendations aligned with growth projections and cost-effectiveness goals

Qucoon played a pivotal role in guiding Apvertise through the migration journey, not only in carrying out the actual migration and modernization work but also in recommending the right combination of cloud technologies. With a revamped infrastructure, enhanced capabilities, and the implementation of the online mall feature, Apvertise is well-positioned to develop new features, ensure data security, drive innovation, and generate higher revenue through its influencer marketing platform.

‍

‍