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: 2010-09-22
BEIJING XINWANG RUIJIE NETWORK TECH CO LTD
View PDF4 Cites 18 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

[0024] figure 1 It is a flow chart of the method for expanding the storage space of the database provided by the embodiment of the present invention. Such as figure 1 As shown, the method includes:

[0025] Step 11. When the server starts, the operating system detects whether a new hard disk is mounted;

[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=cy...

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 Applications(China)
IPC IPC(8): G06F3/06G06F17/30
Inventor 杨杰
Owner BEIJING XINWANG RUIJIE NETWORK TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap