O & M notice: select five principles for database servers

Databases are very important for an enterprise. database servers are required for both electronic transactions, financial securities, and enterprise resource planning systems. With the continuous development of database technology in business, the scale of database applications is becoming larger and larger, which requires more and more database servers.

For example, if the number of posts posted on a forum is about 1000 every day, about 0.4 million data records will be generated after one year of operation, if you want to query and edit the 0.4 million pieces of data, the hardware requirements for the database server are quite high. In addition, as the operation time increases, database-based applications, such as ERP and Forum systems, require more stringent server hardware after a certain scale, once the server device cannot withstand the database pressure, it will directly lead to system paralysis and various services, and the loss will be extremely huge. After talking about the importance of so many databases, how can we choose a reliable and stable database server? We will start from five aspects to help you understand the requirements of database servers for server hardware.

Five principles for selecting a database server:

1) High Performance Principle

Ensure that the purchased servers not only meet the operation and business processing needs of the operating system, but also meet the growth of business volume in a certain period of time. Generally, the required server TpmC value can be calculated based on the empirical formula (Tpmc is a program used to measure the transaction processing capability of the computer system), and then the TpmC Value published by server vendors and TPC organizations is compared, select a model. At the same time, remove the calculated TpmC value from the market price/price of the server to get the price of the unit TpmC value, and then select the server with a high-performance price ratio.

Conclusion: The Performance of the server processor is critical, the CPU clock speed is high, and a large cache is required.

2) reliability principle

The reliability principle is the primary consideration for all devices and systems to be selected, especially for large systems with high processing requirements that require long-term operation. Considering the reliability of the server system, we should consider not only the reliability or stability of a single server node, but also the overall reliability of the connection between the server and the relevant auxiliary systems, such: network system, security system, and remote printing system. When necessary, cluster technology should also be considered for key servers, such as dual-machine hot backup or cluster parallel access technology, or even a possible full Fault Tolerance machine.

Conclusion: servers must be redundant, and devices such as hard disks, NICS, memory, and power supplies must be stable and durable, followed by performance.

3) scalability Principle

Ensure that the purchased server has excellent scalability principles. Because the server is the core of all system processing, it requires a high data throughput rate, including: I/O rate and network communication rate, in addition, the server needs to be able to handle the data volume generated by the Business Development in a certain period of time, and the server needs to be able to upgrade itself according to the business development needs at the appropriate time, such: CPU model upgrade, memory expansion, hard disk expansion, Nic replacement, increase the number of terminals, Mount disk arrays, or cluster systems that are used with other servers for concurrent access to centralized data. All of these require the purchased servers to have a good room for expansion as a whole. Generally, databases and billing application servers use clusters to increase reliability in the design of large-scale billing systems. The attached disk storage system depends on the data volume and investment, you can use technologies such as DAS, NAS, and SAN.

Conclusion: The IO of the server is high. Otherwise, the bottleneck may occur when both the CPU and memory performance is high. In addition, the scalability of servers is better, in order to meet the needs of enterprise development in the future.

4) Security Principles

Most of the data processed by the server is the core data of the relevant system, which stores and runs key transactions and important data. These transactions and data are important assets for the owner, and their security is very sensitive. Server Security is inseparable from the overall security of the system, such as network system security, data encryption, and password system. Servers, including hardware and software, should be designed and considered from a security perspective. With the help of external security facilities, they must ensure their own high security.

Conclusion: In terms of server materials, high hardness, high protection, and other conditions should be met. In addition, the cooling system of the server and adaptability to the environment should be strong, in this way, the server security requirements can be met on the hardware.

5) manageability Principle

The server is both the core and a node part of the system. Just as the network system requires management and maintenance, it also requires effective management of the server. This requires the support of the server's hardware and software for standard management systems, especially the operating systems on the servers, including some important system components.

Conclusion: select a server that supports multiple systems as much as possible, because the more compatible the system, the larger the selection space.

Conclusion: first, the database server has high performance requirements, so there are high requirements in terms of CPU, memory, and hard disk. Second, the storage should have good stability, to meet the long-term operation of the server to read and write operations at any time without errors. Finally, we hope to help you select the database servers you need by summarizing the above five points.