Databases

Cloud Native Java: Integrating YugabyteDB with Spring Boot, Quarkus, and Micronaut

February 16, 2022

Databases Ecosystem Integrations How It Works

Cloud Native Java: Integrating YugabyteDB with Spring Boot, Quarkus, and Micronaut

Java is the quintessential language runtime for enterprise applications built on monoliths, microservices, and modular architecture patterns. But when it comes to “Enterprise Java,” Spring is the de facto framework of choice.

The Spring ecosystem—with the simplicity of Spring Boot—has grown to provide integration touchpoints to a majority of the Java ecosystem. For starters, it offers a clean abstraction and “glue” code to build cohesive enterprise applications. However,

…

TPC-C Benchmark: Scaling YugabyteDB to 100,000 Warehouses

February 11, 2022

By Hemant Bhanawat and Sonal Agarwal

Databases Distributed SQL

TPC-C Benchmark: Scaling YugabyteDB to 100,000 Warehouses

We’re excited to announce a new milestone in our TPC-C benchmark journey! YugabyteDB can now scale up to 100,000 warehouses with an efficiency of 99.78%. More specifically, this results in 630,000 operations per second on the database cluster, observed over a two-hour period.

For those new to TPC-C, it’s an OLTP system benchmarking tool used to measure performance when handling transactions generated by a real-world OLTP application. It models a business that has a warehouse,

…

YugabyteDB and Apache Superset: Explore and Visualize Open Source Data

February 10, 2022

By Akshay Atrey and Balachandar Seetharaman

Databases Distributed SQL PostgreSQL YugabyteDB

YugabyteDB and Apache Superset: Explore and Visualize Open Source Data

In this post, we demonstrate how business users can use Apache Superset to get valuable insights from their data stored in YugabyteDB. We’ll also walk through a retail operations use case that keeps track of order processing efficiency in a specific business territory, as highlighted below.

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,

…

Securing YugabyteDB: Part 1 – Server-to-Server Encryption in Transit

February 4, 2022

By Sanketh Indarapu

Databases Distributed SQL

Securing YugabyteDB: Part 1 – Server-to-Server Encryption in Transit

Encryption in transit is a common requirement for client-to-server communication. It is particularly important for YugabyteDB, a 100% open source, distributed SQL database built to accelerate cloud native agility. YugabyteDB typically stores important user and customer data at an organization.

In this ongoing blog series, we take a look at the different aspects of encryption in transit for YugabyteDB. This first post will focus on encryption in transit for the database’s internal RPC communication protocol,

…

A Matter of Time: Evolving Clock Sync for Distributed Databases

February 2, 2022

By Karthik Ranganathan

Databases Distributed SQL

A Matter of Time: Evolving Clock Sync for Distributed Databases

Distributed clock synchronization is critical for many applications, including distributed SQL databases. Clock synchronization needs to keep up with the other demands in our modern infrastructure, such as:

Applications that have increasing performance requirements while distributing data across different geographic regions
Network infrastructure and computing power that is improving constantly

A distributed SQL database is highly available and resilient to failures when deployed across a cluster of nodes.

…

My Yugabyte Journey: From Intern to Full-Time Software Engineer

January 28, 2022

By Tim Elgersma

Careers Company News Databases

My Yugabyte Journey: From Intern to Full-Time Software Engineer

Hello. My name is Tim Elgersma, and I’m a software engineering intern on the YSQL team at Yugabyte. I have one semester left in my bachelor of Computer Science program at the University of Waterloo. In this blog post, I’d like to talk about my experience interning here over the past several months, and why I’m excited to join the company full time upon graduation.

Adding tablespaces to tablegroups

My onboarding at Yugabyte went pretty smoothly.

…

PostgreSQL Timestamps and Timezones: How to Navigate the Interval Minefield

January 27, 2022

By Bryn Llewellyn

Databases How It Works PostgreSQL YugabyteDB

PostgreSQL Timestamps and Timezones: How to Navigate the Interval Minefield

In the second part of this blog series on PostgreSQL and YSQL date-time data types, the focus shifts to representing durations, or how long things last. Assuming the reader has read the first part and downloaded the companion code kit, this post explores the relevant data types, including interval, timestamp difference, and other related functions.

PostgreSQL Timestamps and Timezones: What You Need to Know—and What You Don’t

January 27, 2022

By Bryn Llewellyn

Databases How It Works PostgreSQL YugabyteDB

PostgreSQL Timestamps and Timezones: What You Need to Know—and What You Don’t

This is the first of a two-part blog post series that deals with the basic business of representing moments using time, date, and timestamp data types. YugabyteDB’s YSQL subsystem provides a similar experience to PostgreSQL, so the topic may still be enlightening for some YSQL users.

YugabyteDB Integrates with Arctype SQL Client

January 25, 2022

By Yugabyte Team

Databases Ecosystem Integrations PostgreSQL YugabyteDB

YugabyteDB Integrates with Arctype SQL Client

PostgreSQL has eaten the world. And so Yugabyte set out to build the most Postgres-compatible, scalable, and resilient database. YugabyteDB is not only wire compatible with PostgreSQL, it is code compatible by reusing the upper half of PostgreSQL. Thanks to this compatibility, YugabyteDB can connect to the vast majority of database tools that integrate with Postgres.

In a previous blog post, Yugabyte Developer Advocate Franck Pachot showed how to connect YugabyteDB in Arctype.

…

Databases

Adding tablespaces to tablegroups

Explore Distributed SQL and YugabyteDB in Depth