CN111414348A - Method and device for modifying database instance parameters - Google Patents
Method and device for modifying database instance parameters Download PDFInfo
- Publication number
- CN111414348A CN111414348A CN201910014699.XA CN201910014699A CN111414348A CN 111414348 A CN111414348 A CN 111414348A CN 201910014699 A CN201910014699 A CN 201910014699A CN 111414348 A CN111414348 A CN 111414348A
- Authority
- CN
- China
- Prior art keywords
- parameter
- instance
- parameters
- modifying
- database
- 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
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000012986 modification Methods 0.000 claims abstract description 123
- 230000004048 modification Effects 0.000 claims abstract description 123
- 238000012795 verification Methods 0.000 claims abstract description 25
- 238000012423 maintenance Methods 0.000 claims description 24
- 230000003068 static effect Effects 0.000 claims description 7
- 230000006870 function Effects 0.000 description 13
- 238000010586 diagram Methods 0.000 description 9
- 238000007726 management method Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 9
- 238000004590 computer program Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- VYPSYNLAJGMNEJ-UHFFFAOYSA-N silicon dioxide Inorganic materials O=[Si]=O VYPSYNLAJGMNEJ-UHFFFAOYSA-N 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 230000008447 perception Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000010453 quartz Substances 0.000 description 1
- 238000013515 script Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Automation & Control Theory (AREA)
- Stored Programmes (AREA)
Abstract
The application discloses a method and a device for modifying database instance parameters, wherein the method comprises the following steps: determining a database instance parameter modification task, wherein the parameter modification task comprises a database instance of a parameter to be modified, and the parameter modification task is configured with an immediate execution mode or a timing execution mode; determining the parameters meeting the check rule as the operable parameters in the database examples of the parameters to be modified; and according to the parameter modification task conforming to the verification rule, modifying the operable parameters of the database instance into parameter target values. The method can execute the parameter modification task at regular time, modify the parameters in the database instance in batch and ensure the safety of parameter modification.
Description
Technical Field
The invention relates to the field of databases, in particular to a method and a device for modifying database instance parameters.
Background
With the continuous development of information technology, the service scale and the service form are diversified, more and more database instances are needed, the database instances are a layer of data management software located between a user and an operating system, and the user performs any operation on data in the database, including data definition, data query, data maintenance, database operation control and the like, under the database instances.
At present, a great number of database examples of operation and maintenance management are available, and in order to meet business requirements, when capacity expansion or optimization is required, generally, operation and maintenance personnel log in a bastion machine or a springboard machine uniformly, and then log in a target server through the bastion machine or the springboard machine to perform maintenance and operation, so as to modify corresponding parameters in the examples.
However, when each instance is modified, the user needs to remember information such as a user name, a password, a port and the like when the instance is connected to the target server through the bastion machine and the springboard machine, if the number of the instances is large, repeated operation is caused, the process is complex, and parameters can be mistakenly operated.
Disclosure of Invention
In view of the foregoing defects or shortcomings in the prior art, it is desirable to provide a method and an apparatus for modifying database instance parameters, which can solve the problems of complicated database instance parameter modification process and repeated steps, which result in parameter misoperation.
In a first aspect, the present invention provides a method for modifying a parameter of a database instance, the method including:
determining a database instance parameter modification task, wherein the parameter modification task comprises a database instance of a parameter to be modified, and the parameter modification task is configured with an immediate execution mode or a timing execution mode;
determining the parameters meeting the check rule as the operable parameters in the database examples of the parameters to be modified;
and according to the parameter modification task conforming to the verification rule, modifying the operable parameters of the database instance into parameter target values.
In one embodiment, modifying the operable parameter of the database instance to a parameter target value according to the parameter modification task includes:
judging whether the instance in the parameter modification task passes the verification;
and when the instance passes the verification, calling an automatic operation and maintenance tool to modify the operable parameters of the database instance into parameter target values.
In one embodiment, the determining whether the instance in the parameter modification task passes the check includes:
determining a current unverified example in the parameter modification task;
circularly executing specified operation until the current unverified example is verified and locked;
the specifying operation includes:
judging whether the current unverified instance is locked or not;
if the operation is locked, continuing to determine the next unverified instance from the parameter modification task, and controlling to enter the next specified operation; if not, judging whether the unverified instance information is correct or not;
if the instance information is correct, the current unverified instance is verified and locked; and if the instance information is incorrect, continuing to determine the next unverified instance from the parameter modification task, and controlling to execute the next specified operation.
In one embodiment, invoking an automated operation and maintenance tool to modify an operational parameter of the database instance to a parameter target value further comprises:
determining a parameter type of the operational parameter; the parameter types comprise dynamic parameters and static parameters;
and determining a modification result and unlocking the instance according to the parameter type.
In one embodiment, when the parameter modification task is a timed execution, the method further comprises:
determining the timing execution time of the parameter modification task;
and scheduling the parameter modification task through a task scheduler according to the timing execution time.
In a second aspect, an embodiment of the present application provides an apparatus for modifying a parameter of a database instance, where the apparatus includes:
the system comprises a first determining module, a second determining module and a parameter modifying module, wherein the first determining module is used for determining a database instance parameter modifying task, the parameter modifying task comprises a database instance of a parameter to be modified, and the parameter modifying task is configured into an immediate execution mode or a timing execution mode;
the second determining module is used for determining the parameters meeting the check rule as the operable parameters in the database examples of the parameters to be modified;
and the modification module is used for modifying the operable parameters of the database instance into parameter target values according to the parameter modification tasks conforming to the verification rules.
In one embodiment, the second determining module is configured to determine the parameter that meets the check rule as an operable parameter in the database instance of the parameter to be modified.
In one embodiment, the modification module includes:
the judging unit is used for judging whether the instance in the parameter modification task passes the verification;
and the modifying unit is used for calling the automatic operation and maintenance tool to modify the parameters of the database when the instance passes the verification.
In one embodiment, the determining unit is specifically configured to determine a current unverified instance in the parameter modification task;
circularly executing specified operation until the current unverified example is verified and locked;
the specifying operation includes:
judging whether the current unverified instance is locked or not;
if the operation is locked, continuing to determine the next unverified instance from the parameter modification task, and controlling to enter the next specified operation; if not, judging whether the unverified instance information is correct or not;
if the instance information is correct, the current unverified instance is verified and locked; and if the instance information is incorrect, continuing to determine the next unverified instance from the parameter modification task, and controlling to execute the next specified operation.
In one embodiment, the modifying unit is further configured to determine a parameter type of the operational parameter; the parameter types comprise dynamic parameters and static parameters;
and determining a modification result and unlocking the instance according to the parameter type.
In one embodiment, the apparatus further comprises:
the third determining module is used for determining the timing execution time of the parameter modification task;
and the scheduling module is used for scheduling the parameter modification task through a task scheduler according to the timing execution time.
According to the method and the device for modifying the database instance parameters, the database instance parameter modification task is determined, the parameter modification task is configured with an immediate execution mode or a timing execution mode, the operable parameters in the database instance of the parameters to be modified are determined, and the operable parameters in the database instance are modified into the parameter target values according to the parameter modification task.
Drawings
Other features, objects and advantages of the present application will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, made with reference to the accompanying drawings in which:
FIG. 1 is a flowchart illustrating a method for modifying parameters of an example database according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating a method for modifying parameters of an example database according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating a method for modifying parameters of an example database according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of an apparatus for modifying parameters of an example database according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The present application will be described in further detail with reference to the following drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the relevant invention and not restrictive of the invention. It should be noted that, for convenience of description, only the portions related to the present invention are shown in the drawings.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict.
As mentioned in the background, in the process of diversified development of service scale and service form, there are more and more database instances managed by operation and maintenance, in order to meet service requirements, such as capacity expansion and optimization, parameters of some instances need to be modified, in order to protect the target server from being connected by external devices, a proxy server needs to be connected to the target server, the proxy server may be a bastion machine or a jump board machine, and the specific process is that an operation and maintenance person firstly logs in the bastion machine or the jump board machine through an ip address, a user name and a password, and logs in the target server through another ip address, a user name and a password on the bastion machine or the jump board machine, and further modifies database instance parameters, however, the process is complicated, and if there are many database instances, many times of repeated operation are needed, and in the parameter modification process, the risk of misoperation also exists.
Based on the defects, the embodiment of the invention provides a method for modifying database instance parameters, which comprises the steps of receiving a database instance parameter modification task, determining the operable parameters in the database instance of the parameters to be modified, and modifying the operable parameters of the database instance according to the parameter modification task.
The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
It should be noted that the execution subject of the following method embodiments may be a modification device of the database instance parameters, and the device may be implemented as part or all of the terminal device by software, hardware, or a combination of software and hardware. The execution subjects of the method embodiments described below are described taking a computer device as an example.
Fig. 1 is a schematic flow chart of a method for modifying parameters of an example database according to an embodiment of the present invention, as shown in fig. 1, the method includes:
step S101, determining a database instance parameter modification task, wherein the parameter modification task comprises a database instance of a parameter to be modified, and the parameter modification task is configured into an immediate execution mode or a timing execution mode.
Specifically, a database instance can be managed through a thinkDB platform, the database instance comprises information such as physical ip, an instance name, a port and a database version, the thinkDB is a perception database system, and is a database system which is based on a real-time database technology and an innovative data model theory and faces to the information perception requirements of scattered, multivariate and dynamic sensors and equipment and can manage data; optionally, the parameter modification task may be configured to be in a timing execution mode or an immediate execution mode according to a service requirement, where the timing execution mode is to execute the parameter modification task at a target time point.
The parameter modification task can be a database instance, a parameter and a parameter target value which are modified on line by a user based on a webpage end, wherein the database instance comprises a database instance of the parameter to be modified, the parameter is a standard parameter in the database, and the parameter target value is a value after the parameter is modified.
It should be noted that, assuming that there are 100 database instances that need operation and maintenance, the information of the 100 database instances may be managed through the ThinkDB platform, and the operation and maintenance personnel may select the database instance of the parameter to be modified on the operation interface according to the managed instance information and the service requirement, so as to form a task of modifying the parameter.
Optionally, the ThinkDB platform may include modules such as a point table management module, a real-time query module, a history query module, a data subscription module, and an alarm management module, where the point table management module may sense a management function of a data list in the database, and the management function includes addition, modification, deletion, list import, list export, and the like of the list, the real-time query module may query real-time data in a plurality of lists, the history query module may query history data in each list, the data subscription module is a change of real-time monitoring data, the alarm management module may set an alarm threshold for corresponding data, and alarm information is generated when the data exceeds the threshold. The thindb platform may obtain the database instance list in the parameter modification task through the point table management module, select the database instance of the parameter to be modified through the modules such as real-time query and historical query, determine the parameter in the database instance to be modified, modify the parameter into the parameter target value, and automatically alarm and prompt when the parameter target value exceeds the threshold value through the alarm management module, thereby accurately modifying the parameter of the database instance.
Optionally, the parameter modification task may include different database types and database versions.
And step S102, determining the parameters meeting the verification rules as operable parameters in the database examples of the parameters to be modified.
Specifically, a check rule may be set according to the type of the database and the version of the database, and a parameter that meets the check rule is determined as an operable parameter in the database instance of the parameter to be modified. The database type can be mysql database or oracle database, the same type of database may correspond to different versions of the database, and different types of databases and versions of the database may correspond to different check rules.
For example, the check rule may include a parameter type, wherein the check rule may be formed by setting a parameter type value, determining a parameter with a parameter type value of 1 as an operable parameter in the database instance, and taking a parameter with a parameter type value of 0 as an inoperable parameter, for example, the parameter type value may be set to 1 for a mysql database with a version of 5.7, and the parameter type value may be set to 0 for a mysql database with a version of 8.0, that is, a parameter representing a mysql database with a version of 5.7 may be determined as an operable parameter.
It should be noted that, by setting the check rule, the operation and maintenance personnel can only operate the operable parameters opened by the administrator, and misoperation of other parameters is avoided, so that standardized processing of operation and maintenance operation is realized, and security of database instance parameter modification is ensured.
And S103, modifying the operable parameters of the database instance into parameter target values according to the parameter modification tasks meeting the verification rules.
Specifically, after a parameter modification task is received, whether an instance in the parameter modification task passes verification can be judged, and after the instance passes verification, parameter modification is performed by calling an automated operation and maintenance tool, wherein the automation tool is developed based on Python, the advantages of a plurality of operation and maintenance tools are integrated, functions of batch system configuration, batch program deployment, batch execution commands and the like can be realized.
It should be noted that, before executing the parameter modification task, it may be determined that the parameter modification task is executed immediately or at regular time, and when the parameter modification task is executed immediately, the parameter in the database instance is modified directly by calling ansable according to the database type and the database version and modifying the parameter in the database instance to a parameter target value according to the parameter modification task; when the above-mentioned parameter modification task is executed periodically, the following steps shown in fig. 2 may be executed:
step S201, determining the timing execution time of the parameter modification task.
And step S202, scheduling the parameter modification task through a task scheduler according to the timing execution time.
Specifically, when the service requirement indicates that the parameter modification task needs to be executed at a certain time, that is, the timing execution time of the parameter modification task may be determined first, and when the device detects that the timing execution time has been reached, the parameter modification task is scheduled to the automation operation and maintenance tool through a task scheduler, so that the automation operation and maintenance tool executes the parameter modification task at a fixed time, where the task scheduler may be a Quartz framework.
It should be noted that the parameter modification task may be a timed execution time edited by an operation and maintenance worker on an operation interface of a web page, and the user may set to immediately execute the parameter modification task or execute the parameter modification task at a timed time by a user-defined setting.
According to the method for modifying the database instance parameters, the database instance parameter modification task is received, the parameter modification task is executed immediately or at regular time, the operable parameters in the database instance of the parameters to be modified are determined, and the operable parameters of the database instance are modified according to the parameter modification task.
Fig. 3 is a flowchart illustrating a method for determining whether an instance in a parameter modification task passes verification according to an embodiment of the present invention. As shown in fig. 3, the method includes:
s301, determining a current unverified example in the parameter modification task;
circularly executing specified operation until the current unverified example is verified and locked;
the specifying operation includes:
step S302, judging whether the current unverified example is locked or not;
if the operation is locked, continuing to execute the step S301, determining the next unverified instance from the parameter modification task, and controlling to enter the next specified operation;
if not, executing step S303, and judging whether the unverified instance information is correct;
if the instance information is correct, executing the step S304, checking to pass and locking the current unverified instance;
if the instance information is not correct, the step S301 is continued, the next unverified instance is determined from the parameter modification task, and the next specified operation is controlled to be executed.
Specifically, after the parameter modification task is obtained, a current unverified instance can be determined, and whether the current unverified instance is locked or not is judged, that is, whether the current unverified instance is operated by other functions of thindb or not is judged, the other functions can be functions of reconstruction, addition and the like, if the current unverified instance is judged to be unlocked or not, that is, not operated by other functions, whether the current unverified instance information is correct or not is further judged, that is, information such as a maintained physical ip address, port information and whether the instance is correctly connected or not is detected; if the current unverified instance is locked, the next unverified instance is determined to be the current unverified instance from the parameter modification task.
Further, when the information of the current unverified example is judged to be correct, the current unverified example is indicated to pass the verification, and the current unverified example is locked; and when the information of the current unverified example is judged to be incorrect, continuously determining the next unverified example as the current unverified example from the parameter modification task, and further verifying.
It should be noted that, after the instance passes the verification and is locked, the automatic operation and maintenance tool is called to modify the parameters, wherein, according to the type of the database, the parameters of the database can be modified to be the target parameter values by calling different processing scripts.
In the process of modifying the parameter, the parameter type of the operable parameter may be determined first, and optionally, the parameter type may be determined by a parameter type value, for example, a parameter type value of 1 indicates a static parameter, and a parameter type value of 0 indicates a dynamic parameter; if the operable parameters comprise static parameters, the file values are required to be modified and the database is restarted, wherein the file values can be address tables; when the operable parameters only comprise dynamic parameters, only the memory value and the file value need to be modified, the modification result is determined, whether the modification is successful or not can be returned and displayed on a corresponding interface, and the instance can be unlocked after the modification result is returned.
According to the method for modifying the database instance parameters, whether the current unverified instance is locked or not and whether the instance information is correct or not are judged, so that the instance is guaranteed not to be operated by other functions of the Th i nkDB, parameter modification of multiple instances can be processed in batch, the risk of parameter misoperation is avoided, normalized operation and maintenance data management is achieved, and the working efficiency is further improved.
It should be noted that while the operations of the method of the present invention are depicted in the drawings in a particular order, this does not require or imply that the operations must be performed in this particular order, or that all of the illustrated operations must be performed, to achieve desirable results. Rather, the steps depicted in the flowcharts may change the order of execution. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step execution, and/or one step broken down into multiple step executions.
Fig. 4 is a schematic structural diagram of a parameter modification apparatus of a database example according to an embodiment of the present invention. As shown in fig. 4, the apparatus may implement the methods shown in fig. 1 to 3, and may include:
a first determining module 10, configured to determine a database instance parameter modification task, where the parameter modification task includes a database instance of a parameter to be modified, and the parameter modification task configures an immediate execution mode or a timed execution mode;
a second determining module 20, configured to determine a parameter that meets a check rule as an operable parameter in the database instance of the parameter to be modified;
and the modification module 30 is used for modifying the operable parameters of the database instance into parameter target values according to the parameter modification tasks meeting the verification rules.
Preferably, the modification module 30 includes:
a judging unit 301, configured to judge whether an instance in the parameter modification task passes verification;
a modifying unit 302, configured to invoke an automation operation and maintenance tool to modify the operable parameter of the database instance to a parameter target value when the instance passes the verification.
Preferably, the determining unit 301 is specifically configured to determine a current unverified instance in the parameter modification task;
circularly executing specified operation until the current unverified example is verified and locked;
the specifying operation includes:
judging whether the current unverified instance is locked or not;
if the operation is locked, continuing to determine the next unverified instance from the parameter modification task, and controlling to enter the next specified operation; if not, judging whether the unverified instance information is correct or not;
if the instance information is correct, the current unverified instance is verified and locked; and if the instance information is incorrect, continuing to determine the next unverified instance from the parameter modification task, and controlling to execute the next specified operation.
Preferably, the modifying unit 302 is further configured to determine a parameter type of the operational parameter; the parameter types comprise dynamic parameters and static parameters;
and determining a modification result and unlocking the instance according to the parameter type.
Preferably, the apparatus further comprises:
a third determining module 40, configured to determine a timing execution time of the parameter modification task;
and the scheduling module 50 is configured to schedule the parameter modification task through a task scheduler according to the timing execution time.
The modification apparatus for database instance parameters provided in this embodiment may implement the embodiments of the method described above, and the implementation principle and technical effect are similar, which are not described herein again.
Fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present invention. As shown in fig. 5, a schematic structural diagram of a computer system 500 suitable for implementing the terminal device or the server of the embodiment of the present application is shown.
As shown in fig. 5, the computer system 500 includes a Central Processing Unit (CPU)501 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage section 508 into a Random Access Memory (RAM) 503. In the RAM503, various programs and data necessary for the operation of the system 500 are also stored. The CPU501, ROM502, and RAM503 are connected to each other via a bus 504. An input/output (I/O) interface 506 is also connected to bus 504.
To the I/O interface 505, AN input section 506 including a keyboard, a mouse, and the like, AN output section 507 including a keyboard such as a Cathode Ray Tube (CRT), a liquid crystal display (L CD), and the like, a speaker, and the like, a storage section 508 including a hard disk and the like, and a communication section 509 including a network interface card such as a L AN card, a modem, and the like, the communication section 509 performs communication processing via a network such as the internet, a drive 510 is also connected to the I/O interface 506 as necessary, a removable medium 511 such as a magnetic disk, AN optical disk, a magneto-optical disk, a semiconductor memory, and the like is mounted on the drive 510 as necessary, so that a computer program read out therefrom is mounted into the storage section 508 as necessary.
In particular, the processes described above with reference to fig. 1-3 may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program tangibly embodied on a machine-readable medium, the computer program comprising program code for performing the method of fig. 1-3. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 509, and/or installed from the removable medium 511. The above-described functions defined in the system of the present application are executed when the computer program is executed by the Central Processing Unit (CPU) 501.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units or modules described in the embodiments of the present application may be implemented by software or hardware. The described units or modules may also be provided in a processor, and may be described as: a processor includes a receiving module, a first determining module, and a modifying module. Where the names of such units or modules do not in some cases constitute a limitation of the unit or module itself, for example, a receiving module may also be described as "receiving a database instance parameter modification task including a database instance of a parameter to be modified, the parameter modification task including immediate or timed execution.
As another aspect, the present application also provides a computer-readable medium, which may be contained in the electronic device described in the above embodiments; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs, which when executed by an electronic device, cause the electronic device to implement the method for modifying the database instance parameters as described in the above embodiments.
For example, the electronic device may implement the following as shown in fig. 1: step S101, determining a database instance parameter modification task, wherein the parameter modification task comprises a database instance of a parameter to be modified, and the parameter modification task is configured with an immediate execution mode or a timing execution mode; step S102, determining the parameters meeting the check rule as the operable parameters in the database example of the parameters to be modified; and step S103, modifying the operable parameters of the database instance into parameter target values according to the parameter modification tasks meeting the verification rules. As another example, the electronic device may implement the various steps shown in fig. 2 and 3.
It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.
Moreover, although the steps of the methods of the present disclosure are depicted in the drawings in a particular order, this does not require or imply that the steps must be performed in this particular order, or that all of the depicted steps must be performed, to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step execution, and/or one step broken down into multiple step executions, etc. Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein may be implemented by software, or by software in combination with necessary hardware.
Claims (10)
1. A method for modifying parameters of a database instance, comprising:
determining a database instance parameter modification task, wherein the parameter modification task comprises a database instance of a parameter to be modified, and the parameter modification task is configured with an immediate execution mode or a timing execution mode;
determining the parameters meeting the check rule as the operable parameters in the database examples of the parameters to be modified;
and according to the parameter modification task conforming to the verification rule, modifying the operable parameters of the database instance into parameter target values.
2. The method for modifying the parameters of the database instance according to claim 1, wherein the step of modifying the operational parameters of the database instance into parameter target values according to the parameter modification task comprises:
judging whether the instance in the parameter modification task passes the verification;
and when the instance passes the verification, calling an automatic operation and maintenance tool to modify the operable parameters of the database instance into parameter target values.
3. The method for modifying parameters of a database instance according to claim 2, wherein said determining whether the instance in the task of modifying parameters passes the verification comprises:
determining a current unverified instance in the parameter modification task;
circularly executing specified operation until the current unverified example is verified and locked;
the specifying operation includes:
judging whether the current unverified instance is locked or not;
if the operation is locked, continuing to determine the next unverified instance from the parameter modification task, and controlling to enter the next specified operation; if not, judging whether the unverified instance information is correct or not;
if the instance information is correct, the current unverified instance is verified and locked; and if the instance information is incorrect, continuing to determine the next unverified instance from the parameter modification task, and controlling to execute the next specified operation.
4. The method for modifying the parameters of the database instance according to claim 2, wherein an automated operation and maintenance tool is invoked to modify the operational parameters of the database instance into parameter target values, further comprising:
determining a parameter type of the operational parameter; the parameter types comprise dynamic parameters and static parameters;
and determining a modification result and unlocking the instance according to the parameter type.
5. The method for modifying parameters of a database instance according to claim 1, wherein when the task of modifying parameters is a timed execution, the method further comprises:
determining the timing execution time of the parameter modification task;
and scheduling the parameter modification task through a task scheduler according to the timing execution time.
6. An apparatus for modifying parameters of a database instance, the apparatus comprising:
the system comprises a first determining module, a second determining module and a parameter modifying module, wherein the first determining module is used for determining a database instance parameter modifying task, the parameter modifying task comprises a database instance of a parameter to be modified, and the parameter modifying task is configured into an immediate execution mode or a timing execution mode;
the second determining module is used for determining the parameters meeting the check rule as the operable parameters in the database examples of the parameters to be modified;
and the modification module is used for modifying the operable parameters of the database instance into parameter target values according to the parameter modification tasks conforming to the verification rules.
7. The apparatus for modifying database instance parameters according to claim 6, wherein said modification module comprises:
the judging unit is used for judging whether the instance in the parameter modification task passes the verification;
and the modifying unit is used for calling an automatic operation and maintenance tool to modify the operable parameters of the database instance into parameter target values when the instance passes the verification.
8. The apparatus according to claim 7, wherein the determining unit is specifically configured to determine a current unverified instance in a parameter modification task;
circularly executing specified operation until the current unverified example is verified and locked;
the specifying operation includes:
judging whether the current unverified instance is locked or not;
if the operation is locked, continuing to determine the next unverified instance from the parameter modification task, and controlling to enter the next specified operation; if not, judging whether the unverified instance information is correct or not;
if the instance information is correct, the current unverified instance is verified and locked; and if the instance information is incorrect, continuing to determine the next unverified instance from the parameter modification task, and controlling to execute the next specified operation.
9. The apparatus for modifying database instance parameters according to claim 7, wherein the modifying unit is further configured to determine a parameter type of the operational parameter; the parameter types comprise dynamic parameters and static parameters;
and determining a modification result and unlocking the instance according to the parameter type.
10. The apparatus for modifying parameters of database instances according to claim 6, further comprising:
the third determining module is used for determining the timing execution time of the parameter modification task;
and the scheduling module is used for scheduling the parameter modification task through a task scheduler according to the timing execution time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910014699.XA CN111414348A (en) | 2019-01-08 | 2019-01-08 | Method and device for modifying database instance parameters |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910014699.XA CN111414348A (en) | 2019-01-08 | 2019-01-08 | Method and device for modifying database instance parameters |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111414348A true CN111414348A (en) | 2020-07-14 |
Family
ID=71493921
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910014699.XA Pending CN111414348A (en) | 2019-01-08 | 2019-01-08 | Method and device for modifying database instance parameters |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111414348A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113360194A (en) * | 2021-05-22 | 2021-09-07 | 深圳市华芯飞通讯有限公司 | Python-based drive generation method and system and electronic equipment |
| CN113641396A (en) * | 2021-08-16 | 2021-11-12 | 杭州群核信息技术有限公司 | Method and device for modifying parameterized models in batches |
| CN115826430A (en) * | 2022-09-22 | 2023-03-21 | 宁德时代新能源科技股份有限公司 | Method, device and storage medium for modifying kinematic pair parameters |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5150308A (en) * | 1986-09-12 | 1992-09-22 | Digital Equipment Corporation | Parameter and rule creation and modification mechanism for use by a procedure for synthesis of logic circuit designs |
| US7305395B1 (en) * | 2002-04-24 | 2007-12-04 | Oracle International Corporation | Centralized storage and management of database parameters |
| US20110083138A1 (en) * | 2009-10-07 | 2011-04-07 | Swaminathan Sivasubramanian | Self-service configuration for data environment |
| CN106790131A (en) * | 2016-12-27 | 2017-05-31 | 中国建设银行股份有限公司 | A kind of parameter modification method, device and distributed platform |
| CN108829495A (en) * | 2018-05-08 | 2018-11-16 | 中国平安人寿保险股份有限公司 | Verification method, device, equipment and the storage medium of multiple database modification affairs |
-
2019
- 2019-01-08 CN CN201910014699.XA patent/CN111414348A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5150308A (en) * | 1986-09-12 | 1992-09-22 | Digital Equipment Corporation | Parameter and rule creation and modification mechanism for use by a procedure for synthesis of logic circuit designs |
| US7305395B1 (en) * | 2002-04-24 | 2007-12-04 | Oracle International Corporation | Centralized storage and management of database parameters |
| US20110083138A1 (en) * | 2009-10-07 | 2011-04-07 | Swaminathan Sivasubramanian | Self-service configuration for data environment |
| CN105302862A (en) * | 2009-10-07 | 2016-02-03 | 亚马逊技术股份有限公司 | Self-service configuration for data environment |
| CN106790131A (en) * | 2016-12-27 | 2017-05-31 | 中国建设银行股份有限公司 | A kind of parameter modification method, device and distributed platform |
| CN108829495A (en) * | 2018-05-08 | 2018-11-16 | 中国平安人寿保险股份有限公司 | Verification method, device, equipment and the storage medium of multiple database modification affairs |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113360194A (en) * | 2021-05-22 | 2021-09-07 | 深圳市华芯飞通讯有限公司 | Python-based drive generation method and system and electronic equipment |
| CN113641396A (en) * | 2021-08-16 | 2021-11-12 | 杭州群核信息技术有限公司 | Method and device for modifying parameterized models in batches |
| CN113641396B (en) * | 2021-08-16 | 2024-08-13 | 杭州群核信息技术有限公司 | Method and device for modifying parameterized models in batches |
| CN115826430A (en) * | 2022-09-22 | 2023-03-21 | 宁德时代新能源科技股份有限公司 | Method, device and storage medium for modifying kinematic pair parameters |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210383291A1 (en) | Mainframe workflow manager system and method | |
| CN106469068B (en) | Application program deployment method and system | |
| CN108846630A (en) | A kind of resource control system and method | |
| US20140006459A1 (en) | Rule-based automated test data generation | |
| CN111414348A (en) | Method and device for modifying database instance parameters | |
| CN111190892B (en) | Method and device for processing abnormal data in data backfilling | |
| CN113361838A (en) | Business wind control method and device, electronic equipment and storage medium | |
| CN110971464A (en) | Operation and maintenance automatic system suitable for disaster recovery center | |
| CN112380255A (en) | Service processing method, device, equipment and storage medium | |
| CN114035925A (en) | Workflow scheduling method, device and equipment and readable storage medium | |
| CN113792341A (en) | Privacy compliance automation detection method, device, equipment and medium for application program | |
| CN115437933A (en) | Automatic testing method and device, computer equipment and storage medium | |
| CN111813377A (en) | Method and device for automatically generating application program | |
| EP4152151A1 (en) | Multi-cloud resource scheduler | |
| CN104217145B (en) | Limit the method that specific user accesses the predetermined portions of manufacturing execution system screen | |
| CN113778771B (en) | Terminal testing method, system and storage medium | |
| CN116894556B (en) | Product production demand management method, device, equipment and storage medium | |
| CN113407973A (en) | Software function authority management method, system, server and storage medium | |
| CN109408104B (en) | Method and device for acquiring game integration information | |
| KR20150124653A (en) | System for monitoring and controling electric power system for process verification | |
| CN115509714A (en) | Task processing method and device, electronic equipment and storage medium | |
| CN115757097A (en) | Test case generation method and device, electronic equipment and storage medium | |
| CN112231231B (en) | Cloud service debugging method, system and device | |
| CN114675948A (en) | DAG data model dynamic scheduling method and system | |
| CN113886215A (en) | Interface test method, device and storage medium |
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: 20200714 |