SaaS Company Rapidly Scales Transportation Platform with Google Cloud Spanner

1 min read
Dec 11, 2023

Overview

Platform:

Google Cloud Platform

Industries

Telematics

Locations:

Canada

This company provides a software-as-a-service platform that connects commercial vehicles to the cloud. Processing billions of data points a day, the company leverages data analytics and machine learning to help customers optimize fleets through the reduction of fuel consumption, enhance driver safety, and ensure compliance with regulatory changes. As a rapidly growing business, the company required a data system that could scale to keep pace with business growth. 

The company was using a mission-critical system which used Microsoft SQL Server as its backend database technology. However, the IT team determined that they needed a simpler way to scale their data system so it would grow linearly with their data volume.

What we did:

The team began evaluating a migration from SQL Server to Google Cloud Spanner—a distributed SQL database management and storage service with high performance and availability at virtually unlimited scale—and turned to Pythian for their expertise with Google Cloud Spanner.

Pythian worked with the IT team to assess Spanner, and identified that Spanner could unlock capabilities the business needed. Since there was a requirement for real-time replication between SQL Server and Spanner—and vice versa—Striim was chosen to accelerate the time to solution. Pythian also developed post-migration operational capabilities as part of the solution—a one-of-a-kind deployment for Spanner using Terraform for scheduled backups and monitoring.

 

Technologies used:

  • Microsoft SQL Server
  • Google Cloud Spanner
  • Striim

Key Outcomes

After Pythian provided the company with a technical assessment and migration plan, Pythian seamlessly deployed Google Cloud Spanner—achieving the company’s quick timeline of eight weeks.

  • By migrating to Spanner, the company now has access to a fully managed cloud solution with built-in high availability, disaster recovery, and horizontal auto scaling.
  • The migration has eased management for the company’s IT team. 
  • Decreased dependency on SQL Server means faster development times, allowing the company to focus on customer experience.

Want to see similar results for your company?

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