Eric Pratt, Author at The Distributed SQL Blog

Databases Distributed SQL Ecosystem Integrations How To Kubernetes Open Source

December 15, 2021

Getting Started with YugabyteDB, Temporal, and the Temporal-Maru Benchmarking Tool

“Does YugabyteDB integrate with temporal.io?” is a common question from developers. Temporal enables technologists to build highly reliable applications without having to worry about all the edge cases. Developers use Temporal not just because it is an open-source solution. They also use it to build workflows in code and operate resilient applications using developer-friendly primitives.

Temporal supports independent horizontal scaling of each of the Temporal Server services: Frontend,

…

Databases Distributed SQL Docker How To

June 11, 2021

by Eric Pratt

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.

…

Databases Distributed SQL How To

February 4, 2021

by Eric Pratt

Secondary Index Migration in YugabyteDB

Introduction

YugabyteDB has a great feature in strongly consistent secondary indexes. I have been asked a few times now about how to modify existing indexes. These can range from adding another column to the index or adding another column to the INCLUDE clause. The big question at the end of the day is: how to do this without having to take downtime on the indexes?

…