distributed - Dan The Engineer

CockroachDB: Multi-Region refresher

This post will take us through a high-level refresher of what it takes to be a Multi-Region, distributed SQL database and how we achieve this at Cockroach Labs. But first, here is a little bit of information that will allow you to get up and running with CockroachDB and its

Analytics

CockroachDB and Analytic Workloads - Part 2

In an earlier post we discussed how CockroachDB can indeed be used for Analytics workloads. If you are interested in reading that article its available here In this second post we will give a short refresher on why CockroachDB can be a good fit for analytics and then provide an

gaming

CockroachDB meets the Gaming Industry

CockroachDB is proving to be a highly successful database in the world of online gaming. Many games companies support and actively promote the use of CockroachDB to develop your games and store your players "in-play" data and subscription details. Online gaming relies heavily on real-time data processing and storage, which

distributed

Comparing RAFT, PAXOS, and Calvin Consensus Algorithms: Why CockroachDB Chose RAFT

Consensus algorithms are essential for distributed databases, enabling nodes in the cluster to agree on a single version of the data. RAFT, PAXOS, and Calvin are three popular consensus algorithms used in distributed systems. In this blog post, we will compare these algorithms and discuss why CockroachDB chose RAFT as

logistics

CockroachDB is a great fit if your business is Logistics

When it comes to logistics we see regularly that there is a clear set of priorities that need to managed in order for your business to be successful. These include, keeping transportation costs down as well as keeping up with customer/industry demands. Sourcing consistent, reliable carrier capacity while keeping

CockroachDB

Keycloak on Distributed SQL (CockroachDB) - Part 2/2

In part one of this post, we configured a single Keycloak node to store it's data in a resilient and available CockroachDB. In this post we cover how to add more nodes to the cluster and ensure that the keycloak nodes are able to register themselves on CockroachDB which, then

CockroachDB

Keycloak on Distributed SQL (CockroachDB) - Part 1/2

With data breaches and cyber attacks becoming increasingly common, modern organisations require a robust security system in place that is also highly available. Keycloak is a popular open-source IAM solution that not only provides robust security features but also high availability between nodes by using a shared cache. It's built

data locality

Utilise the included demo feature of CockroachDB to discover how to geographically position your data

Example setup, configuration and test 1. Stand up a demo multi-region cluster locally using CockroachDB Demo $ cockroach demo --no-example-database --nodes 9 --global 2. Create a Database CREATE DATABASE db PRIMARY REGION "us-east1" REGIONS "us-west1", "europe-west1"; USE db; 3. Create a table with Region by Row functionality CREATE TABLE public.users

CockroachDB

CockroachDB : The multi-region database

CockroachDB is a distributed database that you can span across multiple geographic regions. To provide this multi-region capability, CockroachDB uses a combination of techniques such as data replication, distributed consensus, and node replication. Data Replication: CockroachDB automatically replicates data across multiple regions to ensure that data is available even if