The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Performing Flexible IO Testing in YugabyteDB

ybio is a PL/pgSQL based load generator for PostgreSQL and YSQL. This YugabyteDB-specific IO testing toolkit performs flexible IO testing to specific parts of the YugabyteDB infrastructure with no client installation. And because this toolkit is PL/pgSQL-based, it can also work on native PostgreSQL.

ybio is strongly inspired by Kevin Closson’s SLOB and pgio.

Read More

Three Reasons Why I Joined Yugabyte APJ

Hello Everyone! I am Lakshmi, a tech product marketing intern for the Yugabyte Asia Pacific Japan (APJ) team. It has been my first month working at Yugabyte and I am thankful for the opportunity. Beyond my internship, I am a final year student at the NUS Business School in Singapore, specializing in Business Analytics.

A bit about me

Prior to joining Yugabyte APJ,

Read More

Distributed SQL Deep Dive: Inside YugabyteDB’s Two-Layer Architecture

YugabyteDB is a 100% open source, distributed SQL database system. This single phrase expresses two distinct notions: a SQL database system, and a distributed database system. Historically, these notions were mutually exclusive. But current technology allows a single system to implement both notions. YugabyteDB does this with its two-layer architecture: an extensible query processing layer and a distributed document store.

Read More

Announcing YugabyteDB 2.12: Seamless Security and Better Manageability

Last November, we announced the general availability of YugabyteDB 2.11, a major release which extends PostgreSQL compatibility of the open source distributed SQL database. All these features are readily available in this stable release for any production environment.

In addition to making these features GA, YugabyteDB 2.12 introduces several new capabilities and significant improvements towards seamless security and better manageability.

Read More

Yugabyte Partners with HashiCorp Vault for Centralized Secrets Management

Yugabyte is on a mission to build the leading distributed database for cloud native applications and simplify operational data infrastructure. The Yugabyte team is delighted to announce a new technology partnership with HashiCorp, a market leader in multi-cloud infrastructure automation software. The partnership brings integration of Yugabyte Platform with HashiCorp Vault.

The Yugabyte Platform integration is officially verified and approved by HashiCorp.

Read More

Better Developer Experience: Getting Started with YugabyteDB on Gitpod

Developer onboarding and experience gets simplified every day. But while developers use many modern software development techniques—including 12-factor, cloud native, and continuous integration—developer onboarding remains a challenge. Therefore, what developers need is an integrated, self-contained platform that helps them get started with ease. 

Gitpod is one such way we can steer into that problem space to create a better developer experience.

Read More

Database Connection Management: Exploring Pools and Performance

There are many secrets to creating a high-performing database application. One such secret is proper database connection management. However, this secret is not specific to YugabyteDB or PostgreSQL, but applies to any database.

In this post, we examine database connection management through the lens of YugabyteDB. We explore pools and performance, and run tests to measure the results.

Read More

YugabyteDB Community Spotlight – February 2022

In this ongoing series, we highlight community members who are solving interesting problems with YugabyteDB, the first—and only—100% open-source, hybrid, multi-cloud, distributed SQL database on the planet.

James Hartig, Co-Founder, Admiral

Admiral is a leading Visitor Relationship Management (VRM) platform, serving thousands of publishers worldwide. The company empowers publishers to engage their audiences to drive and optimize revenue streams from paywalls to adblock recovery.

Read More

TPC-C Benchmark: Scaling YugabyteDB to 100,000 Warehouses

We’re excited to announce a new milestone in our TPC-C benchmark journey! YugabyteDB can now scale up to 100,000 warehouses with an efficiency of 99.78%. More specifically, this results in 630,000 operations per second on the database cluster, observed over a two-hour period.

For those new to TPC-C, it’s an OLTP system benchmarking tool used to measure performance when handling transactions generated by a real-world OLTP application.

Read More