Cockroach Labs

A collection of 25 posts

Migration

Using AWS DMS to Replicate Data from Aurora RDS to CockroachDB

In this blog I will demonstrate the process of using AWS DMS to aid in a basic migration from Aurora PostgreSQL (RDS) to CockroachDB to simplify your migration needs. Database migration is the process of transferring data from one database to another. There are many reasons why database migration might

security

How CockroachDB ensures data privacy and security

Database security is crucial for organisations that rely on databases to store sensitive and confidential data. Databases can contain critical business data, such as customer information, financial records, and intellectual property, which makes them a prime target for cyber attacks. As a distributed database, CockroachDB is designed with security in

multi-region

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

CockroachDB

Cloud Agnosticism and Regulatory Compliance in Financial Services and Fintech

Cloud computing has become increasingly popular in the financial services and fintech industries as a means of improving operational efficiency, scalability, and innovation. However, the adoption of cloud computing in these industries is subject to regulatory requirements around data privacy, security, and operational resilience. In this blog post, we will

architecture

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

RAFT

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

automated

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

always on

DORA and How CockroachDB Can Help

Data security and privacy are becoming more and more crucial, with numerous governments and regulatory organisations enacting laws and regulations to ensure that businesses protect the sensitive data of their customers. To secure the data of their clients, businesses must abide by laws like the General Data Protection Regulation (GDPR)

Cockroach Demo

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

Database

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

Software Engineering

Application Design Patterns

Application design patterns are a set of rules that specify the organisation and structure of an application. These patterns help to ensure that systems are scalable, maintainable, and simple to comprehend by giving developers a standard language to use when discussing design choices. Applications can be created using a variety

Cloud

Multi-Cloud Database Deep Dive

A Deep Dive into the benefits and considerations of Multi-Cloud Database

azure

Blog - CockroachDB 22.2 SSO with Azure Managed Identities

Overview: In this blog post we will be demonstrating how to authenticate and connect to CockroachDB using JWT tokens issued to Azure's Managed Identities. In this example, we will retrieve the JWT tokens from Azure for a test SQL user in CockroachDB and use those for user authentication. At a

CockroachDB

Speedy recovery without Backups

Backups are often thought about in the context of a disaster, the loss of a data centre, SAN or other infrastructure. Fortunately for operators and admins everywhere these are relatively rare occurrences. Backups are also exist to give comfort in the form of regulatory and audit compliance. However, the most

Data

Why Is Database Isolation Level So Important? You Might Be surprised.

You’ve probably heard the term database isolation level before, but how important is it? In other words, should you let your database admin worry about it, or should you care enough to be familiar with it? And if you should care, what are these different isolation levels anyway? The

CockroachDB

CockroachDB: Dedicated Security - Authentication

CockroachDB Dedicated has 2 Levels of Authentication * CockroachDB Cloud Console * SQL Users In this Blog, we will discuss how both of these should be used to secure your Cockroach Cloud Organization account. Website Link for further Details - https://www.cockroachlabs.com/docs/cockroachcloud/console-access-management.html CockroachDB Cloud Console Within

CockroachDB

Why Distributed Databases Are Becoming More Popular

We have been hearing about distributed databases for some time now, but what exactly does it mean? Also, why are these databases becoming so popular? Let’s take a look at these questions, as well as some of the real-world applications of distributed databases, to better understand what this technology

CockroachDB

Streaming Data from CockroachDB to Redpanda

Streaming Data from CockroachDB to Redpanda

CockroachDB

Active Passive vs Multi-Active Database Topologies

A Comparison of Active Passive vs Multi-Active Database Deployments

Cockroach Labs

DevOps culture: The need of the day.

DevOps Culture is the Future

CockroachDB

CockroachDB vs AWS Aurora

This article is all about comparing the feature sets of CockroachDB and Amazon Aurora. These are two of the most popular SQL and databases of the cloud era

CockroachDB

CockroachDB vs SQL Server

A quick comparison of cockroachdb and SQL Server.

CockroachDB Featured

Top 5 Useful Commands with CockroachDB

The Top 5 Commands used to help you become more proficient in administering and using CockroachDB

CockroachDB

Schema Design Considerations with CockroachDB. What is a Hotspot Not?

Want to know what considerations to make when selecting primary keys in cockroachDB? Want to know how CockroachDB diversifies and replicates it data?

CockroachDB Featured

How to get started with CockroachDB - Binary, Docker or Kubernetes

Want to get started with CockroachDB. This is the perfect blog post for you. Today I am going to show you how to get started with distributed sql databases so you can start developing your application locally on your laptop.