The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

July 27, 2021

Geo-Distribution in YugabyteDB: Engineering Around the Physics of Latency

Customers today expect always-on, highly responsive access to services wherever they are in the world. This is driving businesses to deploy globally distributed applications that deliver better customer experiences. Moving to a geo-distributed database is a key part of this. Moving data closer to where the end-users are enables lower latency access. Geo-distribution can make the data service resilient to zone and region failures in the cloud. Recent adverse weather conditions and data center accidents have underscored the need for this.

…

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

July 23, 2021

By Franck Pachot

Distributed SQL How To PostgreSQL

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.

…

Getting Started with the Kafka Connect for YugabyteDB (beta)

July 21, 2021

By Suranjan Kumar

Apache Kafka How To

Getting Started with the Kafka Connect for YugabyteDB (beta)

Kafka Connect is a popular tool for scaling and reliably streaming data between Apache Kafka and other data systems. It ships with a JDBC Sink which is used to insert data from Kafka to a database. Although the default JDBC Sink is good for many popular RDBMS it isn’t optimized for distributed SQL databases that provide linear scalability and high availability like YugabyteDB.

In our earlier blog introducing YugabyteDB 2.7,

…

Distributed SQL Summit Asia Recap: How Xignite Delivers Financial Data at Scale

July 16, 2021

By Dillon Pinto

Databases Distributed SQL How To

Distributed SQL Summit Asia Recap: How Xignite Delivers Financial Data at Scale

At Distributed SQL Summit Asia, Qin Yu – VP, Engineering, Xignite – presented a talk on how Xignite uses YugabyteDB to power its technology infrastructure to meet the current and future data needs of its financial services and fintech customers.

Xignite – A pioneer in market data innovation

Xignite is on a mission of “making market data easy.” It does this by offering a cloud-based Market Data Management Solution that aggregates and manages market data in the cloud,

…

Customer Chat with Paul Gaffney of Kohl’s

July 14, 2021

By Suda Srinivasan

Customers Distributed SQL YugabyteDB

Customer Chat with Paul Gaffney of Kohl’s

A few weeks ago, Yugabyte CEO Bill Cook and I had the pleasure of speaking with Paul Gaffney, the CTO and Chief Supply Chain Officer of Kohl’s during a virtual fireside chat as part of our Catalysts of Change series. Paul is a visionary tech leader with an extensive track record of driving technology change and innovation at companies like Dick’s Sporting Goods, The Home Depot, and AAA of Northern California,

…

Distributed SQL Tips and Tricks – July 9th, 2021

July 9, 2021

By Marko Rajcevic

Databases Distributed SQL How To

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,

…

Multi-Region YugabyteDB Deployments on Kubernetes with Istio

July 2, 2021

By Bhavin Gandhi

Databases Distributed SQL Kubernetes

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.

…

Auto-Balancing Data in YugabyteDB, a Distributed SQL Database

June 29, 2021

By Sanket Kedia

Databases Distributed SQL How To

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.

…

Deploy a Real-Time Polling App with Hasura Cloud and YugabyteDB Managed

June 23, 2021

By Nikhil Chandrappa

Distributed SQL GraphQL How To YugabyteDB Managed

Deploy a Real-Time Polling App with Hasura Cloud and YugabyteDB Managed

Hasura is a leading vendor in the GraphQL ecosystem, offering a powerful alternative to REST for building microservices and mobile applications. Hasura’s open source GraphQL Engine connects to your database and instantly auto-generates a production-ready GraphQL API backend. YugabyteDB, the open source distributed SQL database, is a perfect complement to GraphQL giving you horizontal scalability, fault tolerance, and global data distribution in a single system. YugabyteDB eliminates many of the scaling and resilience limitations of a traditional monolithic RDBMS.

…

YugabyteDB and Hasura Make it Easier to Build Complex, Global Applications

June 23, 2021

By Gavin Johnson

Company News Distributed SQL Partners YugabyteDB Managed

YugabyteDB and Hasura Make it Easier to Build Complex, Global Applications

We partnered with Hasura to build an integration between the YugabyteDB Managed database and Hasura Cloud and to make building complex, global applications easier. Read the blog to learn more.

The Distributed SQL Blog

Learn More to Accelerate Your Retail Business