Fintech | Cloud Migration

Financial SaaS Company Migrates to Google AlloyDB for PostgreSQL

This financial SaaS company was running their blockchain consumption platform on Amazon’s Aurora PostgreSQL, which generated a block of data every 1.5 seconds. The company began experiencing data ingestion performance and scalability issues with their production cluster; the insert speed was limiting the cluster, and team members were unsure if it was due to indexes or structures.

tech-company-cs
Customer
    

Customer

Industry

Fintech

Location

Montreal, Canada

Solution

Cloud Migration

Technology

Google Google Cloud AlloyDB for PostgreSQL

    

Overview

This financial SaaS company was running their blockchain consumption platform on Amazon’s Aurora PostgreSQL, which generated a block of data every 1.5 seconds. The company began experiencing data ingestion performance and scalability issues with their production cluster; the insert speed was limiting the cluster, and team members were unsure if it was due to indexes or structures.

The company needed to optimize speed and improve scalability—with no time to waste. The company wanted Pythian’s help evaluating whether to continue on Amazon Aurora PostgreSQL or migrate to Google’s AlloyDB. Google’s fully managed PostgreSQL-compatible database service is designed for the most demanding enterprise workloads.

css-tech-company
    

What we did

After discussing the company’s needs, Pythian’s database experts got to work. Pythian worked with the company to build a migration plan and then conduct a comparative test to evaluate the current database environment on Amazon Aurora PostgreSQL against Google AlloyDB.

Pythian provisioned Google AlloyDB, carefully reviewing and adjusting the configuration to achieve settings as similar as possible to the source AWS database to ensure the comparison wouldn’t face bottlenecks caused by the configuration.

Pythian also helped optimize the AlloyDB environment by providing repeatable deployment steps and documented best practices to make the environment more performant and cost-effective.

    

Technologies used

  • Amazon Aurora PostgreSQL
  • Google AlloyDB for PostgreSQL
  • Google Cloud
        

Key Outcomes

Pythian presented comparative testing to key stakeholders to identify the benefits and limitations of migrating to Google AlloyDB. The comparative test determined that Google AlloyDB provides a more performant environment, yielding better results to meet the business’s needs.

  • Pythian prepared the Google AlloyDB infrastructure for testing and migrated the data from Amazon Aurora PostgreSQL to Google AlloyDB.
  • Google AlloyDB improved the company’s database performance—performing 3x faster.
  • The company saved 60% in operational data costs by migrating.

Want to see similar results for your company?

Get in touch with a Pythian Cloud Migration expert to see how our team can help.
Related resources

Find your path to Google Cloud migration

Learn more about planning and implementing your cloud transformation. Check out our resources below:

Ebook: The Google Cloud Migration Handbook - Feb 2022
Man and woman looking at a computer screen, point of view is on their smiling faces.

Ebook: The Google Cloud Migration Handbook - Feb 2022

1 min read
eBook | Your Guide to Choosing a Google Cloud Partner - March 2022

eBook | Your Guide to Choosing a Google Cloud Partner - March 2022

1 min read
How to Transform Your Legacy SAP Environment with Google Cloud
Analytics

How to Transform Your Legacy SAP Environment with Google Cloud

Apr 13, 2022 12:00:00 AM 3 min read
Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.