How Storj Is Migrating From Postgres to CockroachDB: Bulk Loading Performan

4 years ago dzone.com

Summary: This is a summary of an article originally published by the source. Read the full original article here →

by Here is a story about how I recently migrated a large database (~400GB) from PostgreSQL over to CockroachDB.

CockroachDB version: 19.2.6, Cockroach Cloud running in Google Cloud (GCP), 3 node cluster with 1.5TB capacity

From the docs, there are essentially two different ways to perform the migration: High level lessons learned (details after if interested): In order to perform the migration from Postgres to CockroachDB, the high level steps that needed to occur in under 4 hours of downtime were: All of my infrastructure was running in Google Cloud, so I made sure to run all of the steps in the same region to reduce network latency. Google Cloud states in their docs “locations within regions tend to have round-trip network latencies of

DevOps Articles