The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

What’s New in YugabyteDB 2.5 – Enterprise-Grade Security Features

YugabyteDB Enterprise-Grade Security Features

The YugabyteDB 2.5 release adds many critical enterprise-grade security features. This blog post outlines these newly added features.

Authentication

Adding scram-sha-256 authentication

The first notable addition is the addition of a much improved, password-based authentication mechanism called Salted Challenge Response Authentication Mechanism (or simply SCRAM) as described in RFC5802.

Read More

Announcing YugabyteDB 2.5

Support for Geo-Partitioning and Enterprise-Grade Security Features

YugabyteDB Adds Support for Geo-Partitioning and Enterprise-Grade Security Features Announcement

Our mission at Yugabyte is to build the default distributed SQL database for cloud native applications in a multi cloud world. To further that mission, this release brings major enhancements to multi-region deployments, performance, and security features offered by the database – while simultaneously improving on high availability,

Read More

Distributed SQL Summit Schedule Now Live!

In two weeks, thought leaders, database builders, and application developers are coming together for a free online conference to push the boundaries of cloud native RDBMS forward. Distributed SQL (Virtual) Summit, now in its second year, is taking place September 15-17.

We’re excited to announce that the 2020 Distributed SQL Summit schedule is now live!

Read More

Row Counts of Tables in a SQL Schema & Database – PostgreSQL and YugabyteDB

Getting total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database) is a useful technique to have in one’s tool belt of SQL tricks. While there are a number of use cases for this, my scenario was to get the per-table row counts of all tables in PostgreSQL and YugabyteDB as a first sanity check after migrating an application with the pre-existing data from PostgreSQL to YugabyteDB.

Read More

TPC-C Benchmark: 10,000 Warehouses on YugabyteDB

We are excited to announce that the TPC-C benchmark implementation for YugabyteDB is now open source and ready to use! While this implementation is not officially ratified by the TPC organization, it closely follows the TPC-C v5.11.0 specification.

For those new to TPC-C, the aim of the benchmark is to test how a database performs when handling transactions generated by a real-world OLTP application.

Read More

100% Committed to Open Source, YugabyteDB Community Update – June 11, 2020

While it is still early days, it is exciting to see the YugabyteDB community hit some cool milestones! We wanted to share them with you, plus update you some additional community related news.

Our Commitment to Social Justice

First things first. Recent events that resulted in the death of George Floyd at the hands of police have been traumatic and painful for many of us,

Read More

Bringing Truth to Competitive Benchmark Claims – YugabyteDB vs CockroachDB, Part 2

In part 1 of this blog series, we highlighted multiple factual errors in the Cockroach Labs analysis of YugabyteDB. In this second post we provide the next layer of detail behind YugabyteDB’s architecture, with an emphasis on comparing it to that of CockroachDB’s.

Contents of this post

TLDR

Yugabyte SQL is based on a reuse of PostgreSQL’s native query layer.

Read More

Bringing Truth to Competitive Benchmark Claims – YugabyteDB vs CockroachDB, Part 1

This is the first in a two part blog series which highlights factual errors in the Cockroach Labs analysis of YugabyteDB. In the second post in this series, we provide the next layer of detail behind YugabyteDB’s architecture, with an emphasis on comparing it to that of CockroachDB’s.

Contents of this post

Introduction

At Yugabyte,

Read More