How a global e-lock manufacturer modernized their IAM system with Managed CockroachDB

How a global e-lock manufacturer modernized their IAM system with Managed CockroachDB

A global electronic lock company wanted to upgrade their identity access management (IAM) system to achieve global scale with no manual sharding. They wanted to move away from sharding and evolve the app’s architecture from monolithic to microservices. With no in-house site reliability team, they started evaluating database-as-a-service (DBaaS) products. Their requirements included: 

  • Data domiciling: The manufacturer has customers across Europe, Asia, and North America, and they needed to ensure European customer data remained in Europe in order to remain compliant with the General Data Protection Regulation (GDPR). If possible, they wanted to pin row-level data to individual countries. 
  • Global scale without manual sharding: The team wanted to scale globally to reach its widespread customer base, but they needed low-latency reads for their time-sensitive use cases. 
  • Resiliency: In the event of a regional failure, they needed their database to remain available so customers could access important facilities.
  • Data log: log of their transactional updates into their Elasticsearch, Logstash, and Kibana stack as an event bus for microservices. 

The team landed on using Managed CockroachDB, which is able to hit all four of the requirements through a managed, geo-partitioned global database with change data capture capabilities. Their new global setup has three regions, which not only improves latency for customers living in each region, but gives them the ability to domicile European data for GDPR compliance. 

Managed CockroachDB cluster uses the geo-partitioned replicas configuration.

Managed CockroachDB is now a critical part of the application’s infrastructure, and the manufacturer’s small engineering team has more free time to handle development. Want more detail? Read the full case study here. 

Keep Reading

SQL Prober: Black-box monitoring in Managed CockroachDB

This blog post reflects my work as an intern this summer with the SRE team at Cockroach Labs. Earlier this …

Read more
CockroachDB 2.1: Easier migrations and a 5x scalability improvement

CockroachDB was built to help teams scale their applications across the globe without sacrificing SQL’s …

Read more
How to leverage geo-partitioning

Introduction

As we’ve written about previously, geographically distributed databases like CockroachDB …

Read more