Distributed SQL

Auto-Balancing Data in YugabyteDB, a Distributed SQL Database

Auto-Balancing Data in YugabyteDB, a Distributed SQL Database

YugabyteDB is a distributed, fault tolerant and highly available database with extremely low latencies for reads and writes. Data in YugabyteDB is sharded, replicated and balanced across multiple nodes that can potentially be in different availability zones, regions or even clouds for that matter. In this blog post, we look at how data balancing happens in YugabyteDB and some of the key features of YugabyteDB’s “Cluster Balancer.”

The cluster balancer runs once every second.

Read more

Deploy a Real-Time Polling App with Hasura Cloud and YugabyteDB Managed

Deploy a Real-Time Polling App with Hasura Cloud and YugabyteDB Managed

Hasura is a leading vendor in the GraphQL ecosystem, offering a powerful alternative to REST for building microservices and mobile applications. Hasura’s open source GraphQL Engine connects to your database and instantly auto-generates a production-ready GraphQL API backend. YugabyteDB, the open source distributed SQL database, is a perfect complement to GraphQL giving you horizontal scalability, fault tolerance, and global data distribution in a single system. YugabyteDB eliminates many of the scaling and resilience limitations of a traditional monolithic RDBMS.

Read more

Reads in YugabyteDB – Tuning Consistency, Latency and Fault Tolerance

Reads in YugabyteDB – Tuning Consistency, Latency and Fault Tolerance

Introduction

YugabyteDB is built primarily to be a CP database per the CAP theorem. It supports two interfaces – YSQL for SQL workloads and YCQL for Cassandra-like workloads. In this blog, we will primarily talk about the YCQL interface. When an application interacts with the database using the YCQL interface, the writes are always consistent and reads are consistent by default. When this level of consistency is not required, YugabyteDB supports two other types of reads:

1.

Read more

Distributed SQL Tips and Tricks – June 10th, 2021

Distributed SQL Tips and Tricks – June 10th, 2021

Welcome back to our bi-weekly 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 recently. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s dive in:

Connection Pooling with YugabyteDB

When looking to pool your connections with YugabyteDB many users take a look at PgBouncer,

Read more

The YugabyteDB Vagrant Box

The YugabyteDB Vagrant Box

Using Vagrant, anyone running Windows, Linux or Mac OS X can run and test drive a YugabyteDB cluster without the need to install and configure YugabyteDB. Plus, you can start over if you want to test something different in a matter of minutes, or scale up the cluster, etc.

Please mind that the Vagrant images are non-official images for demo and test purposes, and not configured nor representative for performance.

This is how it works (Mac OS X):

1.

Read more

Fine-Grained Control for High Availability: Increasing Node Failure Threshold

Fine-Grained Control for High Availability: Increasing Node Failure Threshold

The purpose of this blog post is to show how you can increase the failure threshold when a node goes down, which happens for a variety of reasons including hardware or network issues and most commonly maintenance. The failure threshold is the amount of time YugabyteDB would wait, after a node goes down, for it to potentially come back up. After reaching this threshold the physical data will begin to move from the dead node to other nodes in the cluster.

Read more

People and Potential: Why I Joined Yugabyte

People and Potential: Why I Joined Yugabyte

When I first started my graduate studies in databases in 2012, I remember reading a freshly-minted paper that was making big waves in the DB community: Spanner: Google’s Globally-Distributed Database. I remember being blown away by the scale of the problems being tackled. Synchronizing a globally-distributed database while maintaining a usable transaction latency seemed an impossible task, one that comes with challenges that only exist on the global scale. As a naive grad student,

Read more

The Next Chapter for Falarica – Building the Default Database for the Cloud

The Next Chapter for Falarica – Building the Default Database for the Cloud

Hi there…a big hello from all of us at Falarica!!!

It is with immense pleasure and great pride that we, Falarica.io, decided to join hands with Yugabyte to build great data products together. Thanks to the entire Yugabyte team for extending a very warm welcome to us. And of course a very big thank you to the entire Falarica team for their hard work in creating considerable value in a short span of time.

Read more

Distributed SQL Tips and Tricks – May 17th, 2021

Distributed SQL Tips and Tricks – May 17th, 2021

Welcome back to our bi-weekly 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 recently. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s dive in:

Setting Firewall Rules for Cloud Deployments

When deploying a YugabyteDB cluster on a cloud,

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