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

Database upgrading method and device

A database and data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problem that the database cannot be upgraded smoothly, and achieve the effect of satisfying data page compatibility and using requirements

Inactive Publication Date: 2018-05-01
GUANGDONG XIAOTIANCAI TECH CO LTD
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The embodiment of the present invention discloses a database upgrading method and device, which are used to solve the technical problem that the existing database cannot be smoothly upgraded

Method used

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database upgrading method and device
  • Database upgrading method and device
  • Database upgrading method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0072] see figure 1 , figure 1 It is a schematic flow diagram of the database upgrading method disclosed in the embodiment of the present invention; as figure 1 As shown, a database upgrade method may include:

[0073] 101. Install the target version database instance.

[0074] It can be understood that the target version database instance is installed in other servers than the server where the original version database instance is located, ie, the target server, and the target version database instance is configured to operate using the target version database (updated version database).

[0075] 102. Perform logical backup on the data of the original version database instance to obtain a logical backup file.

[0076] The original version database instance is installed in the original server different from the target server, and the original version database instance is configured to operate using the original version database. And configure the VIP address in the databas...

Embodiment 2

[0098] see Figure 2 to Figure 4 , figure 2 It is another schematic flowchart of the database upgrading method disclosed in the embodiment of the present invention, image 3It is a schematic diagram of generating a database instance disclosed in the embodiment of the present invention, Figure 4 It is a schematic diagram of database instance switching disclosed in the embodiment of the present invention. figure 2 In the database upgrading method shown, MySQL is taken as an example to describe, wherein, MySQL is a relational database management system in a client (Client) and server (Server) mode, and the database where the server is located is upgraded, specifically as follows figure 2 The database upgrade method shown may include the following steps:

[0099] 201. Install the stable target version of mysql 5.7 slave and keepalived thread on the target server. The VIP set is the same as the IP of the original server in the business code configuration, and the master-slav...

Embodiment 3

[0123] see Figure 5 , Figure 5 It is a schematic structural diagram of the database upgrading device disclosed in the embodiment of the present invention; as Figure 5 Shown, a kind of database upgrading device can comprise:

[0124] An installation unit 510, configured to install a target version database instance;

[0125] Logical backup unit 520, used for logically backing up the data of the original version database instance to obtain a logical backup file;

[0126] An import unit 530, configured to import the logical backup file into the database instance of the target version;

[0127] An upgrading unit 540, configured to start the database instance of the target version to upgrade the database;

[0128] The switching unit 550 is configured to close the database instance of the original version, and use the VIP address to switch services from the database instance of the original version to the database instance of the target version.

[0129] In the embodiment of...

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

PUM

No PUM Login to View More

Abstract

Embodiments of the invention relate to the technical field of processing of computers, and disclose a database upgrading method and device. The method comprises the steps of installing a database instance of a target version; performing logical backup on data of a database instance of an original version, and acquiring a logical backup file; importing the logical backup file into the database instance of the target version; starting the database instance of the target version to upgrade the database; and closing the database instance of the original version, switching a service from the database instance of the original version to the database instance of the target version by using a VIP address. Through adoption of the database upgrading method and device, the existing database is not stopped, the database is upgraded smoothly, cross-version database upgrading is realized, and service stability and product quality are ensured.

Description

technical field [0001] The invention relates to the technical field of computer processing, in particular to a database upgrading method and device. Background technique [0002] Database (Database) upgrade is a daily work of database operation and maintenance. The more common upgrade method includes the following steps: [0003] 1. Install the new version of the database instance; [0004] 2. Close the database instance of the new version and delete the data file directory of the database instance of the new version; [0005] 3. Suspend the operation of the database instance of the old version, back up the data and log files of the database instance of the old version, copy them to the database instance of the new version, and assign permissions to the database instance of the new version; [0006] 4. Start the database instance of the new version and perform the database upgrade. [0007] 5. Restart the database. [0008] The upgrade of the above-mentioned database is ...

Claims

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

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/219
Inventor 邓小兵
Owner GUANGDONG XIAOTIANCAI TECH CO LTD