The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Part 2: Airflow DAGs for Migrating PostgreSQL Data to Distributed SQL

May 21, 2020

Databases Distributed SQL How To Open Source PostgreSQL

Part 2: Airflow DAGs for Migrating PostgreSQL Data to Distributed SQL

Welcome to part two of our series on how to integrate Apache Airflow and YugabyeDB. In part one we showed you how to get Airflow configured to use YuagbyteDB as a backend. In this second post we’ll show you how to build an Airflow workflow that will migrate data between PostgreSQL and YugabyteDB.

What’s YugabyteDB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner.

…

Part 1: Deploying a Distributed SQL Backend for Apache Airflow on Google Cloud

May 20, 2020

By Jimmy Guerrero

Databases Distributed SQL Google Cloud Platform How To Kubernetes Open Source PostgreSQL

Part 1: Deploying a Distributed SQL Backend for Apache Airflow on Google Cloud

Apache Airflow is a popular platform for programmatically authoring, scheduling, and monitoring workflows. Airflow has been deployed by companies like Adobe, Airbnb, Etsy, Instacart, and Square. The advantage of defining workflows as code is that they become more maintainable, versionable, testable, and collaborative. Airflow is used to author these workflows as directed acyclic graphs (DAGs) of tasks. Airflow’s scheduler executes your tasks on an array of workers while following the specified dependencies.

…

Building the Cloud Native Future – Why I Joined Yugabyte

May 19, 2020

By Bill Cook

Company News Databases Distributed SQL

Building the Cloud Native Future – Why I Joined Yugabyte

I am incredibly proud and honored to be taking on a new role as CEO of Yugabyte. When I started talking with Yugabyte’s founders, Karthik, Kannan and Mikhail, about joining the Yugabyte executive team, I was hooked. I immediately felt a strong alignment between my experiences and goals, and the opportunities ahead at Yugabyte. A lot goes into finding the right role at the right time, but three things in particular really stood out and inspired me to join Yugabyte.

…

May 19, 2020

By Kannan Muthukkaruppan

Company News Databases Distributed SQL

Welcome Bill Cook as Yugabyte’s New CEO

I’m excited to welcome Bill Cook to the team as the new CEO of Yugabyte! Bill is an extraordinary leader with an exemplary record of building and scaling enterprise infrastructure companies. Bill joins us from Pivotal Software where, as co-founder and President, he was part of the leadership team that helped solidify the company as the gold standard in cloud native software development and led Pivotal through its IPO and subsequent merger with VMware in 2019.

…

Follow-up: Postgres Conference Webinar – Introduction to YugabyteDB

May 18, 2020

By Bryn Llewellyn

Databases Distributed SQL PostgreSQL

Follow-up: Postgres Conference Webinar – Introduction to YugabyteDB

I delivered the webinar “YugabyteDB: a distributed PostgreSQL database” last week. It was hosted by Postgres Conference in a series that they’d arranged so that the speakers who’d been selected to speak at their big annual conference in New York City in March could reach their audience. COVID-19 brought that event’s cancellation. This brief post tells you where you can find the edited videorecording and the PDF version of the slides that I used. It also gives me the chance to answer the couple of questions from attendees that shortness of time prevented me from answering during the webinar.

…

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

May 14, 2020

By Jimmy Guerrero

Compare and contrast Databases Distributed SQL PostgreSQL

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

This post explores the compatibility of YugabyteDB with Oracle and PostgreSQL by examining 15 different Oracle features and their PostgreSQL equivalents highlighted in Roland Takacs’ blog post “Oracle vs PostgreSQL: First Glance.” As a PostgreSQL-compatible distributed SQL database, YugabyteDB offers a broad range of SQL features, making it an interesting choice for those looking to migrate from Oracle to a modern tech stack.

New 451 Research Report: Distributed SQL

May 13, 2020

By Michelle Brinich

Community News Company News Databases Distributed SQL

New 451 Research Report: Distributed SQL

Today, we are releasing a new 451 Research report: Distributed SQL, An Enabler for Globally Consistent Transactional Workloads. The report, which we commissioned, explores how database systems, sitting at the heart of the enterprise, play a key role in digital transformation initiatives.

At Yugabyte, we partner with our customers daily to help accelerate their digital initiatives, and we get a front-row seat as their business-critical applications scale to billions and billions of operations per day,

…

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables

May 12, 2020

By Neha Deodhar

Databases Distributed SQL How It Works Open Source PostgreSQL YugabyteDB

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables

In YugabyteDB v2.1, we released a new feature in beta: colocated tables. And we were excited to announce the general availability of colocated tables, along with many other exciting new features, in YugabyteDB 2.2. In this post, we’ll explain what colocated tables are in a distributed SQL database, why you would need them, and how to get started.

Getting Started with Distributed SQL on Azure Kubernetes Service

May 11, 2020

By Jimmy Guerrero

Cloud Providers Containers Databases Distributed SQL How To Kubernetes Microsoft Azure

Getting Started with Distributed SQL on Azure Kubernetes Service

Microsoft’s Azure Kubernetes Service (AKS) offers a highly available, secure, and fully managed Kubernetes service for developers looking to host their applications on containers in the cloud. AKS features elastic provisioning, an integrated developer experience for rapid application development, enterprise security features, and the most available regions of any cloud provider.

YugabyteDB is a natural fit for AKS because it was designed to support cloud native environments since its initial design.

…

May 8, 2020

By Dorian Hoxha

Community News Databases Distributed SQL How To Open Source PostgreSQL

Distributed SQL Tips and Tricks – May 8, 2020

Welcome to this week’s 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 channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

How can I connect YugabyteDB with Apache Spark?

…

The Distributed SQL Blog

Learn More to Accelerate Your Retail Business