How It Works

TPC-C Benchmark: 10,000 Warehouses on YugabyteDB
July 28, 2020
By
Community NewsDatabasesDistributed SQLHow It WorksOpen SourcePerformance BenchmarksYugabyteDB

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. This blog post shows the results of running the TPC-C benchmark in addition to outlining our experience of developing and running a TPC-C benchmark against YugabyteDB.

…

Read more

Polymorphism in SQL part one – anyelement and anyarray
June 24, 2020
By
DatabasesDistributed SQLHow It WorksPostgreSQL

Polymorphism in SQL part one – anyelement and anyarray

The term “polymorphism”, and its inflections, has various meanings in the context of programming languages in general. Roughly, it means “chameleon-like”. Of course, Wikipedia has something to say about it, here. PostgreSQL uses it with this meaning: “Parametric polymorphism: when one or more types are not specified by name but by… symbols that can represent any type”.

The term “variadic” has a universal meaning,

…

Read more

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables
May 12, 2020
By
DatabasesDistributed SQLHow It WorksOpen SourcePostgreSQLYugabyteDB

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables

In YugabyteDB v2.1, we released a new feature in beta: colocated tables. And we were excited to announce the general availability of colocated tables, along with many other exciting new features, in YugabyteDB 2.2. In this post, we’ll explain what colocated tables are in a distributed SQL database, why you would need them, and how to get started.

Read more

Distributed SQL Tips and Tricks – Jan 31, 2020
January 31, 2020
By
Community NewsDatabasesDistributed SQLHow It WorksPostgreSQL

Distributed SQL Tips and Tricks – Jan 31, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

Can I specify the number of tablets I want a table to have?

…

Read more

Distributed SQL Tricks and Tips – Jan 17, 2020
January 17, 2020
By
Community NewsDistributed SQLHow It WorksPostgreSQL

Distributed SQL Tricks and Tips – Jan 17, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub or Stackoverflow. Ok, let’s dive right in:

What’s YugabyteDB? It is an open source,

…

Read more

Four Data Sharding Strategies We Analyzed in Building a Distributed SQL Database
January 14, 2020
By
Distributed SQLHow It WorksYugabyteDB

Four Data Sharding Strategies We Analyzed in Building a Distributed SQL Database

A distributed SQL database needs to automatically partition the data in a table and distribute it across nodes. This is known as data sharding and it can be achieved through different strategies, each with its own tradeoffs. In this post, we will examine various data sharding strategies for a distributed SQL database, analyze the tradeoffs, explain the rationale for which of these strategies YugabyteDB supports and what we picked as the default sharding strategy.

…

Read more

Distributed SQL Tricks and Tips – Dec 20, 2019
December 20, 2019
By
Distributed SQLHow It WorksHow ToPostgreSQL

Distributed SQL Tricks and Tips – Dec 20, 2019

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new blogs and documentation that has been published since the last blog. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub or Stackoverflow. Ok, let’s dive right in:

How can I update a JSONB document in YugabyteDB?

…

Read more

YugabyteDB Engineering Update – Dec 19, 2019
December 18, 2019
By
Community NewsDistributed SQLHow It WorksHow ToPostgreSQLYugabyteDB

YugabyteDB Engineering Update – Dec 19, 2019

We are pleased to announce that YugabyteDB 2.0.8 is live!  You can read the official release notes of this and previous versions here. This release is shipping with 12 new enhancements and fixes.

What’s YugabyteDB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. Yugabyte’s SQL API (YSQL) is PostgreSQL wire compatible.

YSQL Changes

  • Enable client-to-server TLS encryption for the postgres process in case use_client_to_server_encryption is set to true.

…

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