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

CockroachDB

Hybrid Deployment Example Using AWS & A Raspberry Pi

A hybrid deployment model combines the use of both on-premises and cloud infrastructure to create a flexible and scalable computing environment. In this blog I'll demonstrate a basic Hybrid deployment using AWS Cloud and A Raspberry Pi I have in my house. But first of all, lets outline a few

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

fast reads

Want to speed up your reads?

Be a Leader and a Follower :-) In CockroachDB, a follower is a replica of a database that synchronises with the leader to ensure data consistency and availability. The leader is the node that accepts write requests and coordinates updates to the database. The followers replicate the leader's data and

Database

Comparing B-Tree and LSM Index Structures: Pros, Cons, and Use Cases

Indexes are crucial in the realm of databases for effective data processing and retrieval. An index is a type of data structure that arranges data to make it easier to search, sort, and retrieve information quickly based on certain criteria, like a single value or a range of values. Two

CockroachDB

Magic Quadrant: CockroachDB

We all understand just how crucial it is to find the perfect technology for your organisation. With a lot of options available out there, it can be overwhelming trying to figure out which one will meet your business needs the best. Luckily, there is a tool that can help you

performance

EXPLAIN ANALYZE : What You Need To Know

CockroachDB is an open-source, distributed SQL database that offers consistent, scalable, and highly available data storage. As with any relational database system, one of the most important tasks for a database administrator or developer is optimizing queries for performance. One tool that can be incredibly helpful for this task is

CockroachDB

Top 5 Show Commands in CockroachDB

CockroachDB is a distributed SQL database that provides scalability, fault tolerance, and consistency. It is an open-source database that is highly resilient and provides excellent performance, making it an excellent choice for modern applications. One of the essential features of CockroachDB is its powerful SHOW commands that enable users to

Database

Ensure 24/7 Availability of Your Retail or E-Commerce Application with CockroachDB: A Resilient, Scalable, and Consistent Database Solution

Retail and e-commerce companies operate in a highly competitive environment where customer satisfaction is the key to success. Customers expect an always-on 24/7 application and website. Any downtime can lead to customer dissatisfaction, loss of revenue, and damage to the brand reputation. To ensure continuous availability of their application

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

Migration

Migration de base... Why so serious?

[English version here] Récemment, j'ai discuté de la manière dont vous pouvez migrer vers Cockroach DB. J'ai parlé des adaptations de schéma, des changements d'application, etc. Ces articles n'étaient pas vraiment amusants à lire. J'ai donc décidé de rendre la migration de base de données amusante. La réponse est évidente

Migration

Why so serious about database migration?

[Version française ici] Recently, I discussed how you can move to Cockroach DB. I discussed schema adaptations, application changes, etc. Those posts weren't really funny to read. So I decided, how can we make database migration fun? The answer is obvious in 2023... Use ChatGPT! Starting with CoPilotI used Github

DB Console

Monitor your CockroachDB Cluster from your Smartphone

CockroachDB's web console (DB console) is designed to be intuitive and user-friendly, and provides a rich set of features for managing and monitoring CockroachDB clusters. It is particularly useful for users who are not familiar with command-line interfaces or who prefer a graphical interface for their database administration tasks. Accessing

CockroachDB

CockroachDB and Analytic Workloads

Although CockroachDB lands firmly in the OLTP space its perfectly acceptable to run more analytic type workloads against your cluster CockroachDB is primarily designed as an OLTP (Online Transaction Processing) database, which means it is optimised for handling high transaction volumes and low-latency queries. Its distributed architecture and support for

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

symfony framework

CockroachDB and the Symfony Framework

CockroachDB is a distributed SQL database that is designed to be scalable, resilient, and highly available. It is compatible with PostgreSQL, which means that applications built to use PostgreSQL can use CockroachDB as a drop-in replacement with minimal modifications. Symfony, on the other hand, is a popular PHP web application

Migrez vers CockroachDB - Partie 2

[English version available here] Dans la première partie, nous avons vu comment transformer et adapter vos schémas ou vos documents JSON pour les utiliser dans CockroachDB. Selon que vous veniez d'une base de données NoSQL comme Cassandra, MongoDB, Couchbase, etc., ou d'une base de données relationnelle comme Oracle, Postgres, MySQL,

Migrating to Cockroach - Part 2

[Version en Français ici] In the first part, we discussed how to transform and adapt your schema or JSON documents to be used in CockroachDB. Depending if you're coming from a NoSQL database like Cassandra, MongoDB, Couchbase, etc., or from a relational DB like Oracle, Postgres, MySQL, etc. you have

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

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

security

Customer Managed Encryption Keys and CockroachDB Dedicated: Protecting Your Data in the Cloud

Data security is more important as more businesses shift their operations to the cloud. Encryption, which converts sensitive data into a code that only authorised parties can decipher, is one of the best ways to safeguard your data. Yet not all encryption techniques are made equal. A strong method for

Database

The Importance of Encryption for Database Platforms: Protecting Your Data

Hello everyone, having worked in the database industry for over 30 years, I know firsthand the importance of protecting your data. One of the most effective ways to do this is through encryption, which transforms sensitive information into a code that only authorised parties can decode. In this blog post,

banking

Reliable banking with CockroachDB

There is probably not a day goes by without us accessing our banking apps on our smartphones. Like me, you have probably experienced that time when the app is unavailable to log you in or you have read on social media that a leading high street bank’s payment system

Migrez vers CockroachDB - Partie 1

[English version available here] La migration d'une base de données vers une autre n'est jamais une tâche facile. Quelle que soit votre solution, le passage à un autre outil nécessite une préparation et une adaptation. C'est souvent une tâche que vous allez gérer comme un projet. Pour aborder ce sujet,

CockroachDB

Migrating to Cockroach - Part 1

[Version en Français ici] Migrating from one database to another is never an easy task. Whatever your solution, switching to another tool requires preparation and adaptation. It is often a task that you will manage like a project. To address this topic, I have decided to break the problem down