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

A system and method for implementing smooth upgrade of mysql database

An implementation method and database technology, which are applied in the field of implementation systems for smooth upgrade of MySQL databases, can solve problems such as stopping database services for a long time, and achieve a wide range of effects.

Active Publication Date: 2015-09-02
BEIJING BYTEDANCE NETWORK TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] In order to improve the deficiencies of the above-mentioned prior art, the present invention provides a system and method for realizing smooth upgrade of MySQL database, so as to solve the problem that the database service needs to be stopped for a long time when upgrading the database

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
  • A system and method for implementing smooth upgrade of mysql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] Such as figure 1 Shown is the flow chart of the upgrade method of the present invention, the smooth upgrade method implemented by the present invention, the components involved are the active database service M and the transit database S, and the data synchronization between M and S is upgraded based on the MySQL Replication feature.

[0031] The specific implementation is as follows:

[0032] 1>. Initialize the transfer database S

[0033] Configure the transfer database S, the main configuration work includes initializing the operating system, configuring users and environment variables, installing new (target) version database software, configuring MySQL system parameters, and creating database services;

[0034] 2>. Configure MySQL Replication replication environment

[0035] Use the MySQL Replication feature to synchronize data between the source end and the transfer end. The specific steps are:

[0036] Configure the source M as the Master role to generate bina...

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

PUM

No PUM Login to View More

Abstract

The invention relates to an achievement system and an achievement method for my structured query language (My SQL) database smooth upgrading. The achievement method includes the following steps: (1) initializing a transfer database S; (2) configuring My SQL Replication environment; (3) checking data consistency of source end database service M and a target database S; (4) executing role switching by switching S to the new M; and (5) clearing the Replication environment. According to the achievement system and the achievement method, the front end application is completely transparent in the operation process, service is nearly not needed to be interrupted, upgrading operation is insensitive to versions of the databases, and therefore application range is wide.

Description

technical field [0001] The invention relates to a method for upgrading a database, in particular to a system and method for realizing a smooth upgrade of a MySQL database. Background technique [0002] The upgrade of the MySQL database is a very traditional requirement. The steps of the upgrade solution recommended by MySQL are as follows: [0003] 1) Suspend the currently running MySQL database service; [0004] 2) Install a new version of database software; [0005] 3) Execute the backup task and create a complete backup of the current database for recovery; [0006] 4) Start the database service: [0007] 5) Execute the mysql_upgrade upgrade command to update the objects in the database to the new version; [0008] The operation steps of this method are relatively simple, but the applicability is slightly poor. First, the official MySQL upgrade script has many restrictions on the version. For example, version 4.1 cannot be directly upgraded to version 5.1 or later, s...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 潘海东梅春李丙洋
Owner BEIJING BYTEDANCE NETWORK TECH CO LTD