A migration method based on postgresql block storage device

Abstract

A migration method based on a PostgreSQL block storage device, using a PostgreSQL block storage device read-write module to perform read and write operations to PostgreSQL blocks, the PostgreSQL block storage device read-write module managing, by means of an idle PostgreSQL block table and a table of mapping relationship between the PostgreSQL blocks and data tables, the PostgreSQL blocks in the PostgreSQL block storage device, copying the idle PostgreSQL block table and the table of mapping relationships between the PostgreSQL blocks and the data tables from an original database to a new database, and migrating the PostgreSQL block storage device from the computer in which the original database is located to the computer in which the new database is located. Migrating database between different systems by means of the migration method based on the PostgreSQL block storage device is easy, without a high requirement for the professional knowledge to operators. The query speed and the read-write speed can be improved, the speeds being improved by 10%-20% under the same condition of backend storage.

Description

technical field [0001] The invention relates to a migration method of a PostgreSQL database storage device, in particular to a migration method based on a PostgreSQL block storage device. Background technique [0002] With the development of the Internet, mobile Internet and the Internet of Things, we have ushered in an era of massive data, and more and more data are stored in the database, but the query time we need is getting smaller and smaller. Many application scenarios today require background storage with high concurrency, high capacity, and high response. The high-speed storage requirements force us to give up real-time indexing, and the data scanning of large data volumes is limited by the I / O on the storage side. In the current PostgreSQL database system, high-concurrency multi-database scans are basically random reads. At the same time, the throughput of ordinary disks can no longer meet the demand. [0003] In order to adapt to the application scenarios with a ...

AI Technical Summary

Problems solved by technology

[0023] First, the migration of databases between different systems is extremely complicated and requires high professional knowledge of operators

[0024] Second, the use of the disk must go through the file system layer

[0028] Third, the expansion of the file system is also very troublesome

[0029] Fourth, the database data files are directly exposed to the operating system, and there are potential security risks in the data, so data security cannot be guaranteed. This is a huge security hole for some use environments that require a high level of security.

Images