Dan The Engineer (Page 3)

Dan The Engineer

Sign in Subscribe

Making Friends in the Cloud: A Humorous Guide to Integrating CockroachDB with Other Services

Making Friends in the Cloud: A Humorous Guide to Integrating CockroachDB with Other Services

If you're running a distributed SQL database like CockroachDB in the cloud, you know that integration with other cloud services is crucial for success. But how do you make sure your database is playing nice with all the other kids on the block? Here are some tips for integrating CockroachDB

Optimising Performance and Availability with CockroachDB Monitoring Tools

Optimising Performance and Availability with CockroachDB Monitoring Tools

In my experience as a seasoned Database Administrator and Engineer, monitoring tools play a crucial role in the efficient maintenance of databases. With the aid of these technologies, administrators can enhance the performance of their systems, spot problems early, fix them, and ultimately give users better services. A database that

CockroachDB and the RAFT Protocol

CockroachDB and the RAFT Protocol

CockroachDB is a Survivable, Thriveable and Scalable distributed SQL database. A winning formula for modern, mission critical applications at scale. To maintain its goal of being all three it uses the RAFT protocol to align and agree on one single state So, what is RAFT? The RAFT protocol is a

Running CockroachDB on ARM based Architecture

Running CockroachDB on ARM based Architecture

Here at Cockroach Labs we understand the importance of being able to develop and test our software locally, and starting from version 22.2 we've released ARM64 binaries for our database, allowing developers to install on their MacBooks, Raspberry Pi's and other ARM based machines. In this blog post I

Serialisable Isolation doesn't have to mean slower!

Serialisable Isolation doesn't have to mean slower!

We recently came across a scenario where the assumption was that a current production workload needed to rely on Read Committed isolation to support lower latency requests to and from the database. This assumption albeit it correct made us think. If you can utilise only Serialisable Isolation due to consistency

Synthetic vs Non-Synthetic Benchmarking: Understanding the Difference

Synthetic vs Non-Synthetic Benchmarking: Understanding the Difference

As technology advances, businesses are finding themselves dealing with massive amounts of data. Databases play a significant role in storing and managing this data, and businesses need to ensure their databases perform optimally. Benchmarking is one way to assess the performance of a database, and there are two types of

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

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

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

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

Demo of CockroachDB's self-healing capabilities

Demo of CockroachDB's self-healing capabilities

This demo will show you the self-healing capabilities of CockroachDB. In scenarios where your number of nodes is larger than your configured replication factor (assuming constraints like replication zones are met) CockroachDB will automatically up-replicate data of a failed node onto the remaining ones, in order to restore the desired

Getting to know the CockroachDB 'demo' feature

Getting to know the CockroachDB 'demo' feature

Getting started with CockroachDB demo Prerequisite Download the CockroachDB binary from this location (MacOS, Linux or Windows available) What is the CockroachDB demo? The cockroach demo command starts a temporary, in-memory CockroachDB cluster of one or more nodes, with or without a preloaded dataset, and opens an interactive SQL shell

CockroachDB : The multi-region database

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. 1. Data Replication: CockroachDB automatically replicates data across multiple regions to ensure that data is available even

Blog - CockroachDB, Azure Data Lake Gen2 and Synapse

Blog - CockroachDB, Azure Data Lake Gen2 and Synapse

CockroachDB is an Distributed SQL OLTP database which is perfect for supporting critical line of business applications that have scale and resiliency requirements. However, an organization’s data architecture will often contain many tools, including something for transforming, shaping & analyzing data to help inform better business decisions. This means that

Qu'est-ce qu'une Forme Normale et devez-vous les respecter ?

Qu'est-ce qu'une Forme Normale et devez-vous les respecter ?

[English version available here] En comparant les SGBD et les bases NoSQL, la partie "schéma" est souvent utilisée. Dans le monde NoSQL, vous voyez les "schema-less" ou "no schema" comme un avantage. Si cela peut être vrai parfois, vos applications s'appuieront sur un schéma de quelque manière que ce soit.

What is Normal Form and do you need to respect them?

What is Normal Form and do you need to respect them?

[Version en Français disponible ici] Comparing RDBMS and NoSQL, the schema part is often used. In NoSQL, you see "schema-less databases" or "no schema" as an advantage. If it could be true sometimes, your applications will rely on a schema in any way. You always end up presenting data to

Scaling Your Fintech Business for Growth: How CockroachDB Can Help Increase Your Customer Base

Scaling Your Fintech Business for Growth: How CockroachDB Can Help Increase Your Customer Base

One of the main key objectives for businesses operating in the fintech sector is to expand their customer base. It has been a turbulent time for Financial Services companies over the past few years, market conditions caused by Brexit, COVID and the Russian war in Ukraine have caused significant economic

Running a Database on Kubernetes

Running a Database on Kubernetes

Since databases have certain demands and requirements that can be tough to achieve in a containerized environment, running a database platform on Kubernetes can be a challenging undertaking. In this post, we'll look at some of the issues that can occur when using Kubernetes to run a database and how

CockroachDB CDC Example

CockroachDB CDC Example

With the aid of CockroachDB's Change Data Capture (CDC) capability, you can keep track of database changes and instantly replicate them to other systems. In order to synchronise data between CockroachDB instances or between CockroachDB and other systems, it is intended to do so in a high-performance and low-latency manner.

CockroachDB vs MongoDB

CockroachDB vs MongoDB

Both CockroachDB and MongoDB are distributed database management systems, but they each have a particular set of features and functionalities. In this post, we'll examine both databases in more detail and weigh their advantages and disadvantages. A Little on CockroachDB CockroachDB was created with high fault tolerance and scalability in

CockroachDB 22.2 [Français]

CockroachDB 22.2 [Français]

[English version available here] Récemment, CockroachLabs a lancé CockroachDB 22.2 avec un grand nombre de nouvelles fonctionnalités. Pour n'en citer que quelques-unes, vous trouverez des User Defined Functions, Time-To-Live au niveau des lignes, et le CDC (Change Data Capture) avec transformations et filtrage. Chacune de ces fonctionnalités est une