WeSQL: MySQL with S3-Backed Compute-Storage Separation

Introduction

WeSQL is an innovative MySQL distribution that redefines database architecture by adopting a compute-storage separation model. It completely replaces MySQL's traditional disk storage with S3, storing all data, including binlogs, schemas, WAL, and data files, entirely as objects in S3. This approach ensures high data reliability, benefiting from S3's 11 nines of durability, and allows for immediate service startup from a clean instance by simply connecting to S3.

Installation

To get started with WeSQL, you can compile it from source. Detailed instructions for building WeSQL are available in the official documentation.

• Compile WeSQL

Examples

WeSQL is ideal for users seeking an easy-to-manage, cost-effective, and developer-friendly MySQL solution. It is particularly well-suited for development and testing environments, as well as for scenarios requiring support for Serverless and Bring Your Own Cloud (BYOC) deployments. Its architecture simplifies data management and scaling.

Why Use WeSQL

The primary advantage of WeSQL lies in its innovative compute-storage separation with S3 integration. This architecture offers several key benefits:

• Enhanced Data Reliability: Leverages S3's 11 nines of durability for superior data protection.
• Cloud Agnostic: Runs on any cloud, eliminating vendor lock-in.
• Cost-Effective: Potentially reduces storage costs by utilizing S3.
• Easy Management: Simplifies database operations, allowing quick startup from an empty instance.
• Developer-Friendly: Provides a flexible solution for modern cloud-native applications.

Links

For further information and community engagement, please refer to these official resources:

• WeSQL GitHub Repository
• WeSQL Documentation
• WeSQL Architecture
• WeSQL Tutorial
• Join the WeSQL Discord Community