Blogs by: Karthik Ranganathan

Celebrating Significant Growth Milestones in YugabyteDB’s Community!

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. But then we blinked and realized we were already over 5,500!

Read more

A Matter of Time: Evolving Clock Sync for Distributed Databases

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?

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. As a result, they do not implement many of the advanced features supported by a traditional RDBMS.

Read more

YugabyteDB: Reimagining the RDBMS for the Cloud

YugabyteDB: 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. After iterating on the idea over a number of such discussions,

Read more

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

What’s New in YugabyteDB 2.5 – 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. This scram-sha-256 authentication mechanism, identical to the most secure PostgreSQL authentication schema,

Read more

Geo-Partitioning of Data in YugabyteDB

Geo-Partitioning of Data in YugabyteDB

Achieve high performance and regulatory compliance for global apps

We are excited to announce the availability of row-level geo-partitioning in YugabyteDB, a feature heavily requested by our user community and enterprise customers alike. This feature allows fine-grained control over pinning data in a user table (at a per-row level) to geographic locations, thereby allowing the data residency to be managed at the database level.

Making the nodes of a multi-region database cluster aware of the location characteristics of the data they store allows conforming to regulatory compliance requirements such as GDPR by keeping the appropriate subset of data local to different regions,

Read more

Announcing YugabyteDB 2.5

Announcing YugabyteDB 2.5

Support for Geo-Partitioning and Enterprise-Grade Security Features

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, horizontal scalability, and ease of managing the database.

  • Enhanced multi-region capabilities with geo-partitioning and follower reads: The YugabyteDB 2.5 release adds row-level geo-partitioning capabilities as well as follower reads to the extensive set of multi-region features that YugabyteDB already had.

Read more

Row Counts of Tables in a SQL Schema and Database:  PostgreSQL vs. YugabyteDB

Row Counts of Tables in a SQL Schema and Database: PostgreSQL vs. YugabyteDB

Getting the total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database) is a useful SQL technique to have in your toolkit. This blog post will guide you to obtain per-table row counts of all tables in PostgreSQL and YugabyteDB. This can serve as a first sanity check after migrating an application with pre-existing data from PostgreSQL to YugabyteDB.

This blog post also outlines how to get the following row counts broken down per table in a schema,

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free