Cockroach introduced Follower reads in 2018 and Bounded staleness in 2020 which service reads from a local or follower replicas. A great use case for this is allowing point reads to a node which is isolated from the cluster during a network partition. This blog will illustrate how this works…

Tenant node Isolation through database partition and sharding This blog illustrates a method of tenant isolation using table partitioning and sharding to restrict data to a specific node or set of nodes. In a prior blog, I covered a similar concept across regions and now we will peel back to…

Part 1 The purpose of this blog is to help customers and colleagues identify candidate Oracle workloads which are a fit for CockroachDB. This can be achieved by reviewing a few statistics captured in an Oracle Automatic Workload Repository report (AWR). …

Part 2 — Node CPU Profiles Continuing from my blog “Tracing application Interactions with CockroachDB”, Next, I would like to dive into the cpu profiles and give some examples of how to collect them and to inspect the profiles offline and online. CockroachDB is written in go, which has a…

Part 3 My prior articles, “Regional Survivability optimized YCSB Client and RBR” and “CockroachDB 22.1 Multi Region Abstractions with YCSB” explored the YCSB workloads with a multiregion dedicated cluster. Soon after, Cockroach released the serverless beta version. This writeup is to illustrate how Serverless can also be to run a…

Using the Join Order Benchmark Query performance is impacted by a great many things. For complex queries, Join ordering is one of the main contributors to performance. Ideally, a plan should start with the join that eliminates the most data to minimize the amount of data carried into the following…

Load testing is a common practice used across software releases. Not only for application code releases but also for database releases. There are various technologies which can provide an end to end solution for stress testing such as Jmeter, Locust and others in that space. A simpler approach for narrowing…

Logical Replication using CockroachDB Changefeeds and CDC-SINK While CockroachDB replicates data across nodes, it is also capable of sending data out of the cluster for the purposes of refreshing data in an analytics data store, data bus or an operational data store. CockroachDB enables a changefeed which watches all changes…

This Blog presents and illustrates one mechanism for migrating a CockroachDB cluster from one set of nodes to another, using the inherent elastic nature of the cluster architecture. The cluster is “migrated” by adding the new nodes to the cluster, and then retiring the old nodes. This approach is presented…