CN110362556A - Operating method, system, equipment and the medium of database - Google Patents
Operating method, system, equipment and the medium of database Download PDFInfo
- Publication number
- CN110362556A CN110362556A CN201910629289.6A CN201910629289A CN110362556A CN 110362556 A CN110362556 A CN 110362556A CN 201910629289 A CN201910629289 A CN 201910629289A CN 110362556 A CN110362556 A CN 110362556A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- space
- data structure
- new
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is more particularly directed to the operating method of database, system, equipment and media.Database includes first database and the second database, and the data of the second database are synchronous with the holding of the data of first database, and method includes: to receive the space housekeeping instruction and/or data structure alteration command of database;According to the space housekeeping instruction and/or data structure alteration command of database, space housekeeping operation and/or data structure change operation are carried out on the second database;The second database after operation is switched to new first database, and first database is switched to the second new database;According to the space housekeeping instruction and/or data structure alteration command of database, space housekeeping operation and/or data structure change operation are carried out on the second new database.The characteristic of present invention combination cloud can eliminate the consumption of additional CPU, memory, disk etc. while more saving resource and cost, short to the influence time of business, and eliminate synchronous delay.
Description
Technical field
The present invention relates to database fields, the in particular to operating method, system, equipment and medium of database.
Background technique
The space junk of database will cause the waste in space, also the response time of database can be made elongated.It is existing frequently-used
The space method for sorting of database include following two.
The first is directly to operate on the database, is arranged with carrying out the space of database.This method may need to lock
Data structure, the data being locked during whole operation can not modify, so as to influence the normal of database
It uses.In addition, this method needs additional CPU, memory, disk etc., on original database performance, there may be influences.Most
Afterwards, there may be biggish delay between principal and subordinate's data.
Second is operated in a manner of detour some tools, is arranged with carrying out the space of database.Similarly, should
Method may also need locking data structure, and the data being locked during whole operation can not modify, so as to
It can influence the normal use of database.In addition, this method is also required to additional CPU, memory, disk etc., to original database
There may be influences for performance.Finally, may also have biggish delay between principal and subordinate's data.
Similarly, the data structure variation of existing frequently-used database also includes above two, these methods are also deposited
In above-mentioned defect.
Summary of the invention
The purpose of the present invention is to provide the operating method of database, system, equipment and media can in conjunction with the characteristic of cloud
The consumption of additional CPU, memory, disk etc. is eliminated, to the influence time of business while more saving resource and cost
It is short, and eliminate synchronous delay.
The invention discloses a kind of operating method of database, database includes first database and the second database, and
The data of two databases are synchronous with the holding of the data of first database, and method includes:
Receive the space housekeeping instruction and/or data structure alteration command of database;
According to the space housekeeping instruction and/or data structure alteration command of database, space is carried out on the second database
Housekeeping operation and/or data structure change operation;
The second database after operation is switched to new first database, and first database is switched to new
Two databases;
According to the space housekeeping instruction and/or data structure alteration command of database, carried out on the second new database
Space housekeeping operation and/or data structure change operation.
Optionally, before the second database after operating is switched to new first database, after determining operation the
Whether the data of two databases are synchronous with the holding of the data of first database;If it is, the second database after operation is cut
It is changed to new first database;If it is not, then updating the data of the second database after operation with the data with first database
It keeps synchronizing, and updated second database is switched to new first database.
Optionally, by virtual IP address, the second database after operation is switched to new first database, and by first
Database is switched to the second new database.
The invention discloses a kind of operating system of database, database includes first database and the second database, and
The data of two databases are synchronous with the holding of the data of first database, and system includes receiving module, operation module and switching module;
The space housekeeping instruction and/or data structure alteration command of receiving module reception database;
Operation module is according to the space housekeeping instruction and/or data structure alteration command of database, on the second database
Carry out space housekeeping operation and/or data structure change operation;
The second database after operation is switched to new first database by switching module, and first database is switched
For the second new database;
Operation module is counted also according to the space housekeeping instruction and/or data structure alteration command of database new second
According to progress space housekeeping operation and/or data structure change operation on library.
Optionally, system further includes determining module and update module;The second database after operation is cut in switching module
Be changed to before new first database, determining module determine operation after the second database data whether with first database
Data keep synchronizing;If it is, the second database after operation is switched to new first database by switching module;If
No, then the data of the second database after update module update operation are with synchronous with the holding of the data of first database, and cut
It changes the mold block and updated second database is switched to new first database.
Optionally, the second database after operation is switched to new first database by virtual IP address by switching module, and
And first database is switched to the second new database.
The invention discloses a kind of operation equipment of database, equipment includes being stored with the storage of computer executable instructions
Device and processor, processor are configured as executing instruction the operating method with implementation database, and database includes first database
Synchronous with the holding of the data of first database with the data of the second database, the second database, method includes:
Receive the space housekeeping instruction and/or data structure alteration command of database;
According to the space housekeeping instruction and/or data structure alteration command of database, space is carried out on the second database
Housekeeping operation and/or data structure change operation;
The second database after operation is switched to new first database, and first database is switched to new
Two databases;
According to the space housekeeping instruction and/or data structure alteration command of database, carried out on the second new database
Space housekeeping operation and/or data structure change operation.
The invention discloses a kind of computer storage medium using computer program code, computer program includes referring to
It enables, instruction is executed by more than one computer with the operating method of implementation database, and database includes first database and the
The data of two databases, the second database are synchronous with the holding of the data of first database, and method includes:
Receive the space housekeeping instruction and/or data structure alteration command of database;
According to the space housekeeping instruction and/or data structure alteration command of database, space is carried out on the second database
Housekeeping operation and/or data structure change operation;
The second database after operation is switched to new first database, and first database is switched to new
Two databases;
According to the space housekeeping instruction and/or data structure alteration command of database, carried out on the second new database
Space housekeeping operation and/or data structure change operation.
Compared with prior art, the present invention the main distinction and its effect are:
Firstly, data can be arranged according to the database high availability scheme (or active and standby scheme) of offers equal on cloud in the present invention
Library, database include first database and the second database, and the data of the second database and the data of first database keep same
Step, wherein first database can be primary database, and the second database can be from database (or backup database), Yong Huke
To be operated in first database, additional CPU, memory, disk can be eliminated while more saving resource and cost
Deng consumption, and eliminate synchronous delay.
Secondly, the present invention refers to when space housekeeping instruction and/or the data structure change for receiving database from the user
When enabling, which is sent to the second database, and according to the instruction, space housekeeping operation is carried out on the second database
And/or the second database after operation is switched to newly by data structure change operation after operating to the second database
First database, and first database is switched to the second new database, user can be in new first database
It continues operation, it is short to the influence time of business.
Again, first database after being switched to the second new database by the present invention, according to above-mentioned database
Space housekeeping instruction and/or data structure alteration command carry out space housekeeping operation and/or data on the second new database
Structure change operation, so that the second new database and new first database are all according to the space housekeeping instruction of database
And/or data structure alteration command has carried out space housekeeping operation and/or data structure change operation, guarantees two databases
Data space and/or data structure are consistent.
If finally, the present invention is carrying out space housekeeping operation and/or data structure change operation phase to the second database
Between, when receiving the instructions such as read-write from the user, which is sent to first database, so that user still can be the
The operation such as it is written and read on one database.Before the second database after operating is switched to new first database, determine
Whether the data of the second database after operation are synchronous with the holding of the data of first database, if it is not, then after updating operation
The data of second database are with synchronous with the holding of the data of first database, to arrange behaviour carrying out space to the second database
During work and/or data structure change operation, the operations such as read-write carried out in first database by user can be updated to
The second database after operation.After updated second database is switched to new first database, user can be
It is continued operation in new first database, it is short to the influence time of business.
Detailed description of the invention
Fig. 1 is the hardware block diagram of the terminal of the operating method of database of the invention;
Fig. 2 is the schematic diagram of the operating method of the database of first embodiment according to the present invention;
Fig. 3 is the flow diagram of the operating method of the database of first embodiment according to the present invention;
Fig. 4 is the structural schematic diagram of the operating system of the database of second embodiment according to the present invention.
Specific embodiment
To keep purpose and the technical solution of the embodiment of the present invention clearer, below in conjunction with the attached of the embodiment of the present invention
Figure, is clearly and completely described the technical solution of the embodiment of the present invention.Obviously, described embodiment is of the invention
A part of the embodiment, instead of all the embodiments.Based on described the embodiment of the present invention, those of ordinary skill in the art
Every other embodiment obtained, shall fall within the protection scope of the present invention under the premise of being not necessarily to creative work.
Embodiment there is provided a kind of embodiments of the operating method of database according to the present invention, it should be noted that
Step shown in the flowchart of the accompanying drawings can execute in a computer system such as a set of computer executable instructions, and
It, in some cases, can be to be different from sequence execution institute herein and although logical order is shown in flow charts
The step of showing or describing.
Method implementation provided by the application mode can be held in mobile terminal, terminal or server
Row.For running on computer terminals, Fig. 1 is the computer of the operating method of the database of embodiment according to the present invention
The hardware block diagram of terminal.As shown in Figure 1, terminal 100 may include one or more (only showing one in figure)
(processor 101 can include but is not limited to central processor CPU, image processor GPU, digital signal processor to processor 101
The processing unit of DSP, Micro-processor MCV or programmable logic device FPGA etc.), the input/output interface for being interacted with user
102, memory 103 for storing data and the transmitting device 104 for communication function, processor 101, input and output
Interface 102, memory 103 and transmitting device 104 are connected to each other via bus 105.Those of ordinary skill in the art can manage
Solution, structure shown in FIG. 1 are only to illustrate, and do not cause to limit to the structure of above-mentioned electronic device.For example, terminal
100 may also include than shown in Fig. 1 more perhaps less component or with the configuration different from shown in Fig. 1.
Memory 103 can be used for storing data library, queue, application software software program and module, such as present invention is real
Corresponding program instruction/the module of operating method of the database in mode is applied, processor 101 is stored in memory by operation
Software program and module in 103 realize above-mentioned database thereby executing various function application and data processing
Operating method.Memory 103 may include high speed random access memory, may also include nonvolatile memory, such as one or more
Magnetic storage device, flash memory or other non-volatile solid state memories.In some instances, memory 103 can be wrapped further
The memory remotely located relative to processor 101 is included, these remote memories can pass through network connection to terminal
100.The example of above-mentioned network includes but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Transmitting device 104 is used to that data to be received or sent via network, and network may include various connection types, such as
Wired, wireless communication link or fiber optic cables etc..Above-mentioned network specific example may include the communication of terminal 100
The internet that supplier provides.
The first embodiment of the present invention is related to a kind of operating method of database, database includes first database and
The data of two databases, the second database are synchronous with the holding of the data of first database.
Fig. 2 is the schematic diagram of the operating method of the database.Specifically, as shown in Fig. 2, according to the data of offers equal on cloud
Library high availability scheme (or active and standby scheme) is arranged database, and database includes first database A1 and the second database A2, and
The data of two database A2 are synchronous with the holding of the data of first database A1, and wherein first database A1 can be primary database,
Second database A2 can be for from database (or backup database), user can operate on first database A1, can
To eliminate the consumption of additional CPU, memory, disk etc., and eliminate synchronous prolong while more saving resource and cost
When.
It can be switched between first database A1 and the second database A2 by virtual IP address (VIP).When receiving
When the space housekeeping instruction and/or data structure alteration command of database from the user, which is sent to the second data
Library A2, and according to the instruction, space housekeeping operation and/or data structure change operation are carried out on the second database A2,
After operating to the second database A2, the second database A2 after operation is switched to new first database A1, and
First database A1 is switched to the second new database A2, user can continue to grasp on new first database A1
Make, it is short to the influence time of business.
After first database A1 to be switched to the second new database A2, arranged according to the space of above-mentioned database
Instruction and/or data structure alteration command, carry out space housekeeping operation on the second new database A2 and/or data structure becomes
It more operates, so that the second new database A2 and new first database A1 are according to the space housekeeping instruction of database
And/or data structure alteration command has carried out space housekeeping operation and/or data structure change operation, guarantees two databases
Data space and/or data structure are consistent.
If received during carrying out space housekeeping operation and/or data structure change operation to the second database A2
When the instructions such as read-write from the user, which is sent to first database A1, so that user still can be in the first data
The operation such as it is written and read on the A1 of library.Before the second database A2 after operating is switched to new first database A1, determine
Whether the data of the second database A2 after operation are synchronous with the holding of the data of first database A1, if it is not, then updating operation
The data of the second database A2 afterwards are with synchronous with the holding of the data of first database A1, to carry out to the second database A2
During space housekeeping operation and/or data structure change operation, the operation such as read-write carried out on first database A1 by user
The second database A2 after operation can be updated to.Updated second database A2 is being switched to new first database
After A1, user can continue operation on new first database A1, short to the influence time of business.
Fig. 3 is the flow diagram of the operating method of the database.Specifically, as shown in figure 3, the operation side of the database
Method the following steps are included:
Step 302, the space housekeeping instruction and/or data structure alteration command of database are received;
Step 304, according to the space housekeeping instruction of database and/or data structure alteration command, on the second database
Carry out space housekeeping operation and/or data structure change operation;
Step 306, the second database after operation is switched to new first database, and first database is switched
For the second new database;
Step 308, according to the space housekeeping instruction of database and/or data structure alteration command, in the second new data
Space housekeeping operation and/or data structure change operation are carried out on library.
Wherein, database is arranged according to the database high availability scheme (or active and standby scheme) of offers equal on cloud, database
Including first database and the second database, the data of the second database are synchronous with the holding of the data of first database, wherein the
One database can be primary database, and the second database can be for from database (or backup database), user can be first
It is operated on database, disappearing for additional CPU, memory, disk etc. can be eliminated while more saving resource and cost
Consumption, and eliminate synchronous delay.
Wherein it is possible to be switched between first database and the second database by virtual IP address.It is come from when receiving
When the space housekeeping instruction and/or data structure alteration command of the database of user, which is sent to the second database, and
And according to the instruction, space housekeeping operation and/or data structure change operation are carried out on the second database, to the second data
After library is operated, the second database after operation is switched to new first database, and first database is switched
For the second new database, user can continue operation in new first database, short to the influence time of business.
Wherein, after first database to be switched to the second new database, the space according to above-mentioned database is whole
Reason instruction and/or data structure alteration command, carry out space housekeeping operation on the second new database and/or data structure becomes
More operate, thus the second new database and new first database all according to the space housekeeping instruction of database and/or
Data structure alteration command has carried out space housekeeping operation and/or data structure change operation, guarantees the data of two databases
Space and/or data structure are consistent.
Optionally, before the second database after operating is switched to new first database, after determining operation the
Whether the data of two databases are synchronous with the holding of the data of first database;If it is, the second database after operation is cut
It is changed to new first database;If it is not, then updating the data of the second database after operation with the data with first database
It keeps synchronizing, and updated second database is switched to new first database.
Wherein, it if during carrying out space housekeeping operation and/or data structure change operation to the second database, receives
To when the instructions such as read-write from the user, which is sent to first database, so that user still can be in the first data
The operation such as it is written and read on library.Before the second database after operating is switched to new first database, after determining operation
The second database data it is whether synchronous with the holding of the data of first database, if it is not, then update operation after second number
According to the data in library with synchronous with the holding of the data of first database, thus to the second database carry out space housekeeping operation and/
Or during data structure change operation, after the operations such as read-write carried out in first database by user can be updated to operation
The second database.After updated second database is switched to new first database, user can be new
It is continued operation on one database, it is short to the influence time of business.
Optionally, by virtual IP address, the second database after operation is switched to new first database, and by first
Database is switched to the second new database.
Wherein, the space housekeeping instruction of above-mentioned database from the user and/or data structure are changed by virtual IP address
Instruction is sent to the second database, sends first database for instructions such as above-mentioned read-writes from the user, and will be after operation
The second database be switched to new first database, and first database is switched to the second new database.
Second embodiment of the present invention is related to a kind of operating system of database, and database includes first database and
The data of two databases, the second database are synchronous with the holding of the data of first database.
Fig. 4 is the structural schematic diagram of the operating system of the database.Specifically, as shown in figure 4, the operation system of the database
System includes receiving module, operation module and switching module.
The space housekeeping instruction and/or data structure alteration command of receiving module reception database;
Operation module is according to the space housekeeping instruction and/or data structure alteration command of database, on the second database
Carry out space housekeeping operation and/or data structure change operation;
The second database after operation is switched to new first database by switching module, and first database is switched
For the second new database;
Operation module is counted also according to the space housekeeping instruction and/or data structure alteration command of database new second
According to progress space housekeeping operation and/or data structure change operation on library.
Optionally, system further includes determining module and update module;The second database after operation is cut in switching module
Be changed to before new first database, determining module determine operation after the second database data whether with first database
Data keep synchronizing;If it is, the second database after operation is switched to new first database by switching module;If
No, then the data of the second database after update module update operation are with synchronous with the holding of the data of first database, and cut
It changes the mold block and updated second database is switched to new first database.
Optionally, the second database after operation is switched to new first database by virtual IP address by switching module, and
And first database is switched to the second new database.
First embodiment is method implementation corresponding with present embodiment, and present embodiment can be implemented with first
Mode is worked in coordination implementation.The relevant technical details mentioned in first embodiment are still effective in the present embodiment, in order to
It reduces and repeats, which is not described herein again.Correspondingly, the relevant technical details mentioned in present embodiment are also applicable in the first implementation
In mode.
Third embodiment of the present invention is related to a kind of operation equipment of database, and equipment includes being stored with computer to hold
The memory and processor of row instruction, processor are configured as executing instruction the operating method with implementation database, database packet
First database and the second database are included, the data of the second database are synchronous with the holding of the data of first database, and method includes:
Receive the space housekeeping instruction and/or data structure alteration command of database;
According to the space housekeeping instruction and/or data structure alteration command of database, space is carried out on the second database
Housekeeping operation and/or data structure change operation;
The second database after operation is switched to new first database, and first database is switched to new
Two databases;
According to the space housekeeping instruction and/or data structure alteration command of database, carried out on the second new database
Space housekeeping operation and/or data structure change operation.
First embodiment is method implementation corresponding with present embodiment, and present embodiment can be implemented with first
Mode is worked in coordination implementation.The relevant technical details mentioned in first embodiment are still effective in the present embodiment, in order to
It reduces and repeats, which is not described herein again.Correspondingly, the relevant technical details mentioned in present embodiment are also applicable in the first implementation
In mode.
4th embodiment of the invention is related to a kind of computer storage medium using computer program code, computer
Program includes instruction, and instruction is executed by more than one computer with the operating method of implementation database, and database includes first
The data of database and the second database, the second database are synchronous with the holding of the data of first database, and method includes:
Receive the space housekeeping instruction and/or data structure alteration command of database;
According to the space housekeeping instruction and/or data structure alteration command of database, space is carried out on the second database
Housekeeping operation and/or data structure change operation;
The second database after operation is switched to new first database, and first database is switched to new
Two databases;
According to the space housekeeping instruction and/or data structure alteration command of database, carried out on the second new database
Space housekeeping operation and/or data structure change operation.
First embodiment is method implementation corresponding with present embodiment, and present embodiment can be implemented with first
Mode is worked in coordination implementation.The relevant technical details mentioned in first embodiment are still effective in the present embodiment, in order to
It reduces and repeats, which is not described herein again.Correspondingly, the relevant technical details mentioned in present embodiment are also applicable in the first implementation
In mode.
It should be noted that each method embodiment of the invention can be realized in a manner of software, hardware, firmware etc..
Regardless of the present invention is realized in a manner of software, hardware or firmware, instruction code may be stored in any kind of computer
In addressable memory (such as permanent perhaps revisable volatibility is perhaps non-volatile solid or non-solid
State, fix or replaceable medium etc.).Equally, memory may, for example, be programmable logic array
(Programmable Array Logic, referred to as " PAL "), random access memory (Random Access Memory, referred to as
" RAM "), programmable read only memory (Programmable Read Only Memory, referred to as " PROM "), read-only memory
(Read-Only Memory, referred to as " ROM "), electrically erasable programmable read-only memory (Electrically Erasable
Programmable ROM, referred to as " EEPROM "), disk, CD, digital versatile disc (Digital Versatile Disc,
Referred to as " DVD ") etc..
It should be noted that each unit/the module mentioned in each equipment embodiment of the present invention is all logic unit/mould
Block, physically, a logic unit can be a physical unit, are also possible to a part of a physical unit, may be used also
With with the combination of multiple physical units realization, the Physical realization of these logic units itself be not it is most important, these
The combination for the function that logic unit is realized is only the key for solving technical problem proposed by the invention.In addition, for protrusion
Innovative part of the invention, the above-mentioned each equipment embodiment of the present invention is not by the technical problem proposed by the invention with solution
The less close unit of relationship introduces, this does not indicate above equipment embodiment and there is no other units.
It should be noted that in the claim and specification of this patent, such as first and second or the like relationship
Term is only used to distinguish one entity or operation from another entity or operation, without necessarily requiring or implying
There are any actual relationship or orders between these entities or operation.Moreover, the terms "include", "comprise" or its
Any other variant is intended to non-exclusive inclusion so that include the process, methods of a series of elements, article or
Equipment not only includes those elements, but also including other elements that are not explicitly listed, or further include for this process,
Method, article or the intrinsic element of equipment.In the absence of more restrictions, being wanted by what sentence " including one " limited
Element, it is not excluded that there is also other identical elements in the process, method, article or apparatus that includes the element.
Although being shown and described to the present invention by referring to some of the preferred embodiment of the invention,
It will be understood by those skilled in the art that can to it, various changes can be made in the form and details, without departing from this hair
Bright spirit and scope.
Claims (8)
1. a kind of operating method of database, which is characterized in that the database includes first database and the second database, institute
The data for stating the second database are synchronous with the holding of the data of the first database, which comprises
Receive the space housekeeping instruction and/or data structure alteration command of the database;
According to the space housekeeping instruction of the database and/or the data structure alteration command, in second data
Space housekeeping operation and/or data structure change operation are carried out on library;
Second database after operation is switched to new first database, and the first database is switched to newly
The second database;
According to the space housekeeping instruction of the database and/or the data structure alteration command, in second newly
Space housekeeping operation and/or data structure change operation are carried out on database.
2. the method according to claim 1, wherein new second database after operation to be switched to
Before first database, whether the data of second database after determining operation keep with the data of the first database
It is synchronous;If it is, second database after operation is switched to new first database;If it is not, then updating operation
The data of second database afterwards are with synchronous with the holding of the data of the first database, and by updated described
Two databases are switched to new first database.
3. the method according to claim 1, wherein by virtual IP address, by second database after operation
It is switched to new first database, and the first database is switched to the second new database.
4. a kind of operating system of database, which is characterized in that the database includes first database and the second database, institute
The data for stating the second database are synchronous with the holding of the data of the first database, and the system comprises receiving modules, operation mould
Block and switching module;
The receiving module receives the space housekeeping instruction and/or data structure alteration command of the database;
The space housekeeping instruction and/or the data structure alteration command of the operation module according to the database,
Space housekeeping operation and/or data structure change operation are carried out on second database;
Second database after operation is switched to new first database by the switching module, and described first is counted
The second new database is switched to according to library;
The space housekeeping instruction and/or the data structure alteration command of the operation module also according to the database,
Space housekeeping operation and/or data structure change operation are carried out on the second new database.
5. system according to claim 4, which is characterized in that the system also includes determining modules and update module;?
Before second database after operation is switched to new first database by the switching module, the determining module is determined
Whether the data of second database after operation are synchronous with the holding of the data of the first database;If it is, described
Second database after operation is switched to new first database by switching module;If it is not, then the update module is more
The data of second database after new operation are with synchronous with the holding of the data of the first database, and the switching mould
Updated second database is switched to new first database by block.
6. system according to claim 4, which is characterized in that the switching module is by virtual IP address, by the institute after operation
It states the second database and is switched to new first database, and the first database is switched to the second new database.
7. a kind of operation equipment of database, which is characterized in that the equipment includes being stored with depositing for computer executable instructions
Reservoir and processor, the processor is configured to executing described instruction with the operating method of implementation database, the database
Including first database and the second database, the data of second database and the data of the first database keep same
Step, which comprises
Receive the space housekeeping instruction and/or data structure alteration command of the database;
According to the space housekeeping instruction of the database and/or the data structure alteration command, in second data
Space housekeeping operation and/or data structure change operation are carried out on library;
Second database after operation is switched to new first database, and the first database is switched to newly
The second database;
According to the space housekeeping instruction of the database and/or the data structure alteration command, in second newly
Space housekeeping operation and/or data structure change operation are carried out on database.
8. a kind of computer storage medium using computer program code, which is characterized in that the computer program includes referring to
It enables, described instruction is executed by more than one computer with the operating method of implementation database, and the database includes the first number
According to library and the second database, the data of second database and synchronous, the method for the data of first database holding
Include:
Receive the space housekeeping instruction and/or data structure alteration command of the database;
According to the space housekeeping instruction of the database and/or the data structure alteration command, in second data
Space housekeeping operation and/or data structure change operation are carried out on library;
Second database after operation is switched to new first database, and the first database is switched to newly
The second database;
According to the space housekeeping instruction of the database and/or the data structure alteration command, in second newly
Space housekeeping operation and/or data structure change operation are carried out on database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910629289.6A CN110362556A (en) | 2019-07-12 | 2019-07-12 | Operating method, system, equipment and the medium of database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910629289.6A CN110362556A (en) | 2019-07-12 | 2019-07-12 | Operating method, system, equipment and the medium of database |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110362556A true CN110362556A (en) | 2019-10-22 |
Family
ID=68218933
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910629289.6A Pending CN110362556A (en) | 2019-07-12 | 2019-07-12 | Operating method, system, equipment and the medium of database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110362556A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113051248A (en) * | 2021-03-22 | 2021-06-29 | 中国工商银行股份有限公司 | Defragmentation method, device and equipment based on master-slave database and storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106611062A (en) * | 2016-12-29 | 2017-05-03 | 北京奇虎科技有限公司 | Database updating method and device |
CN107015885A (en) * | 2016-07-12 | 2017-08-04 | 阿里巴巴集团控股有限公司 | Service providing method, system and configuration center when primary standby data storehouse switches |
CN107632906A (en) * | 2017-09-30 | 2018-01-26 | 北京九桥同步软件有限公司 | Database data backup method and device |
US20180341560A1 (en) * | 2017-05-23 | 2018-11-29 | International Business Machines Corporation | Service outage time reduction for a planned event in a system |
-
2019
- 2019-07-12 CN CN201910629289.6A patent/CN110362556A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107015885A (en) * | 2016-07-12 | 2017-08-04 | 阿里巴巴集团控股有限公司 | Service providing method, system and configuration center when primary standby data storehouse switches |
CN106611062A (en) * | 2016-12-29 | 2017-05-03 | 北京奇虎科技有限公司 | Database updating method and device |
US20180341560A1 (en) * | 2017-05-23 | 2018-11-29 | International Business Machines Corporation | Service outage time reduction for a planned event in a system |
CN107632906A (en) * | 2017-09-30 | 2018-01-26 | 北京九桥同步软件有限公司 | Database data backup method and device |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113051248A (en) * | 2021-03-22 | 2021-06-29 | 中国工商银行股份有限公司 | Defragmentation method, device and equipment based on master-slave database and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10713088B2 (en) | Event-driven scheduling using directed acyclic graphs | |
US10171377B2 (en) | Orchestrating computing resources between different computing environments | |
EP3418877B1 (en) | Data writing and reading method and apparatus, and cloud storage system | |
US9003414B2 (en) | Storage management computer and method for avoiding conflict by adjusting the task starting time and switching the order of task execution | |
CN109684099B (en) | Message processing method and device | |
CN110673941B (en) | Migration method of micro-services in multiple computer rooms, electronic equipment and storage medium | |
US11228508B2 (en) | Virtual network function bus-based auto-registration | |
US11265253B2 (en) | Network resource management for hyperconverged infrastructures | |
US10732967B1 (en) | Safe deployment of configurations to server fleets | |
CN110445828B (en) | Data distributed processing method based on Redis and related equipment thereof | |
CN109739435B (en) | File storage and updating method and device | |
US10038571B2 (en) | Method for reading and writing forwarding information base, and network processor | |
CN107797859B (en) | Scheduling method of timing task and scheduling server | |
CN109508912B (en) | Service scheduling method, device, equipment and storage medium | |
US10965750B2 (en) | Distributed management of dynamic processing element connections in streaming applications | |
CN104793981A (en) | Online snapshot managing method and device for virtual machine cluster | |
CN110362556A (en) | Operating method, system, equipment and the medium of database | |
CN117555966A (en) | Database master-slave synchronization method, device, equipment and readable storage medium | |
Rygielski et al. | Model-based throughput prediction in data center networks | |
CN110298031B (en) | Dictionary service system and model version consistency distribution method | |
CN117435569A (en) | Dynamic capacity expansion method, device, equipment, medium and program product for cache system | |
CN108073460A (en) | Global lock method for pre-emptively, device and computing device in distributed system | |
CN102868594A (en) | Method and device for message processing | |
CN112506705A (en) | Distributed storage configuration information backup method and device | |
WO2017109666A1 (en) | Distributed operating system functions for nodes in rack |
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 |
Application publication date: 20191022 |
|
RJ01 | Rejection of invention patent application after publication |