Category: Database, Data
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
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
Related Articles
Community Partners
DevOps Careers