A Definitive Guide to Apache ShardingSphere

Written by the core ShardingSphere team this one-stop guide helps you get well versed with the complete list of features of ShardingSphere that can cover every data management need. Key Features * Understand the core concepts and set up Apache ShardingSphere efficiently * Enhance existing databases with data sharding data migration elastic scaling data encryption database and data governance features and more * Import and customize the ecosystems' core features for various application scenarios Book Description Apache ShardingSphere is a new type of open-source database software for distributed data infrastructures based on pluggability and cloud-native principles. This book begins with a quick overview of the main challenges faced by DBMS today in production environments followed by a brief introduction to the software's kernel concept. Thereafter through real-world examples like database security synthetic monitoring and database gateways you will gain a full understanding of ShardingSphere's architectural components how they are configured and can be plugged into your existing infrastructure to manage your data and applications. Moving ahead you will get well versed with the main clients like ShardingSphere-JDBC and ShardingSphere-Proxy and how they can work either concurrently or independently depending on your needs.Then you will learn how to customize the plugin platform to define user strategies and manage multiple configurations seamlessly. Lastly you will get up and running with the groundwork for functional and performance tests for all scenarios including distributed database read-write splitting shadow database and more. By the end of this book you will be able to build and deploy your own customized version of ShardingSphere addressing the key pain points encountered in your data management infrastructure. What you will learn * Leverage the software's pluggable architecture and pick up desired features to assemble the user-oriented solution * Use Database Plus features effectively * Understand the difference between ShardingSphere-JDBC and ShardingSphere-Proxy * Comprehend the mechanism of pluggability of ShardingSphere * Learn the mainstream test model for database systems and perform testing in a distributed database scenario * Perform migrations from an on-premise database to cloud-based database * Re-configure existing data infrastructure without incurring any switching costs Who This Book Is For Database administrators working with distributed database solutions and looking to explore the capabilities of Apache ShardingSphere will find this book helpful. Additionally DBAs looking to explore more capable flexible and cost-effective alternatives to the solutions they're currently utilizing will appreciate this book. Readers of this book can be assumed to have a basic understanding (or even just an interest) in databases relational databases SQL languages cloud computing and data management in general.