Basics: Database Server Purchase Considerations

In today's society, having data means having value, and database servers are of extraordinary importance to any company. After understanding the importance of the server, how should the company purchase a database server? What are the necessary conditions for these database servers?

Hardware redundancy
For ordinary desktops, the slightly important parts are not damaged. As long as there is a little damage, the machine will not work properly, and the server will be different. Servers above the department level generally have redundant services and have the following advantages:
There are multiple CPUs, one of which is broken, and in most cases the other can still work. Hard disk mirroring hot standby. The data on the server for many applications, if the loss is finished, it can be huge! Hard disk mirroring hot standby ensures that your data is not affected by a server's hard disk damage, and the server can still work.
The equipment is equipped with multiple power supply systems and two or more external power supplies. That is, one machine has two power plugs, and you can plug the two plugs into the power supply of two different power providers. When a power supplier has a problem, the server can still work normally. Multiple sets of power supply systems also ensure that one of the server's power supply components is broken, and the server can use another set to work properly.

High speed hard drive. The general server uses SCSI hard disks, which are several times or even dozens of times faster than ordinary hard disks. This can handle fast data reading and writing. Moreover, at present, hard disk mirroring hot standby is generally completed by the SCSI bus. A server with all of the above features is at least 20,000 or more at the current price level.

Higher multitasking capabilities

Ordinary personal computers generally use a single CPU, while servers are often dual CPUs or even 4 CPUs. The number of concurrent threads it can handle is Double to several times the personal machine. Moreover, the CPU of the server is generally better than the ordinary personal computer.

Ordinary desktops are mainly used for personal operations, surfing the Internet, playing games, making articles, and more. Under normal circumstances, no matter how you play, how many programs are opened at the same time, and the progress of the activity will not exceed two or thirty. When a server has hundreds or thousands of people submitting certain work requests to the server at the same time, the server has hundreds of thousands of threads. As far as the web server is concerned, if your website has thousands of concurrent visitors, your server may generate at least a few hundred concurrent threads. At this time, if it is a normal home desktop, it is basically slow.
If your website can reach an average of 200 people online at the same time, it is very scary, but this is not a muscle home computer can afford. If your website is just ready to play, the design goal is only online for hundreds of people at the same time, and a better personal computer can still stand it. For those online super stations, they use server groups to deal with the situation of more than one thousand people online at the same time, that is, using multiple machines to use clusters and other methods to deal with.
Stable and Huge Memory

The server needs to ensure stability first, so use memory with ECC (&########################### Although this kind of memory is slower than the memory we routinely use, its stability is definitely worthy of recognition, that is, the probability that data will go wrong in hardware due to hardware reasons will be much smaller.

In principle, the memory in the server should be as fast as possible, so that when there are hundreds or thousands of users accessing the server at the same time, in order for the machine to meet the user's memory consumption, the memory is not less. of. At the moment, most of them are 2G.