Mycat+mysql building a highly available Enterprise DB cluster--2nd Chapter Mycat Getting Started

• 2-1 Chapter Overview
• 2-2 What is Mycat
• 2-3 What is a database middle tier
• The main role of 2-4 Mycat
• 2-5 Mycat Basic Elements
• Installation of 2-6 Mycat

2-1 Chapter Overview1, master the basic concept of mycat, function and applicable scene;

2, Master Mycat installation and start-up;

2-2 what is Mycat

1, different types of jobs on the different understanding of mycat;

• Research and development personnel;

• Architect;

2, the realization of "read and write separation" of two ways;

• From the point of view of the program, two sets of data sources are configured;
• Through the perspective of middleware, such as Mycat;

2-3 What is a database middle tier1, the database middle layer first knowledge;

the main role of 2-4 Mycat1, as a distributed database middle-tier use (relational and Philippine relationship type can be);

2, to achieve the back-end database read-write separation and load balancing;3, in the database, the general read request operation is much higher than the write request operation;

4, the change is shown, only applies to "one Master one from" the MySQL database schema;

5, the realization of "a master more from" The MySQL high availability, need to be MHA or 3M way to achieve;6, vertical segmentation of the business database;

7, using the advantages of Mycat, the back end corresponding to the real database, as a "logical library";

8, the business database of horizontal segmentation (sub-Library sub-table);

9, the segmentation logic, through the Mycat;

10, control the number of database connections;

• When the number of connections is full, all new requests will no longer be connected, affecting the business;
• Through the MYCAT middleware, a public "database connection pool" is established;

2-5 mycat Basic Elements1, logical Library & logical table concept review;

2, the classification of the logical table;

• Shard table
• Global table
• ER relationship table

installation of 2-6 Mycat

1, download and decompression mycat;

2, install Java running Environment JDK1.7 or above version;

3, new Mycat running system account;

4, configure the system environment variables;

5, modify the Mycat start parameters;

Mycat+mysql building a highly available Enterprise DB cluster--2nd Chapter Mycat Getting Started