2013 How to choose a database server

With the forum, electricity, ERP and other industries rapid development, the database becomes increasingly important, and in a certain scale, the server hardware more stringent equipment. For these enterprises, the server, storage equipment, once the database can not withstand the work pressure, will directly cause system crashes or a number of business paralysis, the loss is self-evident.

2013 the beginning of the new Year, database-oriented enterprises to choose a reliable, stable, scalable database server? In order to further ensure the stable development of this type of enterprise, data security, the author today mainly from the reliability, high performance, scalability, security, Manageability and other five aspects help users understand how to buy a database server, exactly what hardware is equipped to meet the requirements of the database server.

First, the database server needs to be reliable: the server to support redundant technology, at the same time, such as hard disk, memory, network cards and other such equipment to be stable and durable, the performance of the second.

Database server reliability is the primary consideration in selecting devices and systems, especially in large, heavily processed systems that require long running. Considering the reliability of the server system, we should consider not only the reliability or stability of the server's single node, but also the overall reliability of the connection between server and related auxiliary system or storage, such as: Network security system, Web Web site system, remote printing system, etc. When necessary, consideration should also be given to clustering techniques for critical servers, or even to possible complete fault-tolerant machines.

Second, the database server needs security: from the server material to say to have high hardness and high protection conditions, and then the server's cooling system and the ability to adapt to the environment, so that the hardware can meet the requirements of the server security.

Most of the database server processing is the core data of the related system, on which key transactions and important data are stored and run. These transactions and data are important assets for users, and they are very sensitive to security. The security of the server is inseparable with the whole security of the system, such as: the security of the network system, data encryption, password system, etc. Server needs in its own, including hardware and software, should be considered from a security perspective, in the aid of external security facilities, but also to ensure the high security itself.

Third, the database server needs high performance: Server processor performance is critical, CPU frequency is how high, processing data speed, how large the cache directly affect the database.

The database server selected by the enterprise can not only meet the operation of operation system and the need of business processing, but also can meet the growth of business volume in a certain period. It is generally possible to calculate the required server TPMC values based on empirical formulas (TPMC is a program that measures the transaction power of computer systems), and then compare the TPMC values published by each server manufacturer and TPC organization to select the appropriate models. At the same time, using the server's market price/quotation To remove the calculated tpmc is worth the price of the unit TPMC value, and then choose the server with high performance price ratio.

Four, the database server needs scalability: The server's IO to high, otherwise in the CPU and memory are high-performance situation, there will be bottlenecks. In addition, the server scalability is better to meet the needs of enterprises in the future development.

Ensure that the selected database server has excellent scalability. Because the server is the core of all system processing, requires a large data throughput rate, including: I/O rate and network communication rate, and the server needs to be able to handle a period of business development brought about by the amount of data, the need for the server at the appropriate time for its own needs of the business development of the More direct methods are: CPU model upgrades, memory expansion, hard disk expansion, replacement of network cards, increase the number of terminals, hooked up disk arrays or with other servers in the centralized data access to the cluster system. General database and billing application Server in the design of large billing system will be used to increase the reliability of the cluster approach, which attached to the disk storage system, according to data volume and investment considerations, can use Das, NAS or SAN implementation technology.

V. Database server manageability: Choose to support multiple system servers as much as possible. The more server-compatible systems, the more space users can have.

The server is not only the core but also a part of the system as a whole, just like the network system needs to be managed and maintained, the server should be managed effectively. This requires the server's hardware and software to support the standard management system, especially the operating system on it, as well as some important system components.

Summary: Choose the appropriate database server, the enterprise data security, stable development is particularly important. Whether the server has good reliability, high performance, scalability, security and manageability is the key to the development of enterprise benefits. Database server to support redundant technology, at the same time, such as hard disk, memory, network card and other such devices to be stable and durable, the server processor frequency, how fast processing data, the cache has a direct impact on the database, whether compatible with multiple systems, directly affect the future development of enterprise choice space. Therefore, the database-oriented enterprises (forum, electricity, ERP, etc.) in the purchase of the server to the above five aspects as the purchase benchmark.