Databases

Announcing YugabyteDB 2.6

Announcing YugabyteDB 2.6

Yugabyte is on a mission to build the default database for cloud native applications and simplify operational data infrastructure. Our latest release, YugabyteDB 2.6, is a big step forward towards that goal. YugabyteDB 2.6 includes significant enhancements to the open source database and our self-managed DBaaS offering, Yugabyte Platform. These enhancements, including point in time recovery (PITR), default encryption in transit, availability of Yugabyte Platform on Microsoft Azure, Red Hat OpenShift, and VMware Tanzu, and Yugabyte Platform high availability,

Read more

YugabyteDB Open Source Community Spotlight – July 2021

YugabyteDB Open Source Community Spotlight – July 2021

The Yugabyte community is always active and its members are constantly having interesting conversations and making valuable contributions. We spotlight members of the community to recognize their contributions to making the Yugabyte community a great place.

Radek Gruchalski, Managing Director & Software Engineer @ Klarrio GmbH

GitHub: https://github.com/radekg/, LinkedIn: https://linkedin.com/in/radgruchalski,

Blog: https://gruchalski.com/

If you’re on the Yugabyte community Slack often,

Read more

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

YugabyteDB is PostgreSQL compatible. It uses the same protocol and SQL layer as PostgreSQL. This makes YugabyteDB compatible with a majority of database tools, because PostgreSQL is the most popular open source database on the planet. Here is an example with Arctype, a user-friendly collaborative SQL client to query and visualize data.

Setting up a database connection

1. I went to https://arctype.com/ and downloaded the client for Windows.

2.

Read more

Distributed SQL Tips and Tricks – July 9th, 2021

Distributed SQL Tips and Tricks – July 9th, 2021

Welcome back to our bi-weekly tips and tricks blog where I have the pleasure of recapping some distributed SQL questions from around the Internet. This blog series would not be possible without all of the behind the scenes and community work done by YugabyteDB members such as Dorian Hoxha and Frits Hoogland. All of us here at Yugabyte also have to thank our incredible user community for their work with the technology,

Read more

Multi-Region YugabyteDB Deployments on Kubernetes with Istio

Multi-Region YugabyteDB Deployments on Kubernetes with Istio

This blog post is written by guest author Bhavin Gandhi, Software Engineer at InfraCloud Technologies, Inc., in collaboration with teams at Yugabyte. InfraCloud helps startups, SMBs, and enterprises scale by adopting cloud native technologies.

As organizations deploy applications across multiple cloud regions to better meet user demand and comply with regulations such as GDPR, there is a need to distribute data across geographic regions.

Read more

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

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

Migrating MySQL to YugabyteDB Using pgloader

Migrating MySQL to YugabyteDB Using pgloader

We understand that database migrations can be painful. We have helped users successfully migrate from MySQL to YugabyteDB, a PostgreSQL-compatible distributed SQL database. A very popular tool to accomplish this task is pgloader. In this post, we will cover how to migrate both your MySQL schema as well as data to YugabyteDB.

Prerequisites

Before starting the migration there are a few prerequisites you’ll need to address.

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

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