CN107247744A - A kind of quick establishment and the efficient database that manages are for the method in storehouse - Google Patents
A kind of quick establishment and the efficient database that manages are for the method in storehouse Download PDFInfo
- Publication number
- CN107247744A CN107247744A CN201710352140.9A CN201710352140A CN107247744A CN 107247744 A CN107247744 A CN 107247744A CN 201710352140 A CN201710352140 A CN 201710352140A CN 107247744 A CN107247744 A CN 107247744A
- Authority
- CN
- China
- Prior art keywords
- database
- storehouse
- virtual machine
- standby
- operating system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/256—Integrating or interfacing systems involving database management systems in federated or virtual databases
Abstract
The present invention relates to database technical field, disclose a kind of quick establishment and efficiently management database, for the method in storehouse, comprises the following steps：(1) database correspondence Edition operating system mirror image and database mirroring are found from zfs resource pools；(2) virtual machine is created in the server using the system image created in step (1), and operating system mirror image and database mirroring in step (1) are added in virtual machine, so as to obtain a virtual machine for being mounted with database；(3) start the database in virtual machine, pull-up virtual machine as standby storehouse, and main and standby relation is set up with target master library；(4) increased according to database master library data volume, while the hardware device in the standby storehouse of extension.The present invention has good autgmentability simultaneously, and with the growth of business, the capacity and pressure of master library can be increasing, it is thus only necessary to which related zfs storage volume, which is extended, just can quickly realize the dilatation of each disk size in standby storehouse.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of quick establishment and efficiently management database are for storehouse
Method.
Background technology
In today of information-based high speed development, data already turn into the medium of most worthy, are responsible for storing data
The database of management turns into the core of enterprise, is that database building is the necessary hand for ensureing database High Availabitity and disaster tolerance for storehouse
Section, therefore safeguard that the standby storehouse of database also turns into the important process of corporate IT departments.DBA carrys out pipe with the knowledge and experience of oneself
Database platform is managed, during which the establishment to standby storehouse and management work is completed by installing related software by hand and performing fragmentary script
Make, with virtualization technology and the development of storage correlation technique in recent years, with the more efficient creative management number of these technologies
It is inexorable trend according to the standby Kucheng in storehouse.
But, management database is to enter by the DBA of enterprise with the knowledge and experience of oneself for the traditional approach in storehouse
Capable, from buying hardware to installation operation system and database management platform, flow is numerous and diverse, time-consuming very long, and period is all DBA
Completed manually or by fragmentary script, a large amount of manpower effectivenesses of waste also easily malfunction while low, more can not be to pipe
The standby storehouse of reason is more flexibly used, and it is played bigger effect.
The content of the invention
There is provided a kind of quick wound for the management shortcoming that database efficiency is low, flow is complicated in the prior art by the present invention
Build and efficiently manage database for the method in storehouse.
In order to solve the above-mentioned technical problem, the present invention is addressed by following technical proposals.
A kind of quick establishment and efficient management database comprise the following steps for the method in storehouse：
(1) database correspondence Edition operating system mirror image and database mirroring are found from zfs resource pools；
(2) virtual machine is created in the server using the system image created in step (1), and will be operated in step (1)
System image and database mirroring are added in virtual machine, so as to obtain a virtual machine for being mounted with database；
(3) start the database in virtual machine, pull-up virtual machine as standby storehouse, and main and standby relation is set up with target master library；
(4) increased according to database master library data volume, while the hardware device in the standby storehouse of extension.
Preferably, type of database includes RedHat, Oracle and MySQL in zfs resource pools.
Preferably, virtual machine includes operating system disk, database software and data disks.
Preferably, hardware device includes CPU core number, memory size and storage dish capacity.
The present invention is as a result of above technical scheme, with significant technique effect：
1st, the speed for creating standby storehouse is greatly improved, especially for needing the number to variety classes and different demands
Created according to storehouse and complete to exclude the time for purchasing hardware and transmission data for building for storehouse under standby storehouse, normal mode, only from installation
Operating system, installation data library software dynamic each process for building standby storehouse in one's hands probably needs one day even several days time, and adopts
Only need to even a few minutes more than ten minutes with this programme automation establishment, and in view of database total amount and species increase with
And the human error of DBA personnel, the advantage of this programme will be apparent from.
2nd, while having good autgmentability, with the growth of business, the capacity and pressure of master library can be increasing, and this
Scheme would be much more convenient for the extension of capacity and performance, it is thus only necessary to which related zfs storage volume is extended just can be quick
The standby storehouse of realization in each disk size dilatation.
Brief description of the drawings
Fig. 1 is a kind of quick establishment of the present invention and efficiently management database creates schematic diagram for master library in the method in storehouse.
Embodiment
The present invention is further described in detail with embodiment below in conjunction with the accompanying drawings.
Embodiment 1
As shown in figure 1, a kind of quick establishment and efficient management database comprise the following steps for the method in storehouse：.
A kind of quick establishment and efficient management database comprise the following steps for the method in storehouse：
(1) database correspondence Edition operating system mirror image and database mirroring are found from zfs resource pools；
(2) virtual machine is created in the server using the system image created in step (1), and will be operated in step (1)
System image and database mirroring are added in virtual machine, so as to obtain a virtual machine for being mounted with database；
(3) start the database in virtual machine, pull-up virtual machine as standby storehouse, and main and standby relation is set up with target master library；
(4) increased according to database master library data volume, while the hardware device in the standby storehouse of extension.
Type of database includes RedHat, Oracle and MySQL in zfs resource pools.
Virtual machine includes operating system disk, database software and data disks.
Hardware device includes CPU core number, memory size and storage dish capacity.
The present invention has advantages below：
1st, the speed for creating standby storehouse is greatly improved, especially for needing the number to variety classes and different demands
Created according to storehouse and complete to exclude the time for purchasing hardware and transmission data for building for storehouse under standby storehouse, normal mode, only from installation
Operating system, installation data library software dynamic each process for building standby storehouse in one's hands probably needs one day even several days time, and adopts
Only need to even a few minutes more than ten minutes with this programme automation establishment, and in view of database total amount and species increase with
And the human error of DBA personnel, the advantage of this programme will be apparent from.
2nd, while having good autgmentability, with the growth of business, the capacity and pressure of master library can be increasing, and this
Scheme would be much more convenient for the extension of capacity and performance, it is thus only necessary to which related zfs storage volume is extended just can be quick
The standby storehouse of realization in each disk size dilatation.
In a word, presently preferred embodiments of the present invention, all equalizations made according to scope of the present invention patent be the foregoing is only
Change and modification, should all belong to the covering scope of patent of the present invention.
Claims (4)
1. a kind of quick establishment and efficiently management database are for the method in storehouse, it is characterised in that comprise the following steps：
(1) database correspondence Edition operating system mirror image and database mirroring are found from zfs resource pools；
(2) virtual machine is created in the server using the system image created in step (1), and by operating system in step (1)
Mirror image and database mirroring are added in virtual machine, so as to obtain a virtual machine for being mounted with database；
(3) start the database in virtual machine, pull-up virtual machine as standby storehouse, and main and standby relation is set up with target master library；
(4) increased according to database master library data volume, while the hardware device in the standby storehouse of extension.
2. a kind of quick establishment according to claim 1 and efficiently management database are for the method in storehouse, it is characterised in that：
Type of database includes RedHat, Oracle and MySQL in zfs resource pools.
3. a kind of quick establishment according to claim 1 and efficiently management database are for the method in storehouse, it is characterised in that：It is empty
Plan machine includes operating system disk, database software and data disks.
4. a kind of quick establishment according to claim 1 and efficiently management database are for the method in storehouse, it is characterised in that：Firmly
Part equipment includes CPU core number, memory size and storage dish capacity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710352140.9A CN107247744A (en) | 2017-05-18 | 2017-05-18 | A kind of quick establishment and the efficient database that manages are for the method in storehouse |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710352140.9A CN107247744A (en) | 2017-05-18 | 2017-05-18 | A kind of quick establishment and the efficient database that manages are for the method in storehouse |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107247744A true CN107247744A (en) | 2017-10-13 |
Family
ID=60016628
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710352140.9A Pending CN107247744A (en) | 2017-05-18 | 2017-05-18 | A kind of quick establishment and the efficient database that manages are for the method in storehouse |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107247744A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102629224A (en) * | 2012-04-26 | 2012-08-08 | 广东电子工业研究院有限公司 | Method and device of integrated data disaster recovery based on cloud platform |
| CN103164295A (en) * | 2013-03-22 | 2013-06-19 | 危子彪 | Enterprise information technology (IT) business virtualization disaster recovery method based on zettabyte file system (ZFS) and kernel-based virtual machine (KVM) kernel virtual underlying system |
| CN105468625A (en) * | 2014-09-04 | 2016-04-06 | 中国石油化工股份有限公司 | Database cluster constructing method by using virtual machine |
| US9983936B2 (en) * | 2014-11-20 | 2018-05-29 | Commvault Systems, Inc. | Virtual machine change block tracking |
-
2017
- 2017-05-18 CN CN201710352140.9A patent/CN107247744A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102629224A (en) * | 2012-04-26 | 2012-08-08 | 广东电子工业研究院有限公司 | Method and device of integrated data disaster recovery based on cloud platform |
| CN103164295A (en) * | 2013-03-22 | 2013-06-19 | 危子彪 | Enterprise information technology (IT) business virtualization disaster recovery method based on zettabyte file system (ZFS) and kernel-based virtual machine (KVM) kernel virtual underlying system |
| CN105468625A (en) * | 2014-09-04 | 2016-04-06 | 中国石油化工股份有限公司 | Database cluster constructing method by using virtual machine |
| US9983936B2 (en) * | 2014-11-20 | 2018-05-29 | Commvault Systems, Inc. | Virtual machine change block tracking |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102843418B (en) | A kind of resource scheduling system | |
| CN102520972A (en) | Video game development system and method thereof | |
| JP2011516994A (en) | Data placement according to instructions to redundant data storage system | |
| CN104331285A (en) | Automatic code generation method and system | |
| CN1722086A (en) | API for programmatic retrieval and replay of database trace | |
| CN103235725A (en) | Linux-based rapid deployment method for Oracle database in cloud computing | |
| WO2016165597A1 (en) | Processing method and device for data storage | |
| CN103092742A (en) | Optimization method and system of program logging | |
| CN104965672A (en) | Method for automatically, rapidly and conveniently configuring RAID | |
| CN101067818A (en) | Data incremental backup and recovery method applied to data bank | |
| CN107122267A (en) | A kind of Windows operating system carry restoration methods | |
| CN105183516A (en) | Method for automatically installing RAID card FW and KUX operating system | |
| CN102316126A (en) | Keep watch on the system and the equipment of compression and transition state | |
| CN112199157B (en) | Cloud environment management method | |
| CN109992204A (en) | Date storage method and device | |
| CN105656970A (en) | RAID (Redundant Array of Independent Disk) card configuring method and system and relevant device | |
| CN103744710A (en) | Installation method and system of operating systems | |
| CN103761168A (en) | Method for mounting backup virtual machine based on nfs volume | |
| CN104657164B (en) | Software upgrading treating method and apparatus | |
| CN104142943B (en) | A kind of data-base capacity-enlarging method and a kind of database | |
| CN105357055A (en) | Operation management system used for database server and method | |
| CN106372160A (en) | Distributive database and management method | |
| US9588707B2 (en) | Object storage power consumption optimization | |
| CN103678240A (en) | Method and system for modularized management of distributed computation | |
| CN101997919B (en) | Storage resource management method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171013 |