Postgresql database cluster system mixedly using solid state drives and hard disk drive and optimizing method thereof

Abstract

The invention discloses a structural frame of a postgresql database cluster system mixedly using solid state drives and a hard disk drive and an optimizing method based on the system. The cluster system comprises an inquiry distribution server containing cluster software used for inquiring and distributing and a plurality of database servers containing postgresql databases, wherein the servers are all located in a local area network and mutually connected through networks with high bandwidth. One of the postgresql database servers serves as a main server node which uses the hard disk drive, and the others serve as auxiliary server nodes which use the solid state drives. The inquiry distribution server is used for receiving and preprocessing inquiry of users and distributing the inquiry to specific single anode in a database cluster. The optimizing method performs some improvement on inquiry distribution cluster software, and provides a new inquiry preprocessing and distribution method, thereby better using the existing cluster framework and improving performance of the database cluster. Simultaneously, the optimizing method improves a copy strategy for data copying cluster software, and provides a new copy strategy favorable for using the advantages of the solid state drives.

Description

technical field [0001] The invention relates to a general database cluster system composed of common servers, in particular to a method for using a solid-state disk in the database cluster system and optimizing the entire system. Background technique [0002] The database cluster system combines the cluster technology with the database system, and consists of a complete set of autonomous computing processing units (nodes), each node has its own hardware resources such as CPU, memory, and disk, and runs an independent operating system and autonomous The database system is interconnected through a high-speed dedicated network or a commercial general-purpose network, and cooperates with each other in computing, and provides parallel transaction processing services as a unified database system. [0003] The database cluster system emphasizes the collaboration and parallel processing of the cluster system. Its core idea is to hide the delay that has a great impact on database per...

AI Technical Summary

Problems solved by technology

However, solid-state drives also have some defects. Compared with strong random read, continuous read, and continuous write capabilities, the random write capability of solid-state drives is very weak, similar to traditional hard drives, because random writes of solid-state drives will bring a lot of erasing operations, and continuous writing can minimize the impact of erasing operations, so the application system using solid-state drives should make some special configurations according to the characteristics of solid-state drives to take advantage of the advantages of solid-state drives and improve the performance of the application system. The performance of the traditional hard disk cannot be used to use the solid state disk

Images