XPanel Database Server Resource Management
XPanel Database Server Resource Management
1. System overview
XPanel is a GUI for Klustron users to manage Klustron database clusters and monitor cluster node status, including all cluster management functions and functional interfaces for cluster status monitoring.
2. Introduction to database server management functions
The database server is the computer server hardware used to run the Klustron cluster. The database server management function is to let the DBA register the database server that has completed initialization (bootstrap) into the metadata cluster of Klustron, so that it can be used by cluster_mgr to complete various cluster management functions. The specific operations of database server management include operations such as adding new computers and deleting computers. After these database servers are registered to the metadata cluster of Klustron, the cluster_mgr module of Klustron can use them for elastic expansion, or create a Klustron cluster on them.
2.1 Computer list
The computer list page mainly displays computer information List, including basic information such as IP address, machine type, port range, rack number, and number of cpu cores.
2.1.1 bootstrap initialization
Before adding a new database server, you need to use the database server cluster initialization guide to initialize these computer servers, and then you can use XPanel to add a new computer.
2.1.2 Adding a new computer
When adding a computer, click the Add button, fill in the IP address, machine type, port range, data directory, log directory, total memory of the machine, and the number of cpu cores to save. The specific additions are shown in Figure 1 and Figure 2.
figure 1
figure 2
- Among them, IP, directory, memory, cpu core number, machine type, and port range are all required items (when the machine type is selected as computing, the system default port range is 47000-48000; when the machine type is selected as storage, the system default port range is 47000-48000; The range is 57000-58000), and the port range can be flexibly set according to the free range of your own machine ports; the rack number is optional.
- After clicking confirm, the background interface will be adjusted to add computers to cluster_mgr for cluster installation.
- Click the view monitoring information button in the upper right corner to view the monitoring information of the computer, mainly including the number of cpu cores, cpu usage, memory usage, available space and some load information. As shown in Figure 3.
Note): Because there may be multiple computers in the system, you can view the corresponding host monitoring information through ip screening.
image 3
2.1.3 Delete a computer
Deleting a computer. For a computer that no longer exists or is broken, it is necessary to perform regular deletion operations to ensure the latest status of the data. Click the delete button to complete the deletion operation. As shown in Figure 5. Note): Because once the data is deleted, it cannot be recovered. In order to avoid misreading the data and causing the accidental deletion operation, you can search for the corresponding data through the IP and then perform the deletion operation.
Figure 4
2.1.4 Node view
The node view mainly displays the number of cluster nodes under the computer, including computing nodes and storage nodes. Moving the mouse over a node will display the node's ip, port, cluster, and shard-related tip information. As shown in Figure 6 and Figure 7. Note): If the computer is a newly added computer, there may be a situation where the node is zero, as shown in Figure 8. At this point, there is no need to enter the node view to view node information.
Figure 5
Figure 6
Figure 7