MINFY

Database Modernization for Leading Indian Tech Company

  1. Home
  2. >
  3. Case Study
  4. >
  5. Database Modernization for Leading...

September 01, 2023 | Resonances Type: CaseStudy

Objectives

Cyient & Minfy's collaboration to migrate end-customer's (leading mobile network company) databases on Oracle Commercial Database Engine to OpenSource PostgreSQL for cost-effective scalability & cost management.

• Transform Cyient's Oracle Database to Aurora PostgreSQL for cost savings and reduction of management overheads.
• Reduce heavy Oracle licensing costs.
• Achieve Oracle-grade scale, performance, and HADR with open-source alternatives.
• Based on the success of the aforementioned, they planned to move their other applications using Oracle, to Aurora PostgreSQL

Solution Highlights

Minfy migrated Cyient's database to AWS cloud from a commercial database engine. This resulted in improved database
performance, reduced licensing costs as well as improved scalability and flexibility.

Minimised Cost

Improved Performance

Scalability

Key Benefits

Migrating from a commercial database

Migrating from a commercial database engine to Opensource PostgreSQL resulted in reduced licensing costs - licensing freedom.

Improved scalability & flexibility

Improved scalability & flexibility in workload management. This has an impact on cost and reduces likelihood of overprovisioning.

Right-sizing

 

Right-sizing of the database resulted in improved database performance & efficiency.

 

Customer Background

Cyient is a leading Indian multinational technology company specializing in engineering, manufacturing, data analytics, and networks and operations. With over 15,000 associates in 19 countries, they provide services and solutions to a diverse customer base of over 300 clients, including 29 Fortune 500 companies. Cyient's approach combines global delivery with local relationships, innovation, and digital expertise.

Challenges

Business Challenge:

• Overprovisioning of Licenses and costs associated with it.

• Freedom from Licensing and Vendor Lock-in Challenges.

Specific Technical Challenges:

• The end-customer had access restrictions for DMS GUI usage by Cyient & Minfy on AWS console and AWS CLI was used to solve this issue

• Converting complex Oracle SQL code objects to PostgreSQL for COTS app required significant engineering effort.

• Achieving HADR, DR, Scale-up/out with Oracle posed cost & management challenges which we resolved as a part of our solution

Technical Solutions

Features of the Solution:

•  Used AWS SCT and AWS CLI with DMS for migration to AWS Aurora PostgreSQL

•  Customized Ora2PG integration for SQL code object conversion

•  Code conversion for schema and SQL/DB objects with open-source accelerators.

•  Factored RDS Multi-AZ and Read Replicas for HADR & read scaling

•  Open-source customizations for BLOB/CLOB tables and CDC using DMS.

•  Designed and executed open-source PostgreSQL APMs for performance insights

•  Provided SQL query optimization recommendations with Aurora PostgreSQL APM reports

About Minfy

Minfy Technologies is a Cloud Native System Integrator helping enterprises, start-ups and fast-growing businesses navigate digital journeys leveraging AI & Cloud technologies. We assist our customers in accelerating Digital Transformation, Cloud Adoption and Innovation. Our transformative services include Cloud Consulting, Migration & Legacy Modernisations, Cloud-Native Application Development and DeepTech implementations while offering reliable and world class 24x7 managed services.

Reach out to us for a better world

Minfy has a repository of learnings, competencies and an enviable track record of meeting customer needs. Advice and service, solutions and responsiveness work in tandem. Begin your cloud journey, accelerate it or optimise your cloud assets. Experience business impact.

About

CONSULTING

INDUSTRIES

MINFY LABS

RESONANCES

CAREERS

MINFY SERVICES

SOCIAL

CONTACT

sales@minfytech.com

APAC

+91 86888 18765
sales@minfytech.com

USA

+91 86888 18765
sales@minfytech.com

AWS

© 2022 Minfy™. Minfy Technologies. All rights reserved. | Privacy Policy | Terms and Conditions

This website stores cookie on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media. To find out more about the cookies we use, see our Privacy Policy. If you decline, your information won’t be tracked when you visit this website. A single cookie will be used in your browser to remember your preference not to be tracked.