Start Now

Category: How To

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

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

Distributed SQL Databases on Kubernetes Webinar Recap

Distributed SQL Databases on Kubernetes Webinar Recap

We recently presented the live webinar on how to run distributed SQL databases on Kubernetes. This session focused on the design of stateful workloads in Kubernetes, the architecture and deployment of YugabyteDB in Kubernetes, and best practices to run cloud native stateful workloads with a real-world example.

In this blog post, we provide the playback recording and slides, and recap some highlights from the presentation.

If you have additional questions about running the YugabyteDB distributed SQL database on Kubernetes,

Read more

Distributed SQL Tips and Tricks – April 21, 2021

Distributed SQL Tips and Tricks – April 21, 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 get into it:

Importing a Large Table Using Smaller Transactions

When first playing around with YugabyteDB many users import existing data from other databases,

Read more

Creating a Centralized Consent Database for 80M Citizens Across 100k+ Companies

Creating a Centralized Consent Database for 80M Citizens Across 100k+ Companies

At this year’s Distributed SQL Summit Asia 2021, Cetin Yalcin Gulec, Shivam Arora, and Cem Aladogan from Softtech presented the talk, “Creating a Centralized Commercial Consent Database for 80M Citizens Across 100k+ Companies.” In this post you can find a summary of the talk, some of the presentation highlights, as well as links to this talk and others from the event.

A Quick Introduction to Softtech

Cem kicked things off with a quick introduction to Softtech.

Read more

Distributed SQL Tips and Tricks – April 7, 2021

Distributed SQL Tips and Tricks – April 7, 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 since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channelForumGitHub, or Stack Overflow. Let’s dive right in:

How to create client certs and propagate those on the yb-nodes using the YSQL API

There was a behavior change for the YSQL API after YugabyteDB version 2.5.2 where client certs are no longer required to authenticate to a TLS enabled cluster.

Read more

Getting Started with DBeaver EE and YugabyteDB Cloud Query Language (YCQL)

Getting Started with DBeaver EE and YugabyteDB Cloud Query Language (YCQL)

Developers and DBAs widely use SQL editors to design database schemas, write ad hoc queries, troubleshoot, and manage the security policies and database users. For these reasons, it is essential for us as builders of YugabyteDB to bring native integration with popular database tools like DBeaver.

If you are following the YugabyteDB project and our blog posts, you’ll know YugabyteDB currently supports two APIs – YSQL and YCQL (NoSQL) – for querying the database.

Read more

Using the PostgreSQL Recursive CTE – Part Two

Using the PostgreSQL Recursive CTE – Part Two

Computing Bacon Numbers for actors listed in the IMDb

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

Read more

Using the PostgreSQL Recursive CTE – Part One

Using the PostgreSQL Recursive CTE – Part One

Traversing an employee hierarchy

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

Read more

Measuring the Performance Impact of TLS Encryption Using TPC-C

Measuring the Performance Impact of TLS Encryption Using TPC-C

Organizations need to protect their data, especially the personal data entrusted to them from their users and customers. In order to do so, the data transferred by a database over the network needs to be secure. This is often accomplished using TLS encryption, an encryption protocol that secures communication across a network. When secured by TLS, a communication between a client and a server can enable the two parties to identify one another (preventing any impersonation),

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