Start Now

Distributed SQL Tips and Tricks – Feb 7, 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:

Does YugabyteDB have an in-memory storage engine?

Read more

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

YugabyteDB Engineering Update – Jan 29, 2020

We are pleased to announce that YugabyteDB 2.0.11 is now live!  You can read the official release notes of this and previous versions here. These two releases shipped with a combined 30+ 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 API

  • Fix txn conflict issues due to absence of cotable ID in DocKey.

Read more

Distributed SQL vs. NewSQL

Our previous post in this series “What is Distributed SQL?” highlights the common architectural principles as well as the business benefits of distributed SQL databases. In this post, we compare distributed SQL databases against NewSQL databases so that we can better understand their differences.

Before we dive into NewSQL, it is important to understand why NoSQL databases like MongoDB and Apache Cassandra came into prominence in the mid-to-late 2000s. They too were originally positioned as alternatives to SQL databases but fell short of their goal.

Read more

Distributed SQL Tips and Tricks – Jan 24, 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 is the performance impact of deleting tombstones in YugabyteDB?

Read more

How to Migrate the Sakila Database from MongoDB to Distributed SQL with Studio 3T

Whether it’s consolidation, or modernizing your data infrastructure, data migration is a serious undertaking. Without sufficient planning, countless hours will be spent constructing the proper schema in the target database, and picking the proper ETL tools to help move the data. In this blog we will show you how to migrate the Sakila demo database from MongoDB to a YugabyteDB cluster using the Studio 3T tool.

Why migrate to a distributed SQL database from MongoDB?

Read more

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

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.

What’s YugabyteDB? It is an open source,

Read more

Distributed SQL Tricks and Tips – Jan 10, 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.

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.

Read more

YugabyteDB Engineering Update – Jan 8, 2020

We are pleased to announce that YugabyteDB 2.0.9 launched over the holidays and YugabyteDB 2.0.10 is now live!  You can read the official release notes of this and previous versions here. These two releases shipped with a combined 36 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.

Read more

Get started in any cloud, container or data center