Skip to main content

Geo-Partitioning Tutorial for better database performance

In this Geo-Partitioning tutorial we show how Geo-Partitioning can be set up in CockroachDB to improve performance and to comply with data storage regulations. 00:00 Why Geo-Partitioning lowers latency 1:00 Agenda 1:16 Vehicle Sharing Application Architecture 4:20 Load Balancing in CockroachDB 4:35 What Reads and Writes look like in CockroachDB 7:57 Geo-Partitioning Demo Begins 11:01 Impact of Geo-partitioning on latency Geo-partitioning grants developers row-level replication control. By default CockroachDB lets you control which tables are replicated to which nodes. But with geo-partitioning, you can control which nodes house data with row-level granularity. This allows you to keep customer data close to the user, which reduces the distance it needs to travel, thereby reducing latency and improving user experience. To geo-partition a table: Define location-based partitions while creating a table. Create location-specific zone configurations. Apply the zone configurations to the corresponding partitions. If this video is unclear to you or you have follow-up questions please reach out in the comments below or in our community slack channel: https://cockroa.ch/Welcome-to-Slack --------------------------------------------------------------------------------------------------------------------------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB