Mycat sub-table sub-database distributed database project implementation and maintenance _ MySQL high availability replication and distributed cluster architecture 10
Mycat distributed database project implementation and maintenance_MySQL high availability replication and distributed cluster architecture 10
Video Tutorial Learning Address
http://edu.51cto.com/course/14498.html
Oracle/MySQL database learning QQ group: 336282998, 189070296
After finishing this course, you can familiarize yourself with the following contents:
I. Course Content
01.MyCat function introduction and application scenarios
02.MyCat Installation and Startup
03.MyCat Configuration System Introduction
04.MyCat library table function and fragmentation rules
05. Introduction to MyCat Global Serial Numbers
06.MyCat Multitenant Application Introduction
07.MyCat configuration read/write separation (MySQL one master and many slaves) project actual combat
08.MyCat sub-table sub-library fragmentation project actual combat 1-vertical sub-library-9 libraries
09.MyCat sub-library sub-table fragmentation project actual combat 2-horizontal sub-library-35 libraries enumerated fragmentation by province
10. MyCat sub-table sub-library fragmentation project actual combat 3-global table-25 library horizontal fragmentation
11. MyCat sub-table sub-library fragmentation project actual combat 4-ER table-35 library module fragmentation
12. MyCat sub-table sub-library fragmentation project actual combat 5-9 library primary key range fragmentation
13. MyCat sub-table sub-library fragmentation project actual combat 6-9 library consistency hash fragmentation
14. MyCat sub-table sub-library fragmentation project actual combat 7-36 library dates by day fragmentation
15. MyCat sub-table sub-library fragmentation project actual combat 8-84 library natural monthly fragmentation
16. MyCat sub-table sub-library fragmentation project actual combat 9-24 libraries a month hour fragmentation
17. MyCat sub-table sub-library fragmentation project actual combat 10-multi-node expansion and multi-node deletion
18. MyCat Backend MySQL Database Backup and Migration Solution
19. MyCat Dual High Availability HA Solution and Project Actual Combat
20. MyCat Large-scale Load Balancer Scheme and Project Actual Combat
21. MyCat Monitoring Management and Optimization
II. Thematic recommendations
MySQL High Availability Replication and Distributed Cluster Architecture (Feature Series) Video Tutorial
http://edu.51cto.com/topic/1622.html
This series of courses, unique in the whole network, is the mainstream architecture of Internet MySQL, involving multiple servers, nearly 100 databases, and tens of millions of data projects.
