The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

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 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,

Read More

An Adventure in Multi-Cloud with Kubernetes and Distributed Data

At this year’s Distributed SQL Summit Asia 2021, Leon Kuperman from CAST AI presented the talk, “An Adventure in Multi-Cloud with Kubernetes and Distributed Data.”

Setting the Scene

CAST AI is an AI-driven cloud optimization platform for Kubernetes that helps companies cut their cloud bill and prevent downtime. In the presentation,

Read More

Building Resilient GraphQL Apps and Scaling Them to 1M Subscriptions

GraphQL provides a query language for APIs, giving UX developers autonomy over querying APIs and the database.

The advantages of using GraphQL for UX applications are well understood. GraphQL clients can retrieve only the data needed in the UI application. GraphQL provides a strong type system that avoids manual code parsing and data filtering that takes up precious processing cycles when rendering the UI to users.

Read More

Distributed SQL Summit Recap: The Future of Data Infrastructure, A Telco Roundtable

At the Distributed SQL Summit 2020, leaders and architects from notable enterprises in the telco industry joined us for a panel to discuss the future of software development, including important trends such as IoT, 5G, Edge, cloud, and their impact on data infrastructure. Our panelists included Puneet Devadiga from Rakuten Mobile, Hale Donertasli from Rakuten Mobile, Kartik Rallapalli from TracFone Wireless,

Read More

Monitoring YugabyteDB in Kubernetes with the Prometheus Operator and Grafana

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

Using the Prometheus Operator has become a common choice when it comes to running Prometheus in a Kubernetes cluster. It can manage Prometheus and Alertmanager for us with the help of CRDs in Kubernetes.

Read More

Service Mesh Era: Building Modern Apps with YugabyteDB and Istio

Microservices architectures are becoming the de facto way developers are thinking about how their applications are constructed. But security remains a top concern for many organizations. Given the general trends of the proliferation of threats within the production network and the increased points of privileged access, it is increasingly necessary to adopt a zero-trust network security approach for microservices architectures.

Read More

Presentation Recap: Kubernetes as a Universal Control Plane – Joe Beda, VMware

We were delighted to have Joe Beda, one of the original creators of Kubernetes, and Principal Engineer at VMware, give the opening keynote at this year’s 2020 Distributed SQL Summit. If you weren’t able to attend, here’s the summary and playback of his keynote presentation.

Kubernetes as a Universal Control Plane

Oftentimes systems start out with efficiency in mind (as Joe states,

Read More

Using Envoy Proxy’s PostgreSQL & TCP Filters to Collect Yugabyte SQL Statistics

Layer 7 proxies like NGINX and HAProxy have been popular since the mid-2000s. The term “proxy” refers to their role as an intermediary for the traffic between an application client and an application server. The “layer 7” classification comes from the fact that these proxies take routing decisions based on URLs, IPs, TCP/UDP ports, cookies, or any information present in messages sent over a layer 7 (aka application layer) networking protocol like HTTP and gRPC.

Read More