Nowadays, with the development of the Internet, the magnitude of data is also increasing exponentially, from GB to TB to PB. The operation of data is also increasingly difficult, the traditional relational database has been unable to meet the needs of rapid query and insert data, this time the emergence of NoSQL to temporarily solve this crisis.
It gains performance by reducing data security, reducing support for transactions, and reducing support for complex queries. However, there are situations in which some of the trade-offs of NoSQL are not suitable for use scenarios, such as those in which transaction and security metrics are absolutely required. NoSQL is definitely not enough at this point, so you still need to use a relational database. How to use relational database to solve the problem of mass storage? At this point, we need to do database cluster, in order to improve the query performance of the data of a database scattered to different databases for storage, to solve this problem – MyCat.
Mycat is an open source distributed database system. Its core function is to divide tables and libraries. That is, a large table is horizontally divided into several small tables and stored in back-end MySQL or other databases. Mycat is named because it is easy to remember, and also because I hope to join Apache in the future. Tomcat, Apache’s open source product, is also a cat.
Open baidu APP to see hd pictures
As a result, your xiaobian (Lei Feng) in this week to focus on the collection and collation of the open-source database middleware MyCat use and principle of source code + notes + project actual combat information. This document will be comprehensive from MyCat foundation, advanced, cluster, monitoring, architecture analysis to explain MyCat, and through a case to demonstrate in the actual development, how to achieve MyCat database sharding operation. Through the study of this material, we can fully master the use and principle of MyCat.
The above is the content of the information contained, the following small series will show catalog and detailed content screenshots, there is a need for a complete version of the source code + note friends, only forward + attention, and then in my home page private letter [database] can be free!!
Open source database middleware MyCat combat notes
1. The introduction of MyCat
2. Introduction to MyCat
3. Explain the MyCat configuration file
4. MyCat shard
5. MyCat senior
6. Set up the MyCat HA cluster
7. MyCat architecture analysis
8. MyCat comprehensive case
Thoroughly open source technology MyCat entry to development
Introductory article
Overview of Mycat Concepts in Mycat Quick Start Log analysis Mycat firewall configuration Mycat configuration Mycat Fragmentation Join Global Serial number Mycat Fragmentation rules FaQs and Solutions Mycat Performance Test Guide
Advanced advanced chapter
High availability and cluster transaction support Mycat SQL interception mechanism Mycat annotation Catlet implementation supported by Mycat JDBC multi-database support management commands and monitoring compression protocol support Mycat-WebMyCAT support for stored procedures
Production practice
Production practice Case -Mycat Read/write separation Case Table and database Case Mycat deployment best practices Mycat implementation Guide Data migration and capacity expansion Practice Version selection and upgrade Guide Performance tuning
Development of article
Join MycatMycat development foundation Mycat architecture analysis Mycat thread model analysis Mycat connection pool model Mycat network communication framework Mycat routing and distribution process Mycat JDBC backend framework Mycat transaction management mechanism Mycat paging and cross-library JoinMycat cache Mycat fragmentation rules design Mycat Load Data source Mycat group Will be transmitted
Need the full version of the source + notes for friends:
—————— forward + comment article, after paying attention to my private letter keyword: [database] can.