Download for Free
Start Now
mobile-nav

The Distributed SQL Blog

YugabyteDB Community Update, Tricks and Tips – Dec 13, 2019
December 13, 2019
By
Community NewsDatabasesDistributed SQLHow It WorksPostgreSQL

YugabyteDB Community Update, Tricks and Tips – Dec 13, 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, Forum, GitHub or Stackoverflow. We’ll also review upcoming events, new blogs and documentation. Ok, let’s dive right in:

How best to configure clusters across deployment types

Ava over on StackOverflow asked how to best setup configurations for different deployment models like single AZ,

…

Read more

YugabyteDB Engineering Update – Dec 9, 2019
December 9, 2019
By
Community NewsDatabasesDistributed SQLPostgreSQLYugabyteDB

YugabyteDB Engineering Update – Dec 9, 2019

We are pleased to announce that YugabyteDB 2.0.7 is live!  You can read the official release notes of this and previous versions here. This release is shipping with almost 30 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) is PostgreSQL wire compatible

YugabyteDB 2.0.7 Release Notes

YSQL

  • Transparent read restarts for general queries.

…

Read more

YugabyteDB Tricks and Tips – Dec 6, 2019
December 6, 2019
By
Community NewsWeek in Review

YugabyteDB Tricks and Tips – Dec 6, 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:

Do you have any plans to support UTF8MB4 like MySQL does?

…

Read more

Getting Started with PostgreSQL’s Row Level Security in YugabyteDB
December 3, 2019
By
Distributed SQLHow ToPostgreSQL

Getting Started with PostgreSQL’s Row Level Security in YugabyteDB

In this blog post we are going to introduce you to how PostgreSQL’s row level security feature works in the latest YugabyteDB 2.0.6 release. YugabyteDB supports RLS and a host of other security and encryption features “out-of-the-box,” as part of the open source distribution.

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.

…

Read more

Using Stored Procedures in Distributed SQL Databases
December 2, 2019
By
Distributed SQLHow It WorksHow ToPostgreSQL

Using Stored Procedures in Distributed SQL Databases

These days, most monolithic SQL databases support stored procedures. This support first emerged in commercially available offerings in the late nineteen eighties. However, stored procedure support is not yet standard in distributed SQL databases. In fact, YugabyteDB is just one of two in this category—supporting stored procedures written in PostgreSQL’s PL/pgSQL. (Aurora also supports stored procedures.) This post recaps the case for stored procedures that motivated their introduction all those years ago. And it describes a performance experiment that measures one of the benefits brought by using stored procedures: the reduction in client-server round trips for multi-statement business transactions.

…

Read more

YugabyteDB Engineering Update – Nov 27, 2019
November 27, 2019
By
Community NewsDistributed SQLPostgreSQLYugabyteDB

YugabyteDB Engineering Update – Nov 27, 2019

We are pleased to announce that YugabyteDB 2.0.6 is live!  You can read the official release notes of this and previous versions here. This release is shipping with almost 30 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

YSQL changes

  • Transparent read restarts for general queries.

…

Read more

How Plume Handled Billions of Operations Per Day Despite an AWS Zone Outage
November 26, 2019
By
DatabasesDistributed SQLHow It WorksPostgreSQL

How Plume Handled Billions of Operations Per Day Despite an AWS Zone Outage

Enterprises deploy YugabyteDB clusters across multiple availability zones (AZs) in order to ensure continuous availability of their business-critical services even when faced with cloud infrastructure failures like zone outages. On November 12, 2019, there was one such outage of an entire availability zone in the eu-central-1 region of AWS. This was reported on the AWS status page on that day, along with an official update.

In this post, we are going to look at how a Yugabyte Platform customer,

…

Read more

YugabyteDB Community Update, Tricks and Tips – Nov 22, 2019
November 22, 2019
By
Community NewsDistributed SQLHow It WorksPostgreSQL

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
November 20, 2019
By
Community NewsDistributed SQLPostgreSQLYugabyteDB

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
November 18, 2019
By
Community NewsDistributed SQLEcosystem IntegrationsHow ToKubernetesOpen Source

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

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