This blog shows how to use value-based splitting to manually split tables into ranges with approxiimately-equal sizes when the data in a CockroachDB table is unevenly distributed. This is an advanced technique, because CockroachDB automatically manages ranges, so you usually don’t need to take manual control. Further, even when you want to take control, there… Continue reading CockroachDB Range Splitting Using ntile()
Category: Content
CockroachDB SQL Column Name Utility
Today I’ll share a simple “snippet” utility SQL query. You specify a table in your database and an alias for that table, and it generates several flavors of column-separated lists of column names for that table. This can come in handy when you are crafting SQL to join multiple tables that have the same column… Continue reading CockroachDB SQL Column Name Utility
CDC Sink Replication from PostgreSQL to CockroachDB
CDC Sink is a tool that enables logical data replication to CockroachDB, the SQL relational database with built-in high availability, horizontal scalability, multi-region geographic distribution, and fully-consistent transactional data. Data Sources CDC Sink works with a variety of data sources, including: This blog post focuses on using PostgreSQL as the source database. Use Cases One… Continue reading CDC Sink Replication from PostgreSQL to CockroachDB
CockroachDB Multi-Region Under-the-Hood
CockroachDB has always provided a SQL relational database with high availability, horizontal scalability, and multi-region geographic distribution, while delivering fully-consistent data and ACID transactions. In version 21.1, CockroachDB provided a new multi-region syntax to make these features easier to configure. This syntax is high-level, declarative and goal-oriented. But it raises the question, “What’s going on… Continue reading CockroachDB Multi-Region Under-the-Hood