A Definitive Guide to Apache ShardingSphere: Transform any DBMS into a distributed database with sharding, scaling, encryption features, and more

Become well versed with all of ShardingSphere's features for every data management need with this comprehensive guide put together by ShardingSphere's founder and core contributors

Key Features:

• Understand the core concepts and efficiently set up Apache ShardingSphere
• Enhance existing databases with sharding, elastic scaling, encryption, governance features, and more
• Import and customize the ecosystem's core features for various application scenarios

Book Description:

Apache ShardingSphere is a new open source ecosystem for distributed data infrastructures based on pluggability and cloud-native principles that helps enhance your database.

This book begins with a quick overview of the main challenges faced by database management systems (DBMSs) in production environments, followed by a brief introduction to the software's kernel concept. After that, using real-world examples of distributed database solutions, elastic scaling, DistSQL, synthetic monitoring, database gateways, and SQL authority and user authentication, you'll fully understand ShardingSphere's architectural components, how they're configured and can be plugged into your existing infrastructure, and how to manage your data and applications. You'll also explore ShardingSphere-JDBC and ShardingSphere-Proxy, the ecosystem's clients, and how they can work either concurrently or independently to address your needs. You'll then learn how to customize the plugin platform to define personalized user strategies and manage multiple configurations seamlessly. Finally, the book enables you to get up and running with functional and performance tests for all scenarios.

By the end of this book, you'll be able to build and deploy a customized version of ShardingSphere, addressing the key pain points encountered in your data management infrastructure.

What You Will Learn:

• Assemble a custom solution using the software's pluggable architecture
• Discover how to use Database Plus features effectively
• Understand the difference between ShardingSphere-JDBC and ShardingSphere-Proxy
• Get to grips with ShardingSphere's pluggability mechanism
• Explore mainstream test models for databases and distributed databases
• Perform migrations from an on-premise database to a cloud-based database
• Reconfigure your data infrastructure and eliminate switching costs

Who this book is for:

This book is for database administrators working with distributed database solutions who are looking to explore the capabilities of Apache ShardingSphere. DBAs looking for more capable, flexible, and cost-effective alternatives to the solutions they're currently utilizing will also find this book helpful. To get started with this book, a basic understanding of, or even an interest in, databases, relational databases, SQL languages, cloud computing, and data management in general is needed.

這本由ShardingSphere的創始人和核心貢獻者共同編寫的全面指南，將使您熟悉ShardingSphere的所有功能，以滿足各種數據管理需求。

主要特點：
- 瞭解核心概念並有效設置Apache ShardingSphere
- 通過分片、彈性擴展、加密、治理功能等增強現有數據庫
- 導入和自定義生態系統的核心功能，以應對各種應用場景

書籍描述：
Apache ShardingSphere是一個基於可插拔性和雲原生原則的分布式數據基礎設施的新型開源生態系統，有助於增強您的數據庫。本書首先快速概述了生產環境中數據庫管理系統（DBMS）面臨的主要挑戰，然後簡要介紹了軟件的核心概念。接著，通過使用分布式數據庫解決方案、彈性擴展、DistSQL、合成監控、數據庫網關和SQL權限和用戶身份驗證的實際案例，您將完全瞭解ShardingSphere的架構組件，以及它們的配置方式和如何插入到現有基礎設施中，以及如何管理數據和應用程序。您還將探索ShardingSphere-JDBC和ShardingSphere-Proxy，這些生態系統的客戶端，以及它們如何同時或獨立地滿足您的需求。然後，您將學習如何自定義插件平台，定義個性化的用戶策略並無縫管理多個配置。最後，本書將使您能夠在各種情境下進行功能和性能測試。

通過閱讀本書，您將能夠構建和部署定制版本的ShardingSphere，解決數據管理基礎設施中遇到的關鍵問題。

您將學到什麼：
- 使用軟件的可插拔架構組建自定義解決方案
- 有效使用Database Plus功能
- 瞭解ShardingSphere-JDBC和ShardingSphere-Proxy之間的區別
- 掌握ShardingSphere的可插拔機制
- 探索數據庫和分布式數據庫的主流測試模型
- 從本地數據庫遷移到基於雲的數據庫
- 重新配置數據基礎設施並消除切換成本

本書適合使用分布式數據庫解決方案的數據庫管理員，他們希望探索Apache ShardingSphere的能力。尋找更強大、靈活和具有成本效益的替代方案的數據庫管理員也會發現本書有所幫助。要開始閱讀本書，需要基本的對數據庫、關聯數據庫、SQL語言、雲計算和數據管理的理解或興趣。