![brand-elements](/themes/custom/bootstrap_xoriant/images/dot-4.png)
![brand-elements](/cdn/ff/JF2WQxBCkxFbRg6a_prZFv8MaZ1oY8UhqyG_Ms085KY/1692875438/public/styles/webp/public/2023-08/Group%201410075574_1.png.webp?itok=JO9oZE8H)
Xoriant Database Migration Case Study
Smooth migration from commercial to Open source platform with minimal downtime of client's existing IT Infrastructure system which resulted in 97% TCO savings along with improved product performance to 27 TPS from 7 TPS, thus ensuring high usability and manageability.
Key Requirement
- Determining the optimal infrastructure configuration to enable smooth migration was one of the bigger challenges.
- Ensuring minimal downtime during the migration since the database to be migrated was OLTP with high throughput, many users, and constant load of DML operations and queries
- Ensuring high usability and manageability offered by the Oracle database. Know More >>
Key Contribution
- We conducted an in-depth infrastructure analysis of number of database users, type of database workload, etc to determine number and type of servers and CPUs needed and utilization rate of each server
- We used InnoDB storage engine of MySQL that is a transaction-safe, ACID (atomicity, consistency, isolation, durability) compliant and best suited for OLTP
- MySQL Migration toolkit was used for migrating simple tables and views and the data. Know More >>
Benefits
- The TCO savings of the client was about 97% of the original cost.
- Migrating to Open source improved product performance to 27 TPS from 7 TPS. Know More >>