dbist

Load balancer high availability with CockroachDB and HAProxy

---

I've been experimenting with CockroachDB high availability scenarios and fault domains. CockroachDB relies on load balancer to provide client fault tolerance. Today, I'd like to look at a load balancer as the single point of failure. To my knowledge, load balancer high availability is not discussed in any of the existing CockroachDB documentation.

---

Checkout my previous article where I discuss connection pool high availability

dbist

Connection pool high availability with CockroachDB and PgCat

---

I've been experimenting with PgCat which markets itself as a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

---

I've written about PgCat and CockroachDB in my previous article

dbist

Using CockroachDB CDC with Apache Pulsar

---

As of this writing, CockroachDB does not have a direct integration with Apache Pulsar and this tutorial is an attempt to integrate CockroachDB CDC with Pulsar via our existing Kafka sink.

---

Previous articles on CockroachDB CDC

dbist

CockroachDB TIL: Volume 12

---

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're finding partial indexes, identifying the DB Console URL with SQL, experimenting with a light weight pooler called pgcat, handling client disconnects and improving UX with PGSERVICEFILE

---

Previous articles

dbist

Correcting my misconceptions with REGIONAL BY ROW tables

---

This tutorial will dive deeper into nuances with CockroachDB REGIONAL BY ROW tables. I learned the hard way about the limitations and to pay close attention to the documentation on the topic.

---

Previous articles on multiregion

dbist

Optimizing pgbench for CockroachDB Part 2

---

I originally wrote an article on pgbench and CockroachDB in October of 2021. Today, I am going to continue talking about pgbench optimizations you can implement to make CockroachDB perform.

---

Previous articles

dbist

Optimizing pgbench for CockroachDB Part 1

---

I originally wrote an article on pgbench and CockroachDB in October of 2021. Today, we're going to return to the topic and discuss a few improvements.

---

Previous articles

dbist

Using short-lived tokens to authenticate Python applications to CockroachDB

---

Today we're going to demonstrate how a Python application can interact with CockroachDB using jwt tokens. We are going to go over requesting and renewing authentication tokens.

---

Motivation

dbist

Configure Single Sign On for CockroachDB CLI with Okta IdP

---

Today we're going to cover how to set up Single Sign On for CockroachDB CLI with Okta SSO.

---

Motivation

dbist

CockroachDB TIL: Volume 11

---

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering auto-completion and syntax highlighting in CLI with pgcli, Sqlalchemy and ON UPDATE expressions, identifying sessions, naming transaction blocks and setting traces in CLI.

---

Previous articles