Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.