Unlock instant, AI-driven research and patent intelligence for your innovation.

Method, device and server for expanding storage space of database

A storage space and database technology, applied in the field of database storage, can solve the problem of expensive equipment

Inactive Publication Date: 2011-08-17
BEIJING XINWANG RUIJIE NETWORK TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of this method is that the equipment is expensive, far exceeding the price of ordinary hard drives with the same capacity

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method, device and server for expanding storage space of database
  • Method, device and server for expanding storage space of database
  • Method, device and server for expanding storage space of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] For example, the Linux system first reads the original hard disk information, and then uses the fdisk-1 command that comes with the system to obtain all the hard disk information in the current system. An example of the result of the fdisk -1 command is as follows:

[0027] Disk / dev / hda: 8589MB, 8589934592bytes

[0028] 255heads, 63sectors / track, 1044cylinders

[0029] Units=cylinders ofl6065*512=8225280bytes

[0030] Device Boot Start End Blocks Id System

[0031] / dev / hdal * 1 978 7855753+ 83 Linux

[0032] / dev / hda2 979 1043 522112+ 82 Linux swap

[0033] Disk / dev / hdb: 27MB, 27262976bytes

[0034] 16 heads, 63 sectors / track, 52 cylinders

[0035] Units=cylinders of 1008*512=516096bytes

[0036] Disk / dev / hdb doesn't contain a valid partition table

[0037] The above results show the information of two hard disks / dev / hda and / dev / hdb. Among them, / dev / hdb is a new hard disk, which has not yet been partitioned.

[0038] Step 12, if a new hard disk is detected...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a method, a device and a server for expanding storage space of a database, and the method comprises the following steps: detecting whether a new hard disk is mounted by utilizing an operation system after the server is started; if so, generating a script for partition by utilizing the operation system; executing the script to partitioning the new hard disk by utilizing the operation system; establishing a file system for the new hard disk by utilizing the operation system; loading the established file system in the operation system by utilizing the operation system; and expanding the storage space of the existing database according to the capability and the mount point of the new hard disk by utilizing a database space management module. The technical scheme can realize automatic expansion of the storage space of the database by detecting whether the new hard disk is mounted and loading the newly mounted hard disk and expanding the storage space of the existing database according to the capability and the mount point of the new hard disk by utilizing the operation system.

Description

technical field [0001] The invention relates to the technical field of database storage, in particular to a method and device for expanding a database storage space, and a server. Background technique [0002] In the Linux system, the space occupied by the database is also set at the same time as the establishment of the database. When storing data in the database, the data to be stored is automatically put into the corresponding space set. [0003] In practical applications, it often happens that the server where the database is located needs to be expanded due to insufficient hard disk capacity. In this case, the problem of insufficient hard disk capacity is often solved by adding a new hard disk to the server. [0004] In the prior art, since the database cannot automatically recognize the newly added hard disk, expansion by adding a new hard disk usually requires a lot of data migration work so that the data can be stored in the new hard disk. Or by purchasing a stora...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F3/06G06F17/30
Inventor 杨杰
Owner BEIJING XINWANG RUIJIE NETWORK TECH CO LTD