Start Now

Category: Distributed SQL

YugabyteDB Community Update, Tricks and Tips – Nov 22, 2019

YugabyteDB Community Update, Tricks and Tips – Nov 22, 2019

Welcome to this week’s community update where we recap a few interesting questions that have popped up in the last week or so on the YugabyteDB Slack channel, the Forum, GitHub or Stackoverflow. We’ll also review upcoming events, new blogs and documentation that has been published since the last update. Ok, let’s dive right in:

How do data compactions work in YugabyteDB?

Read more

YugabyteDB Engineering Update – Nov 20, 2019

YugabyteDB Engineering Update – Nov 20, 2019

We are pleased to announce that YugabyteDB 2.0.5 is live!  You can read the offical release notes of this and previous versions here. This release is shipping with over 40 new enhancements and bug 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. YugabyteDB’s SQL API (YSQL) and drivers are PostgreSQL wire compatible

YSQL changes

  • Change HINT text for unsupported “alter procedure/function”.

Read more

Announcing YugabyteDB on Crossplane, the Open Source Multicloud Control Plane

Announcing YugabyteDB on Crossplane, the Open Source Multicloud Control Plane

We are excited to announce that YugabyteDB is now available as a self-managed database service on Crossplane, the open-source multicloud control plane. Built on top of our recent Rook Kubernetes Operator for YugabyteDB, this offering makes YugabyteDB one of the first distributed SQL databases available on Crossplane.

Benefits of the Joint Solution

With Crossplane as the single control plane, users can provision and manage multiple YugabyteDB clusters across Google Kubernetes Engine,

Read more

YugabyteDB Community Engineering Update, Tricks and Tips – Nov 8, 2019

YugabyteDB Community Engineering Update, Tricks and Tips – Nov 8, 2019

Welcome to this week’s community update where we recap a few interesting questions that have popped up in the last week or so on the YugabyteDB Slack channel, the Forum, GitHub or Stackoverflow. We’ll also review upcoming events, new blogs and documentation that has been published since the last update. Ok, let’s dive right in:

What effect does TTL have on performance?

Read more

YugabyteDB Engineering Update – Oct 30, 2019

YugabyteDB Engineering Update – Oct 30, 2019

We are pleased to announce that YugabyteDB 2.0.3 is live! You can read the release notes of this and previous versions here. This release is shipping with 50 new enhancements and bug 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. YugabyteDB’s SQL API (YSQL) and drivers are PostgreSQL wire compatible

[#1845] YSQL: Support for TLS Server to Server Encryption

TLS encryption is now supported between yb-master and yb-tserver processes.

Read more

The Benefit of Partial Indexes in Distributed SQL Databases

The Benefit of Partial Indexes in Distributed SQL Databases

If a partial index is used, instead of a regular one, on a nullable column—where only a small fraction of the rows have not null values for this column—then the response time for inserts, updates, and deletes can be shortened significantly. As a bonus, the response times for single row selects shorten a little bit too. This post explains what a partial index is, shows how to create one, describes the canonical use case that calls for a partial index,

Read more

How YugabyteDB Scales to More than 1 Million Inserts Per Sec

How YugabyteDB Scales to More than 1 Million Inserts Per Sec

There are a number of well-known experiments where eventually-consistent NoSQL databases were scaled out to perform millions of inserts and queries. Here, we do the same using YSQL, YugabyteDB’s PostgreSQL-compatible, strongly-consistent, distributed SQL API. We created a 100-node YugabyteDB cluster, ran single-row INSERT and SELECT workloads with high concurrency – each for an hour and measured the sustained performance (throughput and latency). This post details the results of this experiment as well as highlights the key aspects of the YugabyteDB architecture that makes it fit for such high-volume ingest workloads.

Read more

9 Techniques to Build Cloud-Native, Geo-Distributed SQL Apps with Low Latency

9 Techniques to Build Cloud-Native, Geo-Distributed SQL Apps with Low Latency

This post is an in-depth look at the various techniques that applications needing low latency and high availability can leverage while using a geo-distributed SQL database like YugabyteDB so that the negative impacts of a high-latency, unreliable Wide Area Network (WAN) are minimized.

Geo-Distributed SQL is the Future of RDBMS

Enterprises are increasingly moving to cloud native applications powered by microservices architecture. These applications run on elastic cloud infrastructure such as serverless frameworks and containers.

Read more

How to: PostgreSQL Fuzzy String Matching In YugabyteDB

How to: PostgreSQL Fuzzy String Matching In YugabyteDB

Before analyzing a large dataset that contains textual information, it’s important to scrub it and eliminate duplicates when necessary. To remove duplicates, you may need to compare strings referring to the same thing, but that may be written slightly different, have typos or were misspelled. Alternatively, you might need to join two tables on a column (let’s say on company name), and these can appear slightly different in both tables.

Fuzzy String Matching (or Approximate String Matching) is the process of finding strings that approximately match a pattern.

Read more

YugabyteDB Engineering Update – Oct 14, 2019

YugabyteDB Engineering Update – Oct 14, 2019

We are pleased to announce that YugabyteDB 2.0.1 is live! You can read the release notes of this and previous versions here. This release is shipping with 36 new enhancements and bug 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) and drivers are PostgreSQL wire compatible

[#1851] YSQL: Support for Pushdown of Aggregate Queries

With the YCQL API,

Read more

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now