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…

Simple illustration of a multi-region application in a multi-region Kubernetes deployment! Way back in 2019, my manager asked me to assist our docs team with a multiregional illustration on kubernetes and I wrote up this GitHub issue. However it never got to the docs, so I am going to take…

Part 1: Schema conversion tool enables PostgreSQL migrations to Cloud Very neat announcement from our leader Nate Stewart on how customers can migrate existing PostgreSQL backend applications to our Cockroach Cloud offering using MOLT. In this blog, we will walk through the first phase of a database migration which is…

MR settings with failure testing Based on my previous article on trade processing, this blog will explore in detail the workload using CockroachDB MR features with some fault injection analysis. …

Part 2 Now lets pick up from YCSB with Primary regions and discuss optimized client access with CockroachDB Region by Row data placement. Optimized client access simply is when a client requests reads and writes to key or keys in the home region of the key. This is important for…