YugaByte DB

The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

How It Works How To Kubernetes
September 11, 2019
by Andrew Nelson

Best Practices and Recommendations for Distributed SQL on Kubernetes

Yugabyte and Kubernetes have very complementary design principles because they both rely on an extensible and flexible API layer, as well as a scale-out architecture for performance and availability. In this blog post we’ll look at best practices and recommendations when choosing Kubernetes as the cluster foundation for a distributed SQL system. This will begin with a review of relevant architectural decisions of the Yugabyte DB.

…

Read More
Distributed SQL Ecosystem Integrations PostgreSQL
August 23, 2019
by Jimmy Guerrero

Getting Started with TablePlus on a Distributed SQL Database

If you’re a database developer, you already understand the importance of a tool to manage your databases. Whether it is for creating schemas, ad-hoc querying, backups, or diving deeper to troubleshoot a database issue, a database tool can make your life much easier and increase your productivity. In a previous posts we covered how to get started with DBeaver,

…

Read More
Community News Company News
August 21, 2019
by Andrew Nelson

Andrew Nelson: Why I Joined YugaByte as a Developer Advocate

I recently joined YugaByte as a Developer Advocate focused on Kubernetes. I will focus on the usability and extensibility of YugaByte DB as a data platform within the Kubernetes and public cloud ecosystem. However, in broader terms, I will be able to leverage YugaByte DB as a cloud-native database that can easily deployed in multi-cloud environments. There are a few things I am looking forward to in my new role:

  • Working for another fast-growing startup
  • Being able to leverage my skills in Kubernetes
  • Learning more about a next-generation database at the ground floor
  • Working for an open-source company

Early Years

When I was graduating from college with a degree in Software Engineering,

…

Read More
ACID Transactions Distributed SQL How It Works
August 20, 2019
by Karthik Ranganathan

Low Latency Reads in Geo-Distributed SQL with Raft Leader Leases

Note: This post contains interactive animations that explain how some of these complex algorithms work. Please view this post in a suitable media (at least 1000px by 600px screen resolution) for best results.

In this blog post, we are going to dive deep into the read performance of Raft – why read performance can take a hit and how it can be improved using leader leases.

…

Read More
Distributed SQL How To PostgreSQL
August 14, 2019
by Jimmy Guerrero

Getting Started with PGAdmin on a Distributed SQL Database

If you’re a database developer, you already understand the importance of a tool to manage your databases. Whether it is for creating schemas, ad-hoc querying, backups, or diving deeper to troubleshoot a database issue, a database tool can make your life much easier and increase your productivity. In a previous post we covered how to get started with DBeaver,

…

Read More
Community News Company News Distributed SQL YugabyteDB 1.3
August 8, 2019
by Jimmy Guerrero

YugaByte DB Engineering & Community Update – Aug 9, 2019

We are pleased to announce that YugabyteDB 1.3.1 is live! You can read the release notes of this and previous versions here. This release is shipping with 22 new features, enhancements and bug fixes. This release also brings us closer to our 2.0 release which will be shipping in a few weeks. The flagship feature in 2.0 will be the YSQL API becoming generally available.

…

Read More
Distributed SQL Ecosystem Integrations PostgreSQL
August 1, 2019
by Jimmy Guerrero

Getting Started with SQL Workbench/J on a Distributed SQL Database

Although most databases ship with a command line utility to administer the instance, these utilities often come with a steep learning curve. If using the command line and learning sometimes arcane syntax makes you uncomfortable, there are graphical tools that can help you speed up many daily DBA tasks. In fact, you can find a comprehensive list of tools on the PostgreSQL wiki here.

…

Read More
Distributed SQL How To PostgreSQL
July 30, 2019
by Jimmy Guerrero

PostgreSQL How To: Installing the Chinook Sample DB on a Distributed SQL Database

In this post we are going to walk you through how to download and install the PostgreSQL version of the Chinook sample DB on the YugaByte DB distributed SQL database with a replication factor of 3.

What’s YugaByte DB? It’s a high performance distributed SQL database for global, internet-scale apps. YugaByte DB is a PostgreSQL-compatible database.

…

Read More