Franck Pachot, Author at Yugabyte

Databases Distributed SQL How It Works Open Source

June 17, 2022

Distributed SQL Sharding: How Many Tablets, and at What Size?

The first answer to this question is the usual “it depends“. The second answer, thanks to YugabyteDB’s auto-splitting feature and distributed SQL sharding principles, is “don’t worry, this is managed automatically.”

However, it’s still important to understand how sharding works, how to handle corner cases correctly, and how to split tablets to save resources. In this post, we’ll explore how sharding works in YugabyteDB by defining the initial quantity and size of tablets.

…

Databases Distributed SQL Open Source PostgreSQL

March 10, 2022

By Franck Pachot

Distributed SQL Deep Dive: Inside YugabyteDB’s Two-Layer Architecture

YugabyteDB is a 100% open source, distributed SQL database system. This single phrase expresses two distinct notions: a SQL database system, and a distributed database system. Historically, these notions were mutually exclusive. But current technology allows a single system to implement both notions. YugabyteDB does this with its two-layer architecture: an extensible query processing layer and a distributed document store.

In this blog post, we explain how YugabyteDB’s two-layer architecture works and compare it against other popular databases.

…

Databases Distributed SQL

January 19, 2022

By Franck Pachot

YugabyteDB Migration: What About Those 19 Oracle Features I Thought I Would Miss?

In 2019, I gave a presentation with the title, “19 features you will miss if you leave Oracle.” The talk focused on features used every day with Oracle—and those that may not be available in other databases. However, the goal of this presentation was not to influence any decision or outcome.

Migrating from a commercial database is not about covering a full set of features. It’s a strategy to stay in control of the software that processes and stores enterprise data.

…

Cloud Providers Databases Distributed SQL Open Source

December 22, 2021

By Franck Pachot

Multi-Cloud Distributed SQL: Avoiding Region Failure with YugabyteDB

As Amazon CTO Werner Vogels often reminds us: ”Everything fails, all the time”. This means any component of the infrastructure will fail at some point. However, with more and more software being deployed in the cloud, today’s infrastructure must provide redundancy. In addition, the applications that sit on top of it must provide continuity over failures.

This involves database replication when the failure concerns data in motion. But there are different levels of failures and different protection technologies.

…

Databases Distributed SQL

November 19, 2021

By Franck Pachot

Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

A distributed SQL database provides a service where you can query the global database without knowing where the rows are. You connect to any node, without having to know the cluster topology. You query your tables, and the database will determine the best access to your data, whether it’s close to your client or geographically distant.

The organization of data, whether co-located or partitioned, is the most important consideration for high performance, high availability,

…

Databases Distributed SQL

October 14, 2021

By Franck Pachot

How a Distributed SQL Database Boosts Secondary Index Queries with Index Only Scan

A distributed SQL database reads from remote nodes, which increases the need for optimal data access. From my 20 years of experience as a database consultant, here is the most overlooked optimization technique for any database that supports it: performance-critical queries should find their columns from the index structure, without making extra hops to the table.

Many myths against SQL, such as “joins don’t scale” or “analytic queries need a separate column store”,

…

How To Kubernetes

September 3, 2021

By Franck Pachot

YugabyteDB on OKE (Oracle Cloud Kubernetes)

We have documented how to install YugabyteDB on the main cloud providers (https://docs.yugabyte.com/latest/deploy/public-clouds). And when I joined Yugabyte, many friends from the oracle community asked me about the Oracle Cloud (OCI).

In the Oracle Cloud there are 2 ways to run containers:

Do-It-Yourself with IaaS (Infrastructure as a Service)
Obviously, you can provision some compute instances (and network and storage) running Docker and install Kubernetes (or other orchestration).

…

Distributed SQL How To PostgreSQL

July 23, 2021

By Franck Pachot

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.