Distributed SQL

Three Insights Gained as an Intern at DSS Asia 2022

Three Insights Gained as an Intern at DSS Asia 2022

Hey Everybody! It’s Lakshmi, reporting again from the APJ team!

I recently received valuable first-hand experience helping to run one of the team’s flagship events: the second annual Distributed SQL Summit (DSS) Asia!

This event brought together developers, architects, and business leaders from all over Asia and beyond. Vish Phaneendra’s roundup post provides a great recap. It was exciting to reach close to 1,000 unique attendees and watch 20+ different talks from thought leaders,

Read more

Event Highlights and Key Takeaways from DSS Asia 2022

Event Highlights and Key Takeaways from DSS Asia 2022

We held our second annual Distributed SQL Summit (DSS) Asia annual conference on the 30th and 31st of March 2022, following great feedback from our initial event and user demand.

This two-day online conference was packed with fascinating presentations, discussions, and demos from customers, partners, and our own experts.

With 35 engaging sessions to choose from, and more than 40 speakers, the conference served as a hub for advocates, partners, customers,

Read more

How to Set Up a Scalable and Highly-Available GraphQL API in Minutes

How to Set Up a Scalable and Highly-Available GraphQL API in Minutes

A modern GraphQL API layer for cloud native applications needs to possess two characteristics: horizontal scalability and high availability.

Horizontal scalability adds more machines to your API infrastructure, whereas vertical scalability adds more CPUs, RAM, and other resources to an existing machine that runs the API layer. While vertical scalability works to a certain extent, the horizontally scalable API layer can scale beyond the capacity of a single machine.

When it comes to high availability,

Read more

Retail Application Migration: Lessons Learned Moving from On-Prem to Cloud Native

Retail Application Migration: Lessons Learned Moving from On-Prem to Cloud Native

Recently, I came across a sample e-commerce application that demonstrates how to use Next.js, GraphQL engine, PostgreSQL, and a few other frameworks to build a modern web application. The application supports basic e-commerce capabilities such as product inventory and order management, recommendation system, and checkout function. This made me curious as to how much effort it would take to complete a retail application migration from an on-premise to cloud native solution. So I decided to try.

Read more

Using Ebean ORM with YugabyteDB

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, lower costs, and reduce risks without vendor lock-in.

Read more

Five Benefits to Running a Distributed SQL Database in Kubernetes

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

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, distributed databases need to do more than provide horizontal scalability.

Read more

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

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, distributed SQL database built to accelerate cloud native agility—stores important user and customer data at an organization.

Read more

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

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. Both tools can be used for automation workflows.

Read more

Performing Flexible IO Testing in YugabyteDB

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. Yugabyte Developer Advocate Franck Pachot took pgio and turned it into ybio.

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free