The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Celebrating Significant Growth Milestones in YugabyteDB’s Community!

The YugabyteDB community is at the heart of everything we do at Yugabyte. The worldwide community of open source enthusiasts, application builders, and database aficionados has been a fountain of inspiration, knowledge, and belonging for us. Here are some community highlights we’d love to call out.

Over 5K Users in YugabyteDB Community Slack

We planned to celebrate when we reached 5,000 YugabyteDB Community Slack members.

Read More

A Matter of Time: Evolving Clock Sync for Distributed Databases

Distributed clock synchronization is critical for many applications, including distributed SQL databases. Clock synchronization needs to keep up with the other demands in our modern infrastructure, such as:

  • Applications that have increasing performance requirements while distributing data across different geographic regions
  • Network infrastructure and computing power that is improving constantly

A distributed SQL database is highly available and resilient to failures when deployed across a cluster of nodes.

Read More

Are Stored Procedures and Triggers Anti-Patterns in the Cloud Native World?

The last decade has seen a rise in usage of distributed SQL databases for transactional, cloud native applications. Popular options include Amazon Aurora, Google Spanner, YugabyteDB, and CockroachDB. All of these databases are resilient to failures and achieve high availability. However, they vary dramatically in the set of relational database management system (RDBMS) features they support.

Google Spanner and CockroachDB have chosen to rewrite the SQL engine from scratch.

Read More

Reimagining the RDBMS for the Cloud

Perspectives from 5 years of building a cloud native database

YugabyteDB just turned 5 years old, and I cannot help but reminisce about our journey in building this database over the last half-decade. I vividly remember the genesis of the YugabyteDB project, which started with Kannan, Mikhail, and myself meeting for lunch at a restaurant to discuss the future of cloud native databases.

Read More

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