Ydb

YDB is an open-source distributed SQL database that combines high availability, scalability, strict consistency, and ACID transaction support. It supports multi-tenant and serverless architectures, is suitable for large-scale OLTP workloads, and can automatically handle hardware failure recovery.

Database Finance #Distributed Database #High Availability #SQL Support #Transaction Processing .cpp

rating : 2 points

downloads : 7

update time : 2025-04-23

What is YDB?

YDB is an open-source distributed SQL database designed for handling large-scale interactive web services. It provides high availability, horizontal scalability, and supports strict ACID transactions.

How to use YDB?

You can install YDB through pre-built executables, Docker containers, or by building from source code. After installation, you can interact with the database using command-line tools or SDKs.

Use Cases

YDB is well-suited for OLTP workloads that require high availability, strict consistency, and horizontal scalability, such as e-commerce platforms, financial services, and real-time analytics systems.

Key Features

Fault Tolerance ConfigurationSupports deployment across three availability zones, can withstand a complete failure of a single zone, and maintains read and write availability.

Horizontal ScalingThe storage and computing layers are separated, allowing independent scaling of storage and computing resources.

Automatic Disaster RecoveryBuilt-in automatic recovery support ensures availability and automatically restores data redundancy after hardware failures.

Multi-Tenant and Serverless DatabaseSupports multi-tenant and Serverless settings, allowing sharing of storage pools and computing resources.

Advantages and Limitations

Advantages

High availability configuration can withstand disk, node, rack, or even data center failures

True horizontal scalability, supporting tens of thousands of nodes

Automatic disaster recovery minimizes application downtime

Supports strictly consistent ACID cross-node and cross-table transactions

Limitations

Limited support for non-Linux production environments

Requires a 64-bit x86 platform with at least 8GB of memory

Steep learning curve, requires understanding of distributed system concepts

How to Use

Install YDB

Choose an installation method: pre-built executable, Docker container, or build from source code.

Install Command-Line Tools

Install the YDB CLI tool to manage the schema and execute queries.

Connect to the Database

Use the CLI tool to connect to a local or remote YDB instance.

Execute Queries

Use YQL (a SQL-like query language) to interact with the database.

Usage Examples

E-commerce PlatformUse YDB as the backend database for an e-commerce platform to handle high-concurrency order and payment transactions.

Financial ServicesUse YDB to handle financial transactions, ensuring strict ACID compliance.

Frequently Asked Questions

Which operating systems does YDB support?

What are the minimum system requirements for YDB?

How does YDB handle partitioning and scaling?

Which programming languages does YDB support?

Related Resources

Official Website

The official YDB website, containing the latest information and documentation

GitHub Repository

The open-source code repository for YDB

YouTube Channel

The official YDB YouTube channel, containing tutorials and demonstrations

Telegram Group

The YDB community discussion group

Documentation Center

Complete YDB technical documentation

🚀 YDB

YDB is an open - source distributed SQL database that combines high availability and scalability with strict transaction consistency and ACID transactions.

Official Website |
Documentation |
Official Repository |
YouTube Channel

YDB Product Video (Click to watch the video)

✨ Features

YDB is designed from the ground up to address the growing demand for scalable interactive web services. For OLTP - like workloads, scalability, strict transaction consistency, and efficient cross - row transactions are essential. YDB is developed by people with a rich background in databases and distributed systems, who have been involved in the development of No - SQL databases and Map - Reduce systems for one of the world's largest search engines.

We've found that YDB's flexible design allows us to build more services on top of it, including persistent queues and virtual block devices.

Key Features

Fault - tolerant configuration, capable of tolerating disk, node, rack, or even data - center failures.
Horizontal scalability.
Automatic disaster recovery, ensuring minimal latency interruption of applications even in the event of a complete failure of a single region.
SQL dialect (YQL) for data manipulation and schema definition.
Strict transaction consistency and ACID transactions across multiple nodes and tables.

Fault - Tolerant Configuration

YDB can be deployed across three availability zones. The cluster remains available for reads and writes even in the event of a single region failure. For more details on regions and availability zones, refer to [here](https://ydb.tech/en/docs/deploy/orchestrated/concepts#fault - tolerant - configuration).

Horizontal Scalability

YDB's horizontal scalability enables it to handle large amounts of data and high - concurrency requests, making it suitable for application scenarios of all sizes.

Automatic Disaster Recovery

By deploying across multiple availability zones, YDB can automatically achieve disaster recovery, ensuring high service availability and data persistence.

📦 Installation

Building from Source

You can build the YDB server (ydbd) and client (ydb) binaries here.

Deployment

Deploy a cluster using Kubernetes here.
Deploy a cluster using pre - built executables here.

🤝 How to Contribute

We're excited to welcome new contributors!

Please read the Contributing Guide.
After you've read the Contributor License Agreement (CLA), we can accept your work.
Please add a comment in your pull request indicating your agreement to the CLA terms.

For more detailed information, refer to the CONTRIBUTING file.