Xoriant Database Migration Case Study

Xoriant Marketing

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 >>