WO2017177769A1 - Ogg version deployment method and system, server, and storage medium - Google Patents

Ogg version deployment method and system, server, and storage medium Download PDF

Info

Publication number
WO2017177769A1
WO2017177769A1 PCT/CN2017/074559 CN2017074559W WO2017177769A1 WO 2017177769 A1 WO2017177769 A1 WO 2017177769A1 CN 2017074559 W CN2017074559 W CN 2017074559W WO 2017177769 A1 WO2017177769 A1 WO 2017177769A1
Authority
WO
WIPO (PCT)
Prior art keywords
version
deployment
file
ogg
basic data
Prior art date
Application number
PCT/CN2017/074559
Other languages
French (fr)
Chinese (zh)
Inventor
秦豪
Original Assignee
平安科技（深圳）有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 平安科技（深圳）有限公司 filed Critical 平安科技（深圳）有限公司
Publication of WO2017177769A1 publication Critical patent/WO2017177769A1/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/445—Program loading or initiating
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/60—Software deployment
    • G06F8/65—Updates

Definitions

  • the present invention relates to the field of database technologies, and in particular, to an OGG version deployment method, system, server, and storage medium.
  • OGG Organic Golden Gate
  • an OGG version deployment method, system, server, and storage medium are provided.
  • An OGG version deployment method including:
  • the OGG deployment platform obtains the basic data required for the version deployment, and generates a configuration file according to the basic data in the configuration file, where the configuration file includes basic data required for version deployment;
  • the OGG deployment platform generates the link information, the parameter file, the SQL script, and the version type according to the basic data, and packages the link information, the parameter file, the SQL script, and the version type to generate a script file and sends the script file to the deployment directory.
  • the OGG deployment platform remotely executes the script file and deploys a version according to the script file.
  • An OGG version deployment system that includes:
  • a configuration file generating module configured to acquire basic data required for version deployment, and generate a configuration file according to the basic data, where the configuration file includes basic data required for version deployment;
  • a script file generating module configured to generate link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and package the link information, the parameter file, the SQL script, and the version type.
  • the generated script file is delivered to the deployment directory.
  • the version deployment module is configured to remotely execute the script file by the OGG deployment platform, and deploy the version according to the script file.
  • a server running an OGG deployment platform comprising a memory and a processor, wherein the memory stores instructions that, when executed by the processor, cause the processor to perform the following steps:
  • the basic data required for the version deployment is obtained by the OGG deployment platform, and the configuration file is generated according to the basic data, where the configuration file includes basic data required for version deployment;
  • the script file is remotely executed by the OGG deployment platform, and the version is deployed according to the script file.
  • One or more computer non-volatile storage media storing computer readable instructions, the computer readable instructions being executed by one or more processors, such that the one or more processors perform the following steps:
  • the basic data required for the version deployment is obtained by the OGG deployment platform, and the configuration file is generated according to the basic data, where the configuration file includes basic data required for version deployment;
  • the script file is remotely executed by the OGG deployment platform, and the version is deployed according to the script file.
  • FIG. 1A is an application environment diagram of an OGG version deployment method in an embodiment
  • 1B is a block diagram of a server running on an OGG deployment platform in one embodiment
  • 1C is a flowchart of an OGG version deployment method in an embodiment
  • FIG. 2 is a schematic diagram of a basic model for performing GG synchronization
  • FIG. 3 is a schematic diagram of an OGG version deployment platform in an embodiment
  • FIG. 5 is a block diagram of an OGG version deployment system in one embodiment.
  • the OGG version deployment method provided by the embodiment of the present application can be applied to the environment as shown in FIG. 1A.
  • the server 10 runs an OGG deployment platform, and interacts with the source database (abbreviated as source database) 20 and the target database (abbreviated as target library) 30 through the OGG deployment platform.
  • the developer can enter the basic data through the OGG deployment platform running in the server 10.
  • the OGG deployment platform generates a configuration file according to the entered basic data, and then generates a shell script according to the basic data in the configuration file, and sends the shell script to the source database 20 and In the target library 30.
  • the GG synchronization can be implemented by remotely executing a shell script through the OGG version deployment platform running in the server 10.
  • the logs generated by the source database 20 and the target library 30 are fed back to the OGG deployment platform of the server 10.
  • the server 10 includes a processor, a non-volatile storage medium, an internal memory, and a network interface connected by a system bus.
  • the non-volatile storage medium of the server 10 stores an operating system and computer executable instructions for implementing an OGG version deployment method.
  • the processor of the server 10 is used to provide computing and control capabilities to support the operation of the entire server 10.
  • the internal memory of the server 10 provides a cached operating environment for operating systems and computer executable instructions in a non-volatile storage medium.
  • the network interface of the server 10 is used to communicate with the source database or the target library, for example, a shell script generated under the source database and the target library, and a log uploaded by the source database and the target library.
  • the server 10 running the OGG deployment platform can be implemented by a stand-alone server or a server cluster composed of a plurality of servers.
  • FIG. 2B is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on a server to which the solution of the present application is applied.
  • the server may include More or fewer components than shown in the figure, or some components combined, or with different component arrangements.
  • the storage medium may further include a database for storing generated shell scripts, and may be used for storing logs uploaded by the target library, and the like.
  • an OGG version deployment method is provided.
  • the method is applied to a server 10 running an OGG deployment platform.
  • the method includes the following steps:
  • Step 102 The OGG deployment platform obtains basic data required for version deployment, and generates a configuration file according to the basic data.
  • the configuration file includes basic data required for version deployment.
  • the base data includes database configuration information, version configuration information, and synchronization table configuration information.
  • the database configuration information includes a database name, a database host address, and a database port;
  • the version configuration information includes an OGG link information, an OGG version number, and an OGG version release date;
  • the synchronization table configuration information includes a source table name, a source table field name, and a target. Table name and target field name.
  • the database configuration information can be used to find the corresponding database, including the source database and the target database.
  • the OGG link information refers to the link information of the source database to the target database.
  • the OGG version number identifies the updated version number.
  • the source table table name, source table field name, target table name, and target field name in the synchronization table configuration information identify the table name that needs to be updated and replaced, and the field name in the table.
  • Step 104 The OGG deployment platform generates link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and sends the link information, the parameter file, the SQL script, and the version type to generate a script file to be sent to the In the deployment directory.
  • the link information indicates from which source database to which target database the link is, and refers to the synchronization channel from the source database to the target database.
  • the OGG deployment platform can generate a chain according to the database configuration information and the version configuration information. Road information.
  • the parameter file refers to the code used by OGG synchronization.
  • the OGG deployment platform can generate the corresponding parameter file according to the synchronization table configuration information.
  • the SQL script refers to the set of commands executed in the database.
  • the OGG deployment platform can generate information based on the database configuration information, version configuration information, and synchronization table configuration information.
  • the version type is used to define the version deployment program that needs to be executed during version deployment. Different version types have different version deployment programs.
  • the OGG deployment platform can configure information according to database configuration information, version configuration information, and synchronization table. Corresponding version types are generated accordingly.
  • the OGG deployment platform integrates link information, parameter files, SQL scripts, and version types through specific rules, generates a shell script, and delivers the script file to a deployment directory.
  • the so-called deployment directory refers to the directory where the script file is stored when the version is deployed. It can be in a specific directory in the database host.
  • the database host here includes the source database host and the target database host.
  • the OGG deployment platform acquires basic data required for version deployment, and generates a configuration file according to the basic data, including: the OGG deployment platform acquires basic data required for the version input by the user; and obtains the configuration file input by the user. One-click generation command; generate a configuration file based on the basic data through a configuration file one-click generation command.
  • the basic data required for the version conversion can be entered into the OGG management platform, and then a simple command is input, and the OGG deployment platform generates the configuration file by integrating the basic data through specific rules. Further, the link information, the parameter file, the SQL script, and the version type are automatically generated according to the basic data in the configuration file, and the packaged generated script file is delivered to the deployment directory.
  • step 106 the OGG deployment platform remotely executes the script file and deploys the version according to the script file.
  • the OGG deployment platform can remotely control the execution of the script file, and the version deployment can be implemented in the process of executing the script file.
  • the step of deploying the version according to the script file includes: finding a corresponding source database and a target database according to the link information, generating a corresponding version deployment program according to the version type, and starting and stopping the process by using the version deployment program. , parameter file replacement, def file generation, and SQL script execution.
  • a version deployment program is required to start and stop the process, parameter file replacement, def file generation, and SQL script execution. After these processes are completed, the new version is deployed.
  • the process here refers to the OGG synchronization program, including the process of copy log analysis and data extraction (local Extract process), the process responsible for log delivery (data Pump process) and the process responsible for log parsing and application to the database (replicat process).
  • Different OGG versions require different processes to be enabled and stopped.
  • the OGG process is started in a specific order to achieve the integrity of the synchronized data.
  • the new OGG version also needs to replace some parameter files.
  • the def file refers to the table structure definition file, such as the table name, field name, and field length of a table. Execute the SQL script to check whether there are long transactions and locks in the database. You can check whether the table or field that the new OGG version depends on already exists, and you can also initialize the data.
  • the step of deploying the version according to the script file further includes inserting an automatic detection during execution of the version deployment program.
  • the version deployment program includes an automatic detection program, and the version deployment programs corresponding to different version types are different.
  • the version deployment program is performed through multiple deployment steps, in which an automatic detection step is inserted.
  • the OGG version deployment method generateds a configuration file according to the basic data by acquiring the basic data required for the version deployment, and then generates link information, parameter files, SQL scripts, and version types according to the basic data in the configuration file. And the link information, the parameter file, the SQL script, and the version type are packaged and generated, and the script file is sent to the deployment directory, and the script file is remotely executed to implement the version deployment. Since the basic data can be configured to automatically generate the information and files required for version deployment based on the underlying data, remote execution of the script file enables version deployment. There is no need for the developer to manually write the operation steps, nor the operation and maintenance personnel to operate at a specific time, which reduces the misoperation and makes the OGG version deployment more convenient and quick.
  • GG Golden Gate
  • GG synchronization is implemented according to the following basic steps: 1) GG extraction process local Extract (e process) reads the log data of the source database at the source, generates source trail (source trace); 2) GG delivery process data Pump (d process) reads the source trail at the source and passes the data to the target through the network to generate a remote trail; 3) GG The replicat process (r process) reads the remote on the target side Trail and generate SQL statements according to certain rules in the target database (referred to as the target library) to achieve synchronization.
  • This traditional approach requires developers to write steps based on different version types.
  • the OGG version deployment method constructs an OGG version deployment platform based on the original GG synchronization basic model.
  • the OGG version deployment platform obtains the input basic data, and generates a configuration file according to the basic data.
  • the OGG version deployment platform generates a corresponding shell script according to the basic data in the configuration file, and sends the shell script to the source end and the target end.
  • the source and destination send log or def files to the OGG version deployment platform (ie, step B and step D in Figure 3).
  • the OGG version deployment platform remotely executes shell scripts, and implements the start and stop operations of the GG process, the replacement of parameter files, the generation of def files, and the execution of SQL scripts through shell scripts.
  • GG synchronization can be implemented by issuing a shell script and executing a shell script remotely. Only different basic data can be configured for different version types, and no developer needs to manually write the operation steps.
  • the process of deploying the OGG version includes:
  • the OGG version deployment platform obtains the basic data entered, generates link information, parameter files, SQL scripts, and version types based on the basic data, and integrates link information, parameter files, SQL scripts, and version types through specific rules to generate a shell.
  • the script is delivered to the corresponding directory on the source and destination.
  • the OGG version deployment platform remotely controls the execution of the shell script, and automatically generates the corresponding version deployment program according to the version type, that is, the operation steps.
  • the generated steps are as follows:
  • stepcheckdbversion check the db version
  • stepchecktran check long transactions
  • stepchecktrandata check trandata
  • stepreplacee replace the e process parameter file
  • stepreplaced replace the d process parameter file
  • stepstarte start the e process
  • stepstartd start the d process
  • stepmergeinit execute the initialization script
  • stepreplacer replace the r process parameter file
  • stepmontime monitor r process time point
  • stepdelhdl delete handlecollisions
  • stepstartr Start the r process
  • stepcheckenv check the status of e, d, r processes
  • the OGG version deployment platform controls the remote execution shell script.
  • the main steps include: 1) closing the OGG extraction and pump program by deploying the platform control shell program; 2) returning the CSN by deploying the ass too control shell program; 3) The OGG copy program is closed by deploying the platform control shell program; 4) determining how to deploy by deploying the parameters obtained by the platform and data initialization; 5) accessing the target database through the deployment platform, and anonymizing the block by itself, and initializing the data of the target end (anonymous block can be Automatically generate SQL scripts; 6) Send the parameter file to the source library through the automatic deployment program; 7) Send the parameters to the target library through the automatic deployment program; 8) Open the OGG extraction and pump program by deploying the platform control shell program ; 9) Open the OGG copy program by deploying the platform control shell program.
  • an OGG version deployment system is further provided, where the system includes:
  • the configuration file generating module 502 is configured to obtain basic data required for version deployment, and generate a configuration file according to the basic data, where the configuration file includes basic data required for version deployment.
  • the version deployment module 506 is configured to remotely execute the script file and deploy the version according to the script file.
  • the basic data includes: database configuration information, version configuration information, and synchronization table configuration information; wherein, the database configuration information includes a database name, a database host address, and a database port; and the version configuration information includes an OGG link information, an OGG version. Number and OGG version release date; synchronization table configuration information includes source table table name, source table field name, target table name, and target field name.
  • the version deployment module 506 is configured to find a corresponding source database and a target database according to the link information, generate a corresponding version deployment program according to the version type, and start and stop the process and replace the parameter file by using the version deployment program. , def file generation and SQL script execution.
  • the version deployment module 506 is also used to insert automatic detection during the execution of the version deployment program.
  • the configuration file generating module 502 is configured to acquire basic data required for version deployment by the user; obtain a configuration file one-key generation command input by the user, and generate a configuration file according to the basic data by using a configuration file one-key generation command.
  • the storage medium may be a magnetic disk, an optical disk, or a read-only storage memory (Read-Only)
  • a nonvolatile storage medium such as a memory or a ROM, or a random access memory (RAM).

Abstract

An OGG version deployment method, comprising: an OGG deployment platform obtains basic data required for version deployment, and generates a configuration file according to the basic data in the configuration file, the configuration file comprising the basic data required for version deployment; the OGG deployment platform generates link information, a parameter file, an SQL script, and a version type according to the basic data, packs the link information, the parameter file, the SQL script, and the version type to generate a script file, and delivers the script file to a deployment catalog; the OGG deployment platform remotely executes the script file, and deploys a version according to the script file.

Description

OGG 版本部署方法、***、服务器和存储介质  OGG version deployment method, system, server, and storage media
本申请要求于 2016 年 4 月 11 日提交中国专利局、申请号为 201610222213.8 ，发明名称为' OGG 版本部署方法和***'的中国专利申请的优先权，其全部内容通过引用结合在本申请中。  This application is submitted to the Chinese Patent Office on April 11, 2016, and the application number is 201610222213.8. The priority of the invention is the Chinese patent application entitled 'OGG Version Deployment Method and System', the entire contents of which are hereby incorporated by reference.
【技术领域】[Technical Field]
本发明涉及数据库技术领域，特别是涉及一种OGG版本部署方法、***、服务器和存储介质。The present invention relates to the field of database technologies, and in particular, to an OGG version deployment method, system, server, and storage medium.
【背景技术】【Background technique】
OGG（Oracle Golden Gate）软件是一种基于日志的结构化数据复制备份软件，它通过解析源数据库在线日志或归档日志获得数据的增量变化，再将这些变化应用到目标数据库中，从而实现源数据库与目标数据库同步。当OGG进行版本更新时，需要进行版本部署。目前，OGG版本由数据集成平台分组的开发人员在管理平台上生成相应文件，并根据不同的版本类型手动编写操作步骤，然后由晚班管理人员在凌晨操作实现版本部署。OGG (Oracle Golden Gate) software is a log-based structured data replication backup software that obtains incremental changes in data by parsing the source database online log or archive log, and then applies these changes to the target database to implement the source database and the target database. Synchronize. Version deployment is required when OGG is updated. Currently, the OGG version of the data integration platform group of developers on the management platform to generate the corresponding files, and manually write the operation steps according to different version types, and then the evening shift management in the early hours of operation to achieve version deployment.
然而，传统的这种方法，由于需要管理人员手动编写操作步骤，不同开发人员由于习惯或熟悉程度不同，写的部署文档操作步骤不一定合标准，且由于需要在运维人员手动操作，很容易漏操作步骤或者发生低级的误操作，从而导致无法实现版本更新。However, in the traditional method, because the administrator needs to manually write the operation steps, different developers have different habits or familiarity, and the written document deployment steps are not necessarily standard, and it is easy to operate manually by the operation and maintenance personnel. Missing operation steps or low-level misoperations may result in version updates not being implemented.
【发明内容】 [Summary of the Invention]
根据本申请的各种实施例，提供了一种OGG版本部署方法、***、服务器和存储介质。In accordance with various embodiments of the present application, an OGG version deployment method, system, server, and storage medium are provided.
一种OGG版本部署方法，包括：An OGG version deployment method, including:
OGG部署平台获取版本部署所需要的基础数据，根据所述配置文件中的基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；The OGG deployment platform obtains the basic data required for the version deployment, and generates a configuration file according to the basic data in the configuration file, where the configuration file includes basic data required for version deployment;
OGG部署平台根据所述基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中；The OGG deployment platform generates the link information, the parameter file, the SQL script, and the version type according to the basic data, and packages the link information, the parameter file, the SQL script, and the version type to generate a script file and sends the script file to the deployment directory.
OGG部署平台远程执行所述脚本文件，根据所述脚本文件部署版本。The OGG deployment platform remotely executes the script file and deploys a version according to the script file.
一种OGG版本部署***，包括：An OGG version deployment system that includes:
配置文件生成模块，用于获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；a configuration file generating module, configured to acquire basic data required for version deployment, and generate a configuration file according to the basic data, where the configuration file includes basic data required for version deployment;
脚本文件生成模块，用于OGG部署平台根据所述配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中；a script file generating module, configured to generate link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and package the link information, the parameter file, the SQL script, and the version type. The generated script file is delivered to the deployment directory.
版本部署模块，用于OGG部署平台远程执行所述脚本文件，根据所述脚本文件部署版本。The version deployment module is configured to remotely execute the script file by the OGG deployment platform, and deploy the version according to the script file.
一种服务器，所述服务器运行OGG部署平台，包括存储器和处理器，所述存储器中存储有指令，所述指令被所述处理器执行时，使得所述处理器执行以下步骤：A server running an OGG deployment platform, comprising a memory and a processor, wherein the memory stores instructions that, when executed by the processor, cause the processor to perform the following steps:
通过OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；The basic data required for the version deployment is obtained by the OGG deployment platform, and the configuration file is generated according to the basic data, where the configuration file includes basic data required for version deployment;
通过所述OGG部署平台根据所述配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中；Generating, by the OGG deployment platform, link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and packaging the link information, the parameter file, the SQL script, and the version type to generate a script file. Sent to the deployment directory;
通过所述OGG部署平台远程执行所述脚本文件，根据所述脚本文件部署版本。The script file is remotely executed by the OGG deployment platform, and the version is deployed according to the script file.
一个或多个存储有计算机可读指令的计算机非易失性存储介质，所述计算机可读指令被一个或多个处理器执行，使得所述一个或多个处理器执行以下步骤：One or more computer non-volatile storage media storing computer readable instructions, the computer readable instructions being executed by one or more processors, such that the one or more processors perform the following steps:
通过OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；The basic data required for the version deployment is obtained by the OGG deployment platform, and the configuration file is generated according to the basic data, where the configuration file includes basic data required for version deployment;
通过所述OGG部署平台根据所述配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中；Generating, by the OGG deployment platform, link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and packaging the link information, the parameter file, the SQL script, and the version type to generate a script file. Sent to the deployment directory;
通过所述OGG部署平台远程执行所述脚本文件，根据所述脚本文件部署版本。The script file is remotely executed by the OGG deployment platform, and the version is deployed according to the script file.
本发明的一个或多个实施例的细节在下面的附图和描述中提出。本发明的其它特征、目的和优点将从说明书、附图以及权利要求书变得明显。Details of one or more embodiments of the invention are set forth in the accompanying drawings and description below. Other features, objects, and advantages of the invention will be apparent from the description and appended claims.
【附图说明】[Description of the Drawings]
为了更清楚地说明本发明实施例或现有技术中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的附图。In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the embodiments or the description of the prior art will be briefly described below. Obviously, the drawings in the following description are only It is a certain embodiment of the present invention, and other drawings can be obtained from those skilled in the art without any creative work.
图1A为一个实施例中OGG版本部署方法的应用环境图；FIG. 1A is an application environment diagram of an OGG version deployment method in an embodiment; FIG.
图1B为一个实施例中OGG部署平台所运行的服务器的框图；1B is a block diagram of a server running on an OGG deployment platform in one embodiment;
图1C为一个实施例中OGG版本部署方法的流程图；1C is a flowchart of an OGG version deployment method in an embodiment;
图2为进行GG同步的基本模型示意图；2 is a schematic diagram of a basic model for performing GG synchronization;
图3为一个实施例中OGG版本部署平台的原理图；3 is a schematic diagram of an OGG version deployment platform in an embodiment;
图4为一个实施例中OGG版本部署控制流程的时序图；4 is a sequence diagram of an OGG version deployment control flow in an embodiment;
图5为一个实施例中OGG版本部署***的框图。Figure 5 is a block diagram of an OGG version deployment system in one embodiment.
【具体实施方式】 【detailed description】
为了使本发明的目的、技术方案及优点更加清楚明白，以下结合附图及实施例，对本发明进行进一步详细说明。应当理解，此处所描述的具体实施例仅仅用以解释本发明，并不用于限定本发明。The present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
本申请实施例所提供的OGG版本部署方法可应用于如图1A所示的环境中。参考图1A所示，服务器10中运行OGG部署平台，通过OGG部署平台与源端数据库（简称源数据库）20和目标端数据库（简称目标库）30进行交互。开发人员可通过服务器10中运行的OGG部署平台录入基础数据，OGG部署平台根据录入的基础数据生成配置文件，进而根据配置文件中的基础数据生成shell脚本，将shell脚本下发到源数据库20和目标库30中。通过服务器10中运行的OGG版本部署平台，可远程执行shell脚本即可实现GG同步。而源数据库20和目标库30所生成日志会反馈到服务器10的OGG部署平台中。The OGG version deployment method provided by the embodiment of the present application can be applied to the environment as shown in FIG. 1A. Referring to FIG. 1A, the server 10 runs an OGG deployment platform, and interacts with the source database (abbreviated as source database) 20 and the target database (abbreviated as target library) 30 through the OGG deployment platform. The developer can enter the basic data through the OGG deployment platform running in the server 10. The OGG deployment platform generates a configuration file according to the entered basic data, and then generates a shell script according to the basic data in the configuration file, and sends the shell script to the source database 20 and In the target library 30. The GG synchronization can be implemented by remotely executing a shell script through the OGG version deployment platform running in the server 10. The logs generated by the source database 20 and the target library 30 are fed back to the OGG deployment platform of the server 10.
如图1B所示，运行OGG部署平台的服务器10的内部结构如图1B所示。该服务器10包括通过***总线连接的处理器、非易失性存储介质、内存储器和网络接口。其中，该服务器10的非易失性存储介质存储有操作***和计算机可执行指令，该计算机可执行指令用于实现一种OGG版本部署方法。该服务器10的处理器用于提供计算和控制能力，支撑整个服务器10的运行。该服务器10的内存储器为非易失性存储介质中的操作***和计算机可执行指令提供高速缓存的运行环境。该服务器10的网络接口用于据以与源数据库或目标库进行通信，例如下发生成的shell脚本给源数据库和目标库，接收源数据库和目标库上传的日志等。运行OGG部署平台的服务器10可以用独立的服务器或者是多个服务器组成的服务器集群来实现。本领域技术人员可以理解，图2B中示出的结构，仅仅是与本申请方案相关的部分结构的框图，并不构成对本申请方案所应用于其上的服务器的限定，具体地，服务器可以包括比图中所示更多或更少的部件，或者组合某些部件，或者具有不同的部件布置。例如，存储介质中还可包含数据库，用于存储生成的shell脚本，并可用于存储目标库上传的日志等。As shown in FIG. 1B, the internal structure of the server 10 running the OGG deployment platform is as shown in FIG. 1B. The server 10 includes a processor, a non-volatile storage medium, an internal memory, and a network interface connected by a system bus. The non-volatile storage medium of the server 10 stores an operating system and computer executable instructions for implementing an OGG version deployment method. The processor of the server 10 is used to provide computing and control capabilities to support the operation of the entire server 10. The internal memory of the server 10 provides a cached operating environment for operating systems and computer executable instructions in a non-volatile storage medium. The network interface of the server 10 is used to communicate with the source database or the target library, for example, a shell script generated under the source database and the target library, and a log uploaded by the source database and the target library. The server 10 running the OGG deployment platform can be implemented by a stand-alone server or a server cluster composed of a plurality of servers. A person skilled in the art can understand that the structure shown in FIG. 2B is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on a server to which the solution of the present application is applied. Specifically, the server may include More or fewer components than shown in the figure, or some components combined, or with different component arrangements. For example, the storage medium may further include a database for storing generated shell scripts, and may be used for storing logs uploaded by the target library, and the like.
如图1C所示，在一个实施例中，提供了一种OGG版本部署方法，该方法以应用于运行OGG部署平台的服务器10中进行举例说明，该方法包括以下步骤：As shown in FIG. 1C, in an embodiment, an OGG version deployment method is provided. The method is applied to a server 10 running an OGG deployment platform. The method includes the following steps:
步骤102，OGG部署平台获取版本部署所需要的基础数据，根据基础数据生成配置文件。Step 102: The OGG deployment platform obtains basic data required for version deployment, and generates a configuration file according to the basic data.
本实施例中，配置文件中包含版本部署所需要的基础数据。In this embodiment, the configuration file includes basic data required for version deployment.
在一个实施例中，基础数据包括数据库配置信息、版本配置信息和同步表配置信息。其中，数据库配置信息包括数据库名称、数据库主机地址和数据库端口；版本配置信息包括OGG链路信息、OGG版本号和OGG版本发布日期；同步表配置信息包括源表表名、源表字段名称、目标表名和目标字段名称。其中，数据库配置信息可用于查找到相应的数据库，包括源数据库和目标数据库。OGG链路信息是指源数据库到目标数据库的链路信息。OGG版本号标识了更新的版本号码。同步表配置信息中的源表表名、源表字段名称、目标表名和目标字段名称标识了需要做更新替换的表名和表中的字段名称。In one embodiment, the base data includes database configuration information, version configuration information, and synchronization table configuration information. The database configuration information includes a database name, a database host address, and a database port; the version configuration information includes an OGG link information, an OGG version number, and an OGG version release date; the synchronization table configuration information includes a source table name, a source table field name, and a target. Table name and target field name. Among them, the database configuration information can be used to find the corresponding database, including the source database and the target database. The OGG link information refers to the link information of the source database to the target database. The OGG version number identifies the updated version number. The source table table name, source table field name, target table name, and target field name in the synchronization table configuration information identify the table name that needs to be updated and replaced, and the field name in the table.
步骤104，OGG部署平台根据配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中。Step 104: The OGG deployment platform generates link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and sends the link information, the parameter file, the SQL script, and the version type to generate a script file to be sent to the In the deployment directory.
本实施例中，链路信息表示从哪个源数据库到哪个目标数据库之间的链路，是指从源数据库到目标数据库的同步通道，OGG部署平台根据数据库配置信息和版本配置信息即可生成链路信息。参数文件是指OGG同步所使用到的代码，OGG部署平台根据同步表配置信息即可生成相应的参数文件。SQL脚本是指到数据库中执行的命令集合，OGG部署平台可根据数据库配置信息、版本配置信息和同步表配置信息生成。版本类型用来定义了在进行版本部署时需要执行的版本部署程序，不同的版本类型对应要执行的版本部署程序有所不同，OGG部署平台可根据数据库配置信息、版本配置信息和同步表配置信息相应生成对应的版本类型。In this embodiment, the link information indicates from which source database to which target database the link is, and refers to the synchronization channel from the source database to the target database. The OGG deployment platform can generate a chain according to the database configuration information and the version configuration information. Road information. The parameter file refers to the code used by OGG synchronization. The OGG deployment platform can generate the corresponding parameter file according to the synchronization table configuration information. The SQL script refers to the set of commands executed in the database. The OGG deployment platform can generate information based on the database configuration information, version configuration information, and synchronization table configuration information. The version type is used to define the version deployment program that needs to be executed during version deployment. Different version types have different version deployment programs. The OGG deployment platform can configure information according to database configuration information, version configuration information, and synchronization table. Corresponding version types are generated accordingly.
在一个实施例中，OGG部署平台将链路信息、参数文件、SQL脚本和版本类型通过特定的规则进行整合，生成Shell脚本并将该脚本文件下发到部署目录中。所谓部署目录是指在进行版本部署时脚本文件所存储的目录，可以是数据库主机中的特定目录中，这里的数据库主机包括源数据库主机和目标数据库主机。In one embodiment, the OGG deployment platform integrates link information, parameter files, SQL scripts, and version types through specific rules, generates a shell script, and delivers the script file to a deployment directory. The so-called deployment directory refers to the directory where the script file is stored when the version is deployed. It can be in a specific directory in the database host. The database host here includes the source database host and the target database host.
在一个实施例中，OGG部署平台获取版本部署所需要的基础数据，根据基础数据生成配置文件的步骤，包括：OGG部署平台获取用户输入的版本部署所需要的基础数据；获取用户输入的配置文件一键生成命令；通过配置文件一键生成命令根据基础数据生成配置文件。本实施例中，可以将版本变换所需要的基础数据录入到OGG管理平台，再输入一个简单的命令，则OGG部署平台通过特定的规则整合基础数据生成配置文件。进一步的，根据配置文件中的基础数据自动生成链路信息、参数文件、SQL脚本和版本类型，并打包生成脚本文件下发到部署目录中。In an embodiment, the OGG deployment platform acquires basic data required for version deployment, and generates a configuration file according to the basic data, including: the OGG deployment platform acquires basic data required for the version input by the user; and obtains the configuration file input by the user. One-click generation command; generate a configuration file based on the basic data through a configuration file one-click generation command. In this embodiment, the basic data required for the version conversion can be entered into the OGG management platform, and then a simple command is input, and the OGG deployment platform generates the configuration file by integrating the basic data through specific rules. Further, the link information, the parameter file, the SQL script, and the version type are automatically generated according to the basic data in the configuration file, and the packaged generated script file is delivered to the deployment directory.
步骤106，OGG部署平台远程执行脚本文件，根据脚本文件部署版本。In step 106, the OGG deployment platform remotely executes the script file and deploys the version according to the script file.
本实施例中，OGG部署平台可远程控制脚本文件的执行，执行脚本文件的过程中即可实现版本部署。In this embodiment, the OGG deployment platform can remotely control the execution of the script file, and the version deployment can be implemented in the process of executing the script file.
在一个实施例中，根据脚本文件部署版本的步骤，包括：根据链路信息查找到对应的源数据库和目标数据库，根据版本类型生成相应的版本部署程序，通过版本部署程序进行进程的启停操作、参数文件替换、def文件生成和SQL脚本执行。本实施例中，要实现部署新的版本，需要通过版本部署程序进行进程的启停操作、参数文件替换、def文件生成和SQL脚本执行，这些处理完后则完成了新版本部署。In an embodiment, the step of deploying the version according to the script file includes: finding a corresponding source database and a target database according to the link information, generating a corresponding version deployment program according to the version type, and starting and stopping the process by using the version deployment program. , parameter file replacement, def file generation, and SQL script execution. In this embodiment, to implement a new version, a version deployment program is required to start and stop the process, parameter file replacement, def file generation, and SQL script execution. After these processes are completed, the new version is deployed.
其中，进程的启停操作中需要对某些进程进行启动和停止，这里的进程是指OGG同步程序，包括复制日志分析和数据抽取的进程（local extract进程）、负责日志投递的进程（data pump进程）和负责日志解析和应用到数据库的进程（replicat进程）。不同的OGG版本需要启用和停止的进程会有所不同，按照特定顺序启动OGG进程从而可以实现同步数据的完整性。新的OGG版本还需要替换一些参数文件。def文件是指表结构定义文件，比如一张表的表名、字段名和字段长度等。执行SQL脚本可以检查数据库中是否有长事务和锁，可以检查新的OGG版本依赖的表或字段是否已经存在，还可以进行数据初始化等。Among them, the start and stop operations of the process need to start and stop some processes, the process here refers to the OGG synchronization program, including the process of copy log analysis and data extraction (local Extract process), the process responsible for log delivery (data Pump process) and the process responsible for log parsing and application to the database (replicat process). Different OGG versions require different processes to be enabled and stopped. The OGG process is started in a specific order to achieve the integrity of the synchronized data. The new OGG version also needs to replace some parameter files. The def file refers to the table structure definition file, such as the table name, field name, and field length of a table. Execute the SQL script to check whether there are long transactions and locks in the database. You can check whether the table or field that the new OGG version depends on already exists, and you can also initialize the data.
在一个实施例中，根据脚本文件部署版本的步骤，还包括：在执行版本部署程序的过程中***自动检测。本实施例中，版本部署程序中包含自动检测程序，不同的版本类型所对应的版本部署程序有所不同，版本部署程序通过多个部署步骤进行，其中***有自动检测步骤。In one embodiment, the step of deploying the version according to the script file further includes inserting an automatic detection during execution of the version deployment program. In this embodiment, the version deployment program includes an automatic detection program, and the version deployment programs corresponding to different version types are different. The version deployment program is performed through multiple deployment steps, in which an automatic detection step is inserted.
本发明实施例所提供的OGG版本部署方法，通过获取版本部署所需要的基础数据，根据基础数据生成配置文件，进而根据配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中，再远程执行脚本文件实现版本部署。由于只要配置好基础数据即可根据基础数据自动生成版本部署所需要的信息和文件，远程执行脚本文件就能实现版本部署。无需开发人员手动编写操作步骤，也不需要运维人员在特定时间操作，降低了误操作，使得OGG版本部署更加方便快捷。The OGG version deployment method provided by the embodiment of the present invention generates a configuration file according to the basic data by acquiring the basic data required for the version deployment, and then generates link information, parameter files, SQL scripts, and version types according to the basic data in the configuration file. And the link information, the parameter file, the SQL script, and the version type are packaged and generated, and the script file is sent to the deployment directory, and the script file is remotely executed to implement the version deployment. Since the basic data can be configured to automatically generate the information and files required for version deployment based on the underlying data, remote execution of the script file enables version deployment. There is no need for the developer to manually write the operation steps, nor the operation and maintenance personnel to operate at a specific time, which reduces the misoperation and makes the OGG version deployment more convenient and quick.
为了更加清楚本实施例所提供的OGG版本部署方法的原理，下面结合GG同步模型和本实施例所提出的OGG部署平台（也即OGG版本部署平台）进行详细说明。To further clarify the principle of the OGG version deployment method provided by this embodiment, the following describes the GG synchronization model and the OGG deployment platform (that is, the OGG version deployment platform) proposed in this embodiment.
如图2所示，为GG（Golden Gate）同步的基本模型示意图。要实现源数据库和目标数据库之间的同步，GG同步按照以下基本步骤来实现：1）GG抽取进程local extract（e进程）在源端读取源数据库的日志数据，生成source trail（源跟踪）；2）GG投递进程data pump（d进程）在源端读取source trail并通过网络将数据传递到目标端生成remote trail（远程跟踪）；3）GG replicat进程（r进程）在目标端读取remote trail并根据一定的规则生成SQL语句在目标端数据库（简称目标库）中执行，以实现同步。传统的这种方式则需要开发人员根据不同的版本类型编写操作步骤。As shown in Figure 2, it is GG (Golden Gate) Schematic diagram of the basic model of synchronization. To achieve synchronization between the source and target databases, GG synchronization is implemented according to the following basic steps: 1) GG extraction process local Extract (e process) reads the log data of the source database at the source, generates source trail (source trace); 2) GG delivery process data Pump (d process) reads the source trail at the source and passes the data to the target through the network to generate a remote trail; 3) GG The replicat process (r process) reads the remote on the target side Trail and generate SQL statements according to certain rules in the target database (referred to as the target library) to achieve synchronization. This traditional approach requires developers to write steps based on different version types.
如图3所示，本实施例所提供的OGG版本部署方法，在原有的GG同步基本模型的基础上架构出OGG版本部署平台。通过OGG版本部署平台获取录入的基础数据，根据基础数据从而生成配置文件，OGG版本部署平台进而根据配置文件中的基础数据生成相应的shell脚本，将shell脚本下发到源端和目标端中的相应目录中（即图3中的步骤A和步骤C）。同时，源端和目标端发送日志或者def文件到OGG版本部署平台（即图3中的步骤B和步骤D）。OGG版本部署平台远程执行shell脚本，通过shell脚本实现GG进程的启停操作、参数文件的替换、def文件的生成以及SQL脚本的执行。通过OGG版本部署平台生成配置文件通过下发shell脚本并远程执行shell脚本就可以实现GG同步，对于不同的版本类型只有配置了不同的基础数据即可，无需开发人员手动编写操作步骤。As shown in FIG. 3, the OGG version deployment method provided in this embodiment constructs an OGG version deployment platform based on the original GG synchronization basic model. The OGG version deployment platform obtains the input basic data, and generates a configuration file according to the basic data. The OGG version deployment platform generates a corresponding shell script according to the basic data in the configuration file, and sends the shell script to the source end and the target end. In the corresponding directory (ie, step A and step C in Figure 3). At the same time, the source and destination send log or def files to the OGG version deployment platform (ie, step B and step D in Figure 3). The OGG version deployment platform remotely executes shell scripts, and implements the start and stop operations of the GG process, the replacement of parameter files, the generation of def files, and the execution of SQL scripts through shell scripts. Build a configuration file through the OGG version deployment platform. GG synchronization can be implemented by issuing a shell script and executing a shell script remotely. Only different basic data can be configured for different version types, and no developer needs to manually write the operation steps.
为进一步说明，结合一个具体的实例来说明本发明实施例所提供的OGG版本部署方法的原理。如图4所示，在该实施例中，OGG版本部署的过程包括：For further explanation, the principle of the OGG version deployment method provided by the embodiment of the present invention is described in conjunction with a specific example. As shown in FIG. 4, in this embodiment, the process of deploying the OGG version includes:
（1）OGG版本部署平台获取录入的基础数据，根据基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将链路信息、参数文件、SQL脚本和版本类型通过特定规则整合生成shell脚本下发到源端和目标端相应目录中。(1) The OGG version deployment platform obtains the basic data entered, generates link information, parameter files, SQL scripts, and version types based on the basic data, and integrates link information, parameter files, SQL scripts, and version types through specific rules to generate a shell. The script is delivered to the corresponding directory on the source and destination.
（2）OGG版本部署平台远程控制执行shell脚本，根据版本类型自动生成相应的版本部署程序，即操作步骤。(2) The OGG version deployment platform remotely controls the execution of the shell script, and automatically generates the corresponding version deployment program according to the version type, that is, the operation steps.
例如，生成的操作步骤如下：For example, the generated steps are as follows:
1：stepinit: 链路部署初始化1:stepinit: link deployment initialization
2：stepcheckdbversion: 检查db版本2: stepcheckdbversion: check the db version
3：stepchecktran： 检查长事务3: stepchecktran: check long transactions
4：stepaddtrandata: 加trandata4: stepaddtrandata: add trandata
5：stepchecktrandata: 检查trandata5: stepchecktrandata: check trandata
6：stepstope： 停e进程6: stepstope: stop e process
7：stepstopd： 停d进程7: stepstopd: stop d process
8：stepreplacee: 替换e进程参数文件8: stepreplacee: replace the e process parameter file
9：stepreplaced： 替换d进程参数文件9: stepreplaced: replace the d process parameter file
10：stepstopr： 停r进程10: stepstopr: stop r process
11：stepupdatedef： 更新def文件11: stepupdatedef: update the def file
12：stepstarte: 启动e进程12: stepstarte: start the e process
13：stepstartd： 启动d进程13: stepstartd: start the d process
14：stepcreateview： 创建视图14:stepcreateview: create a view
15：stepmergeinit： 执行初始化脚本15: stepmergeinit: execute the initialization script
16：stepdropview： 删除视图16:stepdropview: delete view
17：stepreplacer： 替换r进程参数文件17: stepreplacer: replace the r process parameter file
18：stepstartr： 启动r进程18: stepstartr: start r process
19：stepmontime: 监控r进程时间点19: stepmontime: monitor r process time point
20：stepstopr： 停r进程20: stepstopr: stop r process
21：stepdelhdl: 删除handlecollisions21: stepdelhdl: delete handlecollisions
22：stepstartr： 启动r进程22: stepstartr: Start the r process
23：stepcheckenv：检查e、d、r进程状态23: stepcheckenv: check the status of e, d, r processes
由此可知，操作步骤会自动生成，执行操作步骤即可实现版本部署。此外，在操作步骤中还包含自动检查步骤。比如检查参数文件的版本号，在替换参数步文件的步骤中执行；检查进程状态，在第23步骤执行，更新def文件步骤就有自动检测def版本，以确保已经替换了def版本。It can be seen that the operation steps are automatically generated, and the operation steps can be performed to implement the version deployment. In addition, an automatic check step is included in the operation steps. For example, check the version number of the parameter file, execute it in the step of replacing the parameter step file; check the process status, execute in step 23, and update the def file step to automatically detect the def version to ensure that the def version has been replaced.
结合图4所示，OGG版本部署平台控制远程执行shell脚本主要的操作步骤包括：1）通过部署平台控制shell程序关闭OGG抽取和pump程序；2）通过部署屁股太控制shell程序返回CSN；3）通过部署平台控制shell程序关闭OGG复制程序；4）通过部署平台和数据初始化得到的参数来判断如何部署；5）通过部署平台访问目标数据库，并会自行匿名块，初始化目标端的数据（匿名块可自动关生成SQL脚本）；6）通过自动部署程序将参数文件下发到源库；7）通过自动部署程序将参数下发到目标库；8）通过部署平台控制shell程序打开OGG抽取与pump程序；9）通过部署平台控制shell程序打开OGG复制程序。As shown in Figure 4, the OGG version deployment platform controls the remote execution shell script. The main steps include: 1) closing the OGG extraction and pump program by deploying the platform control shell program; 2) returning the CSN by deploying the ass too control shell program; 3) The OGG copy program is closed by deploying the platform control shell program; 4) determining how to deploy by deploying the parameters obtained by the platform and data initialization; 5) accessing the target database through the deployment platform, and anonymizing the block by itself, and initializing the data of the target end (anonymous block can be Automatically generate SQL scripts; 6) Send the parameter file to the source library through the automatic deployment program; 7) Send the parameters to the target library through the automatic deployment program; 8) Open the OGG extraction and pump program by deploying the platform control shell program ; 9) Open the OGG copy program by deploying the platform control shell program.
如图5所示，在一个实施例中，还提供了一种OGG版本部署***，该***包括：As shown in FIG. 5, in an embodiment, an OGG version deployment system is further provided, where the system includes:
配置文件生成模块502，用于获取版本部署所需要的基础数据，根据基础数据生成配置文件，该配置文件中包含版本部署需要的基础数据。The configuration file generating module 502 is configured to obtain basic data required for version deployment, and generate a configuration file according to the basic data, where the configuration file includes basic data required for version deployment.
脚本文件生成模块504，用于根据配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中。The script file generating module 504 is configured to generate link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and package the link information, the parameter file, the SQL script, and the version type to generate a script file. Send to the deployment directory.
版本部署模块506，用于远程执行脚本文件，根据脚本文件部署版本。The version deployment module 506 is configured to remotely execute the script file and deploy the version according to the script file.
在一个实施例中，基础数据包括：数据库配置信息、版本配置信息和同步表配置信息；其中，数据库配置信息包括数据库名称、数据库主机地址和数据库端口；版本配置信息包括OGG链路信息、OGG版本号和OGG版本发布日期；同步表配置信息包括源表表名、源表字段名称、目标表名和目标字段名称。In an embodiment, the basic data includes: database configuration information, version configuration information, and synchronization table configuration information; wherein, the database configuration information includes a database name, a database host address, and a database port; and the version configuration information includes an OGG link information, an OGG version. Number and OGG version release date; synchronization table configuration information includes source table table name, source table field name, target table name, and target field name.
在一个实施例中，版本部署模块506用于根据链路信息查找到对应的源数据库和目标数据库，根据版本类型生成相应的版本部署程序，通过版本部署程序进行进程的启停操作、参数文件替换、def文件生成和SQL脚本执行。In an embodiment, the version deployment module 506 is configured to find a corresponding source database and a target database according to the link information, generate a corresponding version deployment program according to the version type, and start and stop the process and replace the parameter file by using the version deployment program. , def file generation and SQL script execution.
在一个实施例中，版本部署模块506还用于在执行版本部署程序的过程中***自动检测。In one embodiment, the version deployment module 506 is also used to insert automatic detection during the execution of the version deployment program.
在一个实施例中，配置文件生成模块502用于获取用户输入的版本部署所需要的基础数据；获取用户输入的配置文件一键生成命令，通过配置文件一键生成命令根据基础数据生成配置文件。In one embodiment, the configuration file generating module 502 is configured to acquire basic data required for version deployment by the user; obtain a configuration file one-key generation command input by the user, and generate a configuration file according to the basic data by using a configuration file one-key generation command.
上述在OGG版本部署***中的各个模块可全部或部分通过软件、硬件或其组合来实现。例如，在硬件实现上，上述脚本文件生成模块504可通过运行OGG版本部署平台的服务器的网络接口向源数据库或目标库下发脚本文件，其中，网络接口可以是以太网卡、无线网卡等。又例如，配置文件生成模块502获取到的版本部署所需要的基础数据以及根据基础数据生成的配置文件可存储在内存储器以及非易失性存储介质中，其中，非易失性存储介质可以是磁碟、光盘、硬盘等。而脚本文件生成模块504所生成的脚本文件也可以存储在内存储器以及非易失性存储介质中。上述各模块可以硬件形式内嵌于或独立于服务器的处理器中，也可以以软件形式存储于服务器的存储器中，以便于处理器调用执行以上各个模块对应的操作，其中，处理器可以为中央处理单元（CPU )、微处理器等。The various modules described above in the OGG version deployment system may be implemented in whole or in part by software, hardware or a combination thereof. For example, in the hardware implementation, the script file generating module 504 may send a script file to the source database or the target library through a network interface of the server running the OGG version deployment platform, where the network interface may be an Ethernet card, a wireless network card, or the like. For another example, the basic data required for the version deployment acquired by the configuration file generating module 502 and the configuration file generated according to the basic data may be stored in the internal memory and the non-volatile storage medium, wherein the non-volatile storage medium may be Disk, CD, hard disk, etc. The script file generated by the script file generation module 504 can also be stored in the internal memory as well as in the non-volatile storage medium. The above modules may be embedded in the hardware of the server or may be stored in the memory of the server in a software form, so that the processor can call the corresponding operations of the above modules, wherein the processor can be the central Processing unit (CPU ), microprocessor, etc.
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程，是可以通过计算机程序来指令相关的硬件来完成，所述的程序可存储于一计算机可读取存储介质中，该程序在执行时，可包括如上述各方法的实施例的流程。其中，所述的存储介质可为磁碟、光盘、只读存储记忆体（Read-Only Memory，ROM）等非易失性存储介质，或随机存储记忆体（Random Access Memory，RAM）等。One of ordinary skill in the art can understand that all or part of the process of implementing the foregoing embodiments can be completed by a computer program to instruct related hardware, and the program can be stored in a computer readable storage medium. When executed, the flow of an embodiment of the methods as described above may be included. The storage medium may be a magnetic disk, an optical disk, or a read-only storage memory (Read-Only) A nonvolatile storage medium such as a memory or a ROM, or a random access memory (RAM).
以上所述实施例的各技术特征可以进行任意的组合，为使描述简洁，未对上述实施例中的各个技术特征所有可能的组合都进行描述，然而，只要这些技术特征的组合不存在矛盾，都应当认为是本说明书记载的范围。The technical features of the above-described embodiments may be arbitrarily combined. For the sake of brevity of description, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction between the combinations of these technical features, All should be considered as the scope of this manual.
以上所述实施例仅表达了本发明的几种实施方式，其描述较为具体和详细，但并不能因此而理解为对发明专利范围的限制。应当指出的是，对于本领域的普通技术人员来说，在不脱离本发明构思的前提下，还可以做出若干变形和改进，这些都属于本发明的保护范围。因此，本发明专利的保护范围应以所附权利要求为准。The above-described embodiments are merely illustrative of several embodiments of the present invention, and the description thereof is more specific and detailed, but is not to be construed as limiting the scope of the invention. It should be noted that a number of variations and modifications may be made by those skilled in the art without departing from the spirit and scope of the invention. Therefore, the scope of the invention should be determined by the appended claims.

Claims (20)

  1. 一种OGG版本部署方法，包括：An OGG version deployment method, including:
    OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；The OGG deployment platform obtains basic data required for version deployment, and generates a configuration file according to the basic data, where the configuration file includes basic data required for version deployment;
    所述OGG部署平台根据所述配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中；及The OGG deployment platform generates link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and packages the link information, the parameter file, the SQL script, and the version type to generate a script file. Into the deployment directory; and
    所述OGG部署平台远程执行所述脚本文件，根据所述脚本文件部署版本。The OGG deployment platform remotely executes the script file, and deploys a version according to the script file.
  2. 根据权利要求1所述的方法，其特征在于，所述基础数据包括：The method of claim 1 wherein said base data comprises:
    数据库配置信息，包括数据库名称、数据库主机地址和数据库端口；Database configuration information, including database name, database host address, and database port;
    版本配置信息，包括OGG链路信息、OGG版本号和OGG版本发布日期；Version configuration information, including OGG link information, OGG version number, and OGG version release date;
    同步表配置信息，包括源表表名、源表字段名称、目标表名和目标字段名称。Synchronization table configuration information, including source table table name, source table field name, target table name, and target field name.
  3. 根据权利要求1所述的方法，其特征在于，所述根据脚本文件部署版本，包括：The method according to claim 1, wherein the deploying the version according to the script file comprises:
    根据所述链路信息查找到对应的源数据库和目标数据库，根据所述版本类型生成相应的版本部署程序，通过所述版本部署程序进行进程的启停操作、参数文件替换、def文件生成和SQL脚本执行。Finding a corresponding source database and a target database according to the link information, generating a corresponding version deployment program according to the version type, and performing start/stop operation, parameter file replacement, def file generation, and SQL by using the version deployment program. Script execution.
  4. 根据权利要求3所述的方法，其特征在于，所述根据脚本文件部署版本，还包括：在执行版本部署程序的过程中***自动检测。The method according to claim 3, wherein the deploying the version according to the script file further comprises: inserting an automatic detection during execution of the version deployment program.
  5. 根据权利要求1所述的方法，其特征在于，所述OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，包括：The method according to claim 1, wherein the OGG deployment platform acquires basic data required for version deployment, and generates a configuration file according to the basic data, including:
    所述OGG部署平台获取用户输入的版本部署所需要的基础数据；获取用户输入的配置文件一键生成命令，通过所述配置文件一键生成命令根据所述基础数据生成配置文件。The OGG deployment platform acquires the basic data required for the version input by the user; obtains a configuration key of the configuration file input by the user, and generates a configuration file according to the basic data by using the one-key generation command of the configuration file.
  6. 一种OGG版本部署***，包括：An OGG version deployment system that includes:
    配置文件生成模块，用于获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；a configuration file generating module, configured to acquire basic data required for version deployment, and generate a configuration file according to the basic data, where the configuration file includes basic data required for version deployment;
    脚本文件生成模块，用于根据所述配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类打包生成脚本文件下发到部署目录中；及a script file generating module, configured to generate link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and package the link information, the parameter file, the SQL script, and the version class to generate a script file. Issued to the deployment directory; and
    版本部署模块，用于远程执行所述脚本文件，根据所述脚本文件部署版本。a version deployment module, configured to remotely execute the script file, and deploy a version according to the script file.
  7. 根据权利要求6所述的***，其特征在于，所述基础数据包括数据库配置信息，包括数据库名称、数据库主机地址和数据库端口；The system according to claim 6, wherein said basic data comprises database configuration information, including a database name, a database host address, and a database port;
    版本配置信息，包括OGG链路信息、OGG版本号和OGG版本发布日期；Version configuration information, including OGG link information, OGG version number, and OGG version release date;
    同步表配置信息，包括源表表名、源表字段名称、目标表名和目标字段名称。Synchronization table configuration information, including source table table name, source table field name, target table name, and target field name.
  8. 根据权利要求6所述的***，其特征在于，所述版本部署模块用于根据所述链路信息查找到对应的源数据库和目标数据库，根据所述版本类型生成相应的版本部署程序，通过所述版本部署程序进行进程的启停操作、参数文件替换、def文件生成和SQL脚本执行。The system according to claim 6, wherein the version deployment module is configured to find a corresponding source database and a target database according to the link information, and generate a corresponding version deployment program according to the version type. The version deployment program performs process start-stop operations, parameter file replacement, def file generation, and SQL script execution.
  9. 根据权利要求8所述的***，其特征在于，所述版本部署模块还用于在执行版本部署程序的过程中***自动检测。The system of claim 8, wherein the version deployment module is further configured to insert an automatic detection during execution of the version deployment program.
  10. 根据权利要求6所述的***，其特征在于，所述配置文件生成模块用于获取用户输入的版本部署所需要的基础数据；获取用户输入的配置文件一键生成命令，通过所述配置文件一键生成命令根据所述基础数据生成配置文件。The system according to claim 6, wherein the configuration file generating module is configured to acquire basic data required for version deployment of the user input; and obtain a configuration file one-key generation command input by the user, by using the configuration file The key generation command generates a configuration file based on the basic data.
  11. 一种服务器，所述服务器中运行OGG部署平台，包括存储器和处理器，所述存储器中存储有指令，所述指令被所述处理器执行时，使得所述处理器执行以下步骤：A server running an OGG deployment platform, comprising a memory and a processor, the memory storing instructions, wherein when executed by the processor, the processor performs the following steps:
    通过OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；The basic data required for the version deployment is obtained by the OGG deployment platform, and the configuration file is generated according to the basic data, where the configuration file includes basic data required for version deployment;
    通过所述OGG部署平台根据所述配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中；及Generating, by the OGG deployment platform, link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and packaging the link information, the parameter file, the SQL script, and the version type to generate a script file. Sent to the deployment directory; and
    通过所述OGG部署平台远程执行所述脚本文件，根据所述脚本文件部署版本。The script file is remotely executed by the OGG deployment platform, and the version is deployed according to the script file.
  12. 根据权利要求11所述的服务器，其特征在于，所述基础数据包括： The server according to claim 11, wherein said basic data comprises:
    数据库配置信息，包括数据库名称、数据库主机地址和数据库端口；Database configuration information, including database name, database host address, and database port;
    版本配置信息，包括OGG链路信息、OGG版本号和OGG版本发布日期；Version configuration information, including OGG link information, OGG version number, and OGG version release date;
    同步表配置信息，包括源表表名、源表字段名称、目标表名和目标字段名称。Synchronization table configuration information, including source table table name, source table field name, target table name, and target field name.
  13. 根据权利要求11所述的服务器，其特征在于，所述根据脚本文件部署版本，包括：The server according to claim 11, wherein the deploying the version according to the script file comprises:
    根据所述链路信息查找到对应的源数据库和目标数据库，根据所述版本类型生成相应的版本部署程序，通过所述版本部署程序进行进程的启停操作、参数文件替换、def文件生成和SQL脚本执行。Finding a corresponding source database and a target database according to the link information, generating a corresponding version deployment program according to the version type, and performing start/stop operation, parameter file replacement, def file generation, and SQL by using the version deployment program. Script execution.
  14. 根据权利要求13所述的服务器，其特征在于，所述根据脚本文件部署版本，还包括：在执行版本部署程序的过程中***自动检测。The server according to claim 13, wherein the deploying the version according to the script file further comprises: inserting an automatic detection during execution of the version deployment program.
  15. 根据权利要求11所述的服务器，其特征在于，所述OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，包括：The server according to claim 11, wherein the OGG deployment platform acquires basic data required for version deployment, and generates a configuration file according to the basic data, including:
    所述OGG部署平台获取用户输入的版本部署所需要的基础数据；获取用户输入的配置文件一键生成命令，通过所述配置文件一键生成命令根据所述基础数据生成配置文件。The OGG deployment platform acquires the basic data required for the version input by the user; obtains a configuration key of the configuration file input by the user, and generates a configuration file according to the basic data by using the one-key generation command of the configuration file.
  16. 一个或多个存储有计算机可读指令的计算机非易失性存储介质，所述计算机可读指令被一个或多个处理器执行，使得所述一个或多个处理器执行以下步骤：One or more computer non-volatile storage media storing computer readable instructions, the computer readable instructions being executed by one or more processors, such that the one or more processors perform the following steps:
    通过OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，所述配置文件中包含版本部署需要的基础数据；The basic data required for the version deployment is obtained by the OGG deployment platform, and the configuration file is generated according to the basic data, where the configuration file includes basic data required for version deployment;
    通过所述OGG部署平台根据所述配置文件中的基础数据生成链路信息、参数文件、SQL脚本和版本类型，并将所述链路信息、参数文件、SQL脚本和版本类型打包生成脚本文件下发到部署目录中；Generating, by the OGG deployment platform, link information, a parameter file, a SQL script, and a version type according to the basic data in the configuration file, and packaging the link information, the parameter file, the SQL script, and the version type to generate a script file. Sent to the deployment directory;
    通过所述OGG部署平台远程执行所述脚本文件，根据所述脚本文件部署版本。The script file is remotely executed by the OGG deployment platform, and the version is deployed according to the script file.
  17. 根据权利要求16所述的存储介质，其特征在于，所述基础数据包括： The storage medium according to claim 16, wherein the basic data comprises:
    数据库配置信息，包括数据库名称、数据库主机地址和数据库端口；Database configuration information, including database name, database host address, and database port;
    版本配置信息，包括OGG链路信息、OGG版本号和OGG版本发布日期；Version configuration information, including OGG link information, OGG version number, and OGG version release date;
    同步表配置信息，包括源表表名、源表字段名称、目标表名和目标字段名称。Synchronization table configuration information, including source table table name, source table field name, target table name, and target field name.
  18. 根据权利要求16所述的存储介质，其特征在于，所述根据脚本文件部署版本，包括：The storage medium according to claim 16, wherein the deploying the version according to the script file comprises:
    根据所述链路信息查找到对应的源数据库和目标数据库，根据所述版本类型生成相应的版本部署程序，通过所述版本部署程序进行进程的启停操作、参数文件替换、def文件生成和SQL脚本执行。Finding a corresponding source database and a target database according to the link information, generating a corresponding version deployment program according to the version type, and performing start/stop operation, parameter file replacement, def file generation, and SQL by using the version deployment program. Script execution.
  19. 根据权利要求18所述的存储介质，其特征在于，所述根据脚本文件部署版本，还包括：在执行版本部署程序的过程中***自动检测。The storage medium according to claim 18, wherein the deploying the version according to the script file further comprises: inserting an automatic detection during execution of the version deployment program.
  20. 根据权利要求16所述的存储介质，其特征在于，所述OGG部署平台获取版本部署所需要的基础数据，根据所述基础数据生成配置文件，包括：The storage medium according to claim 16, wherein the OGG deployment platform acquires basic data required for version deployment, and generates a configuration file according to the basic data, including:
    所述OGG部署平台获取用户输入的版本部署所需要的基础数据；获取用户输入的配置文件一键生成命令，通过所述配置文件一键生成命令根据所述基础数据生成配置文件。The OGG deployment platform acquires the basic data required for the version input by the user; obtains a configuration key of the configuration file input by the user, and generates a configuration file according to the basic data by using the one-key generation command of the configuration file.
PCT/CN2017/074559 2016-04-11 2017-02-23 Ogg version deployment method and system, server, and storage medium WO2017177769A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201610222213.8 2016-04-11
CN201610222213.8A CN105867978B (en) 2016-04-11 2016-04-11 OGG version dispositions method and system

Publications (1)

Publication Number Publication Date
WO2017177769A1 true WO2017177769A1 (en) 2017-10-19

Family

ID=56637514

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/074559 WO2017177769A1 (en) 2016-04-11 2017-02-23 Ogg version deployment method and system, server, and storage medium

Country Status (2)

Country Link
CN (1) CN105867978B (en)
WO (1) WO2017177769A1 (en)

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109446267A (en) * 2018-09-25 2019-03-08 国家电网有限公司客户服务中心 It is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system and method for model
CN109840194A (en) * 2017-11-28 2019-06-04 网宿科技股份有限公司 A kind of detection method and system of configuration file
CN109901842A (en) * 2019-01-17 2019-06-18 深圳壹账通智能科技有限公司 Application deployment method, apparatus, computer equipment and storage medium
CN110597552A (en) * 2019-09-04 2019-12-20 浙江大搜车软件技术有限公司 Configuration method, device and equipment of project continuous integration pipeline and storage medium
CN110716914A (en) * 2019-09-02 2020-01-21 平安普惠企业管理有限公司 Database configuration method, system, computer readable storage medium and terminal equipment
CN111026414A (en) * 2019-12-12 2020-04-17 杭州安恒信息技术股份有限公司 HDP platform deployment method based on kubernets
CN111290906A (en) * 2020-01-10 2020-06-16 安徽科大国创软件科技有限公司 Java application monitoring method and system based on perception mechanism
CN111813439A (en) * 2020-07-17 2020-10-23 前海人寿保险股份有限公司 Distribution material quality control method, device, equipment and computer storage medium
CN111813683A (en) * 2020-07-14 2020-10-23 深圳前海移联科技有限公司 Universal automatic software test environment synchronization method
CN112162766A (en) * 2020-09-16 2021-01-01 银盛支付服务股份有限公司 Linux script application deployment method, system, computer equipment and storage medium
CN112631868A (en) * 2020-12-28 2021-04-09 浙江中控技术股份有限公司 Performance monitoring method and device of CentOS system
CN113239005A (en) * 2021-06-02 2021-08-10 上海许继电气有限公司 I, IV area data synchronization method and device for power monitoring system
CN114553930A (en) * 2022-01-26 2022-05-27 石化盈科信息技术有限责任公司 System integration method and device, computer equipment and storage medium
CN114816470A (en) * 2022-03-30 2022-07-29 海南乾唐视联信息技术有限公司 Metadata database management method and device, electronic equipment and medium

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105867978B (en) * 2016-04-11 2018-12-11 平安科技（深圳）有限公司 OGG version dispositions method and system
CN107729019A (en) * 2017-10-09 2018-02-23 平安普惠企业管理有限公司 Method, apparatus, equipment and the computer-readable storage medium of version deployment
CN108958751B (en) * 2018-06-01 2020-09-04 优刻得科技股份有限公司 Method, device, system and storage medium for software deployment or maintenance
CN108845915A (en) * 2018-07-02 2018-11-20 山东浪潮商用***有限公司 A kind of database data monitoring method
CN109189400A (en) * 2018-08-07 2019-01-11 北京趣拿软件科技有限公司 Program dissemination method and device, storage medium, processor
CN110162461B (en) * 2019-04-16 2023-08-15 平安科技（深圳）有限公司 Data synchronization verification method and device and computer equipment
CN111552746B (en) * 2020-04-30 2023-04-28 北京思特奇信息技术股份有限公司 Data synchronization method, device, electronic equipment and storage medium

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080072217A1 (en) * 2006-09-14 2008-03-20 International Business Machines Corporation Method, apparatus, and system for customizing and performing policy in version control
CN104102511A (en) * 2014-07-17 2014-10-15 福建星海通信科技有限公司 SQL (structured query language) Server based automatic script upgrading system and method
CN104965735A (en) * 2015-06-18 2015-10-07 北京京东尚科信息技术有限公司 Apparatus for generating upgrade SQL script
CN105068886A (en) * 2015-07-30 2015-11-18 上海新炬网络信息技术有限公司 Disaster backup intelligent switching control method based on GoldenGate
CN105204897A (en) * 2015-09-14 2015-12-30 上海新炬网络信息技术有限公司 Batched MySQL installation and deployment method
CN105867978A (en) * 2016-04-11 2016-08-17 平安科技（深圳）有限公司 OGG version deployment method and system

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080072217A1 (en) * 2006-09-14 2008-03-20 International Business Machines Corporation Method, apparatus, and system for customizing and performing policy in version control
CN104102511A (en) * 2014-07-17 2014-10-15 福建星海通信科技有限公司 SQL (structured query language) Server based automatic script upgrading system and method
CN104965735A (en) * 2015-06-18 2015-10-07 北京京东尚科信息技术有限公司 Apparatus for generating upgrade SQL script
CN105068886A (en) * 2015-07-30 2015-11-18 上海新炬网络信息技术有限公司 Disaster backup intelligent switching control method based on GoldenGate
CN105204897A (en) * 2015-09-14 2015-12-30 上海新炬网络信息技术有限公司 Batched MySQL installation and deployment method
CN105867978A (en) * 2016-04-11 2016-08-17 平安科技（深圳）有限公司 OGG version deployment method and system

Cited By (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109840194A (en) * 2017-11-28 2019-06-04 网宿科技股份有限公司 A kind of detection method and system of configuration file
CN109446267B (en) * 2018-09-25 2023-06-02 国家电网有限公司客户服务中心 Cross-database data integration system and method based on 95598 ex-situ double-active disaster recovery model
CN109446267A (en) * 2018-09-25 2019-03-08 国家电网有限公司客户服务中心 It is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system and method for model
CN109901842A (en) * 2019-01-17 2019-06-18 深圳壹账通智能科技有限公司 Application deployment method, apparatus, computer equipment and storage medium
CN110716914A (en) * 2019-09-02 2020-01-21 平安普惠企业管理有限公司 Database configuration method, system, computer readable storage medium and terminal equipment
CN110597552A (en) * 2019-09-04 2019-12-20 浙江大搜车软件技术有限公司 Configuration method, device and equipment of project continuous integration pipeline and storage medium
CN110597552B (en) * 2019-09-04 2023-08-18 浙江大搜车软件技术有限公司 Configuration method, device, equipment and storage medium of project continuous integrated pipeline
CN111026414A (en) * 2019-12-12 2020-04-17 杭州安恒信息技术股份有限公司 HDP platform deployment method based on kubernets
CN111026414B (en) * 2019-12-12 2023-09-08 杭州安恒信息技术股份有限公司 HDP platform deployment method based on kubernetes
CN111290906A (en) * 2020-01-10 2020-06-16 安徽科大国创软件科技有限公司 Java application monitoring method and system based on perception mechanism
CN111290906B (en) * 2020-01-10 2023-07-21 安徽科大国创软件科技有限公司 Java application monitoring method and system based on perception mechanism
CN111813683B (en) * 2020-07-14 2023-10-03 深圳前海移联科技有限公司 Universal automatic synchronization method for software testing environment
CN111813683A (en) * 2020-07-14 2020-10-23 深圳前海移联科技有限公司 Universal automatic software test environment synchronization method
CN111813439B (en) * 2020-07-17 2024-03-29 前海人寿保险股份有限公司 Distribution material quality control method, device, equipment and computer storage medium
CN111813439A (en) * 2020-07-17 2020-10-23 前海人寿保险股份有限公司 Distribution material quality control method, device, equipment and computer storage medium
CN112162766B (en) * 2020-09-16 2024-05-03 银盛支付服务股份有限公司 Linux script application deployment method, computer equipment and storage medium
CN112162766A (en) * 2020-09-16 2021-01-01 银盛支付服务股份有限公司 Linux script application deployment method, system, computer equipment and storage medium
CN112631868B (en) * 2020-12-28 2023-06-16 浙江中控技术股份有限公司 Performance monitoring method and device of CentOS system
CN112631868A (en) * 2020-12-28 2021-04-09 浙江中控技术股份有限公司 Performance monitoring method and device of CentOS system
CN113239005B (en) * 2021-06-02 2022-12-02 上海许继电气有限公司 I and IV area data synchronization method and device for power monitoring system
CN113239005A (en) * 2021-06-02 2021-08-10 上海许继电气有限公司 I, IV area data synchronization method and device for power monitoring system
CN114553930A (en) * 2022-01-26 2022-05-27 石化盈科信息技术有限责任公司 System integration method and device, computer equipment and storage medium
CN114553930B (en) * 2022-01-26 2024-04-16 石化盈科信息技术有限责任公司 System integration method, device, computer equipment and storage medium
CN114816470A (en) * 2022-03-30 2022-07-29 海南乾唐视联信息技术有限公司 Metadata database management method and device, electronic equipment and medium

Also Published As

Publication number Publication date
CN105867978B (en) 2018-12-11
CN105867978A (en) 2016-08-17

Similar Documents

Publication Publication Date Title
WO2017177769A1 (en) Ogg version deployment method and system, server, and storage medium
WO2018014582A1 (en) Insurance policy data processing method, device, servicer and storage medium
WO2018177107A1 (en) Data migration method, migration server, and storage medium
US11314698B2 (en) Dynamically performing data processing in a data pipeline system
WO2013149460A1 (en) Over the air upgrade method for continuous increment of android handheld device
TW497071B (en) Method and apparatus for managing clustered computer systems
WO2016095551A1 (en) Method and apparatus for implementing mysql database monitoring option script
CN112930528A (en) Upgrading a database from a first version to a second version
WO2018233037A1 (en) Database integration testing method, device, server, and storage medium
EP3816783B1 (en) Method and device for data migration
CN102012944B (en) Distributed NOSQL (not only structured query language) database capable of providing replication property
CN107844343A (en) The upgrade-system and method of a kind of complex services end application system
BRPI0718726A2 (en) "COMPUTER CONFIGURATION SYSTEM AND COMPUTER CONFIGURATION METHOD"
WO2016045193A1 (en) File index organization and repair method and device
US20190340075A1 (en) Emulating high-frequency application-consistent snapshots by forming restore point data sets based on remote site replay of i/o commands
WO2018090759A1 (en) Method for checking and compiling system start-up files
WO2021218142A1 (en) Data migration method and apparatus, and electronic device and computer readable storage medium
CN109977170A (en) The synchronous method and system of network data inside and outside a kind of government affairs
WO2012062113A1 (en) Method and system for realizing multi-core hot patching
Cooper Pilgrim: A debugger for distributed systems
WO2018221998A1 (en) Method for automatically analyzing bottleneck in real time and an apparatus for performing the method
CN114500289B (en) Control plane recovery method, device, control node and storage medium
WO2023229062A1 (en) Method and device for disarming ole object in ms-ooxml
WO2022227719A1 (en) Data backup method and system, and related device
US11895102B2 (en) Identity management

Legal Events

Date Code Title Description
NENP Non-entry into the national phase

Ref country code: DE

121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 17781745

Country of ref document: EP

Kind code of ref document: A1

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 04/02/2019)

122 Ep: pct application non-entry in european phase

Ref document number: 17781745

Country of ref document: EP

Kind code of ref document: A1