India’s top payment solutions company moves to PostgreSQL leveraging Ashnik’s database expertise & services
The Customer:
One of India’s leading online payment gateway provider offering integrated payment solutions to both small and large businesses.
The Challenge:
The customer wanted to migrate to PostgreSQL from Oracle and wanted to work with a reliable open source partner with relevant industry experience.
The Solution:
Ashnik’s Database experts studied the requirements and specifications of the architecture and helped the customer successfully build the required environment.
The Benefits:
Upon implementation of PostgreSQL, the customer achieved higher availability, cost efficiency, and an upgraded performance with a stable environment compared to their proprietary database.
Customer Background
The customer is a leading online payment gateway provider and one of India’s fastest-growing companies that provide financial services and merchant website transactions to businesses of all sizes. The company provides integrated payment services thru a network of agents like mobile banking, retail shops, and internet-facilitated, at any place and time.
The Challenges
The customer’s then existing applications were built on a proprietary database and they struggled with achieving high performance owing to the 24×7 availability of their business. The unused indexes in their legacy database consumed a lot of space significantly dampening its overall performance. To modernise their setup and break free from its inflating costs, the customer looked to adopt a future-ready and scalable database like PostgreSQL.
To initiate this transition, the customer planned to move some of their business critical applications to PostgreSQL and avail of managed services along side to ensure a smooth and error-free migration. The customer wanted to set up best practices in terms of operational support along with continuous monitoring, performance, and support for the business-critical setup.
The Solution
Technology implemented – PostgreSQL
Services offered – Consulting, solution designing, implementation, and post-production operational support.
The architecture of the Onboard Production Database
Ashnik designed a migration plan coupled with managed services for three different applications. The scope of work included consulting, solution designing, implementation, and subsequent operational support.
Upon migration to PostgreSQL, our database experts provided support in resolving an out-of-sync server and helped to create an index on one of the longest-running queries. We advised the customer on better query optimization and how to apply it easily to resolve queries in the future.
Post implementation, we provided a set of best practices and recommended solutions to address the then ongoing performance issues, and achieve a high availability setup.
The implemented actions:
- Designing a highly scalable architecture
- Deploying it successfully in UAT
- Taking it successfully to production
- Managing 24×7 operations
Key components of the deployed solution:
- Backup and Recovery Tool –
An administrative utility by Postgres that provides simplified backup and recovery management for multiple local or remote servers. The support was aimed toward two types of backups that include full base backups and block-level incremental backups. The tool helped with retention policy support along with a simplified PITR process. - Maintaining a separate server for storing, and managing backups as well as for archives
- PgBadger –
This log analyzer by Postgres takes log output from running an PostgreSQL instance and processes it into an HTML file. The file contains detailed reports and graphs that can help analyze SQL traffic and performance. - Database-specific mount points can be maintained according to the recommendations as the transaction rate is unknown.
- Testing Architectural Health Check – A remote engagement in reviewing database instances and identifying issues and improvement opportunities in the following categories: Security, Performance, Backup, Replication, Maintenance, and Upgrades. This activity involved tuning on both the database and OS levels.
- Alert mechanism for Replication Lag and Database specific Mount points
Customer Benefits
The customer was incredibly happy with Ashnik’s solution and the successful implementation of the PostgreSQL database setup along with the managed services provided by us post implementation. The customer now runs its key business-critical applications on Postgres with high availability and best practices compared to their old setup with Oracle.