Cong Li1. Overview
To support the construction of a data platform in a specific industry and meet the project planning needs for efficient management and access services for detection data and products, long-term historical data statistical analysis needs to be implemented. This requires setting up a distributed analytical database cluster environment at both national and provincial levels to support national and provincial industry business applications. According to customer agreements, the product implementation services include deployment at the National Information Center and 31 provincial information centers. To ensure implementation quality, after deployment and implementation at the National Information Center, GBASE will draft the provincial deployment implementation plan. After provincial deployment and testing, and upon customer confirmation, the system will enter the trial operation period.
This document provides a detailed description of the deployment process of the GBase 8a MPP Cluster analytical database. It is divided into three main parts: preliminary planning, installation environment preparation, and installation deployment verification.
2. Scope and Content of the Construction Plan
2.1 Construction Plan
The GBase 8a MPP database system software V95 needs to be deployed at the National Information Center and 31 provincial information centers, totaling 32 sets, with at least 192 database cluster nodes. Provincial deployment implementation needs to be completed within 9 months. To ensure the smooth progress of the project, our company will develop a detailed provincial project implementation plan based on the experience and processes of the initial construction at the National Information Center, ensuring the successful completion of the project.
2.2 Construction Content
According to the project schedule, provincial centers (23 provinces) will deploy 6 nodes, and regional centers (8 provinces) will deploy 8 nodes. This plan is compiled based on a 6-node GBase8a MPP cluster for provincial centers, with the 8-node setup for regional centers referencing the provincial center's plan. The GBase8a MPP cluster environment (see Table 3-1). Construction content includes: installation environment preparation and configuration, pre-installation checks, cluster installation and deployment, post-installation verification, and application connection planning.
Table 3-1: Equipment List
| Device Model | Device Description (Data Node) | Quantity |
|---|---|---|
| Basic Configuration | CPU: 2 x 14 Core or higher, clock speed 2.6GHz or above Memory: 256GB or above RAID Card: RAID card with 1GB cache Data Node Disks: 2 x 480GB SSD + 12 x 1.2TB (10,000 RPM or above) SAS disks Network Card: 2 x dual-port 10G NICs (including modules), 2 x dual-port 1G NICs Redundant power supplies, fans, and management NIC |
6 units (Provincial Center) 8 units (Regional Center) |
3. Technical Plan
3.1 System Architecture
The system architecture of a 6-node GBase 8a cluster environment is shown in Figure 4-1:
3.2 System Layout
The GBase 8a cluster node server network is divided into 3 coordinator nodes + 6 data nodes, with 2 coordinator nodes and data nodes being reused. The IP address allocation for the 6 machines is as follows:
Table 4-2: Cluster Node IP Allocation Table
| Hostname | 10G Network IP | 1G Network IP | Purpose |
|---|---|---|---|
| gbase01 | 192.168.*.80 | 10.*.90.80 | Coordinator Node + Data Node |
| gbase02 | 192.168.*.81 | 10.*.90.81 | Coordinator Node + Data Node |
| gbase03 | 192.168.*.82 | 10.*.90.82 | Coordinator Node |
| gbase04 | 192.168.*.83 | 10.*.90.83 | Data Node |
| gbase05 | 192.168.*.84 | 10.*.90.84 | Data Node |
| gbase06 | 192.168.*.85 | 10.*.90.85 | Data Node |
The second part will provide a detailed introduction to the environment configuration and pre-installation checks. Stay tuned...
