{{ variable.name }}
Introduction: Improving database performance is a matter that every project needs to continuously focus on from the beginning to the middle and later stages. There are also many methods for optimizing database performance, such as: Index optimization, SQL optimization, database and table sharding, etc. People may have less understanding of this optimization method in their daily work. Database and table sharding requires certain business scenarios, and the problems brought about during use also need to be solved simultaneously. This course starts with the reasons for database and table Sharding, then moves on to manual implementation of sharding, and then introduces Sharding-JDBC for database and table sharding. Not only that, we will also discover the problems of database and table sharding in practical situations and provide corresponding solutions.
Chapter 1: Course Introduction
This chapter introduces the main content of this course, the target audience and the technical foundation required.
Course Introduction 1-1
Chapter 2 Sharding- Introduction to JDBC
This chapter starts with an analysis of why Sharding is necessary, then introduces Sharding-JDBC, and finally explains the basic principles and advantages of Sharding-JDBC.
2-1 What is Sharding-JDBC?
2-2 Why do we need sharding databases and tables?
The method of sharding databases and tables 2-3
2-4 Commonly used middleware for sharding databases and tables
2-5 Basic Principles and Advantages of Sharding-JDBC
Chapter 3 Sharding-JDBC Practice
This chapter first implements an order process in a single-database manner, then transforms it into a vertical Sharding approach, and finally uses sharding-JDBC to transform it into a sharding and sharding approach. During these several transformation processes, discover the problems of sharding databases and tables and the corresponding solutions.
3-1 Cash Register Order Creation Process Single Library Scene Code
3-2 Vertical sharding Transformation
Common Problems and Solutions After Database Sharding (Part One
3-4 The transformation of horizontal Sharding and table sharding and the use of Sharding-JDBC
Common Problems and Solutions after Database and Table Sharding (Part Two) 3-5
Chapter 4 Course Summary and Review
This chapter summarizes and reviews the course content.
4-1 Course Summary