You're reading from A Definitive Guide to Apache ShardingSphere Transform any DBMS into a distributed database with sharding, scaling, encryption features, and more

Product type Paperback

Published in Jul 2022

Publisher Packt

ISBN-13 9781803239422

Length 466 pages

Edition 1st Edition

Tools

Apache ShardingSphere

Concepts

Databases

Authors (3):

Trista Pan

Zhang Liang

Yacine Si Tayeb

View More author details

Table of Contents (18) Chapters

Preface

1. Section 1: Introducing Apache ShardingSphere

2. Chapter 1: The Evolution of DBMSs, DBAs, and the Role of Apache ShardingSphere FREE CHAPTER

3. Chapter 2: Architectural Overview of Apache ShardingSphere

4. Section 2: Apache ShardingSphere Architecture, Installation, and Configuration

5. Chapter 3: Key Features and Use Cases – Your Distributed Database Essentials

6. Chapter 4: Key Features and Use Cases – Focusing on Performance and Security

7. Chapter 5: Exploring ShardingSphere Adaptors

8. Chapter 6: ShardingSphere-Proxy Installation and Startup

9. Chapter 7: ShardingSphere-JDBC Installation and Start-Up

10. Section 3: Apache ShardingSphere Real-World Examples, Performance, and Scenario Tests

11. Chapter 8: Apache ShardingSphere Advanced Usage – Database Plus and Plugin Platform

12. Chapter 9: Baseline and Performance Test System Introduction

13. Chapter 10: Testing Frequently Encountered Application Scenarios

14. Chapter 11: Exploring the Best Use Cases for ShardingSphere

15. Chapter 12: Applying Theory to Practical Real-World Examples

16. Other Books You May Enjoy

Appendix: and the Evolution of the Apache ShardingSphere Open Source Community

Distributed database solution

In order to give you some potential common scenarios that might be encountered in the real world, we have selected a few possible cases. Reading these cases will show you how to combine multiple features to create solutions that can greatly enhance your system, and allow you to make the most of Apache ShardingSphere.

Case 1 – ShardingSphere-Proxy + ShardingSphere-JDBC + PostgreSQL + distributed transaction + cluster mode + the MOD sharding algorithm

The first case will take you through a scenario including ShardingSphere-Proxy as well as ShardingSphere-JDBC working with PostgreSQL. Distributed transactions are included with ShardingSphere's Cluster mode and the MOD sharding algorithm.

The deployment architecture

The deployment architecture of Case 1 is shown in Figure 12.1. Apache ShardingSphere's distributed database solution adopts the hybrid deployment model of ShardingSphere-JDBC plus ShardingSphere-Proxy, and centrally...

The rest of the chapter is locked

You're reading from A Definitive Guide to Apache ShardingSphere Transform any DBMS into a distributed database with sharding, scaling, encryption features, and more

Table of Contents (18) Chapters

Distributed database solution

Case 1 – ShardingSphere-Proxy + ShardingSphere-JDBC + PostgreSQL + distributed transaction + cluster mode + the MOD sharding algorithm

The deployment architecture

Unlock this book and the full library FREE for 7 days

Authors (3)

Personalised recommendations for you