Open Source

Event Highlights and Key Takeaways from DSS Asia 2022

April 29, 2022

Community News Databases Distributed SQL Ecosystem Integrations Open Source

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,

…

Five Benefits to Running a Distributed SQL Database in Kubernetes

April 7, 2022

By Amey Banarse

Databases Distributed SQL Kubernetes Open Source

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?

…

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

April 5, 2022

By Denis Magda

Distributed SQL Geo-Distribution

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.

…

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

April 4, 2022

By Sanketh Indarapu

Databases Distributed SQL Open Source PostgreSQL

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.

…

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

March 31, 2022

By Srinivasa Vasu

Databases Distributed SQL How To Open Source

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.

…

Performing Flexible IO Testing in YugabyteDB

March 18, 2022

By Frits Hoogland

Databases Distributed SQL Open Source PostgreSQL

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.

…

March 11, 2022

By Lakshmi Suresh

Community News Company News Databases Distributed SQL Open Source

Three Reasons Why I Joined Yugabyte APJ

Hello Everyone! I am Lakshmi, a tech product marketing intern for the Yugabyte Asia Pacific Japan (APJ) team. It has been my first month working at Yugabyte and I am thankful for the opportunity. Beyond my internship, I am a final year student at the NUS Business School in Singapore, specializing in Business Analytics.

A bit about me

Prior to joining Yugabyte APJ, I had always been interested in the world of startups.

…

How Does YugabyteDB’s Two-Layer Architecture Work?

March 10, 2022

By Franck Pachot

How It Works YugabyteDB

How Does YugabyteDB’s Two-Layer Architecture Work?

YugabyteDB is a 100% open source, distributed SQL database system. This single phrase expresses two distinct notions: a SQL database system, and a distributed database system. Historically, these notions were mutually exclusive. But current technology allows a single system to implement both notions. YugabyteDB does this with its two-layer architecture: an extensible query processing layer and a distributed document store.

In this blog post,

…

Better Developer Experience: Getting Started with YugabyteDB on Gitpod

February 24, 2022

By Srinivasa Vasu

Databases Distributed SQL Open Source

Better Developer Experience: Getting Started with YugabyteDB on Gitpod

Developer onboarding and experience gets simplified every day. But while developers use many modern software development techniques—including 12-factor, cloud native, and continuous integration—developer onboarding remains a challenge. Therefore, what developers need is an integrated, self-contained platform that helps them get started with ease.

Gitpod is one such way we can steer into that problem space to create a better developer experience. More specifically, Gitpod provides git-based, fully automated, integrated cloud-native development workflows with the prerequisites configured.

…

Linux Performance Tuning: Dealing with Memory and Disk IO

February 8, 2022

By Frits Hoogland

Databases How It Works Open Source

Linux Performance Tuning: Dealing with Memory and Disk IO

Linux is a general purpose operating system. This means it’s created to generally do what is right, instead of having specific code paths to perform what is right for a single specific task—and potentially be wrong for others.

Linux does not have tunable parameters for reserving memory for caching disk pages (the page cache), like operating systems such as HPUX (dbc_min_pct, dbc_max_pct) or AIX (minperm%, maxperm%). Instead,

…

Open Source

A bit about me

Explore Distributed SQL and YugabyteDB in Depth