The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Using Ebean ORM with YugabyteDB

Ebean is a Java-based Object–Relational Mapping (ORM) application. It is more user-friendly and understandable than traditional ORM tools, such as Hibernate. It achieves this by employing a session-less design that eliminates the concepts of detached/attached beans as well as the difficulties related with flushing/clearing.

Even better, Ebean supports YugabyteDB, a 100% open source, distributed SQL database built to accelerate cloud native agility,

Read More

Five Benefits to Running a Distributed SQL Database in Kubernetes

A distributed SQL database is a single logical relational database deployed on a cluster of servers. The database automatically replicates and distributes data across multiple servers. These databases are strongly consistent and support consistency across availability and geographic zones in the cloud.

At a minimum, a distributed SQL database has the following characteristics:

  • A SQL API for accessing and manipulating data and objects
  • Automatic distribution of data across nodes in a cluster
  • Automatic replication of data in a strongly consistent manner
  • Support for distributed query execution so clients do not need to know about the underlying distribution of data
  • Support for distributed ACID transactions

But should you run a distributed SQL database in Kubernetes?

Read More

What Every Application Developer Needs to Know About Geo-Distributed Databases

I’ve been working with distributed systems, platforms, and databases for the last seven years. Back in 2015, many architects began using distributed databases to scale beyond the boundaries of a single machine or server. They selected such a database for its horizontal scalability, even if its performance remained comparable to a conventional single-server database.

Now, with the rise of cloud native applications and serverless architecture,

Read More

Securing YugabyteDB: Part 2 – Client-to-Server Encryption in Transit

In the first post in this series, we covered how to secure YugabyteDB’s internal RPC protocol using the TLS encryption protocol, also referred to as server-to-server encryption in transit. In this post, we secure the communication between SQL clients and the PostgresQL query interface of YugabyteDB, also called client-to-server encryption in transit. 

YugabyteDB—a 100% open source,

Read More

Achieving PCI DSS Compliance with YugabyteDB

Welcome back to our blog series about how different compliance and regulatory frameworks work and how YugabyteDB can be an essential part of a company’s compliance efforts. In this third installment, we focus on the PCI Security Standards Council’s Payment Card Industry Data Security Standard (PCI DSS). More specifically, we reveal how companies can use YugabyteDB to enable compliance with certain key PCI DSS requirements.

Read More

Automation Workflows: Using GitOps for YugabyteDB with Argo CD and Helm

GitOps is an operational framework for declarative-driven systems such as Kubernetes. More specifically, it provides a set of best practices that converge the runtime state of the services with the declarative state defined in Git. On the other hand, Argo CD is a declarative, continuous delivery tool for Kubernetes. Argo CD follows the GitOps pattern of using Git repositories as the source of truth for defining the desired application state.

Read More

Implementing Change Data Capture (CDC) in YugabyteDB

Databases are systems of records in any enterprise. However, unlocking the true business potential of data requires availability across the entire enterprise ecosystem. This means different applications, services, and systems powering the business processes and use cases of the organization. As a result, change data capture (CDC) is an ideal mechanism for integrating downstream applications and services to a database efficiently,

Read More

Announcing YugabyteDB 2.13: Breakthrough Developer Experience and Performance

We are thrilled to announce the general availability of YugabyteDB 2.13. This is a major release that delivers better control over where geo-distributed deployments store and access data. More specifically, it allows enterprises to lower data transfer costs, improve performance, and ensure compliance with regulatory requirements. This release also includes new features and integrations to enhance developer experience.

YugabyteDB offers a rich set of deployment and replication options in geo-distributed environments.

Read More

Performing Flexible IO Testing in YugabyteDB

ybio is a PL/pgSQL based load generator for PostgreSQL and YSQL. This YugabyteDB-specific IO testing toolkit performs flexible IO testing to specific parts of the YugabyteDB infrastructure with no client installation. And because this toolkit is PL/pgSQL-based, it can also work on native PostgreSQL.

ybio is strongly inspired by Kevin Closson’s SLOB and pgio.

Read More