Movatterモバイル変換


[0]ホーム

URL:


CN104717233A - Database deployment method and device - Google Patents

Database deployment method and device
Download PDF

Info

Publication number
CN104717233A
CN104717233ACN201310671059.9ACN201310671059ACN104717233ACN 104717233 ACN104717233 ACN 104717233ACN 201310671059 ACN201310671059 ACN 201310671059ACN 104717233 ACN104717233 ACN 104717233A
Authority
CN
China
Prior art keywords
database
module
template
cloud platform
organization
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201310671059.9A
Other languages
Chinese (zh)
Other versions
CN104717233B (en
Inventor
刘天成
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Telecom Corp Ltd
Original Assignee
China Telecom Corp Ltd
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 China Telecom Corp LtdfiledCriticalChina Telecom Corp Ltd
Priority to CN201310671059.9ApriorityCriticalpatent/CN104717233B/en
Publication of CN104717233ApublicationCriticalpatent/CN104717233A/en
Application grantedgrantedCritical
Publication of CN104717233BpublicationCriticalpatent/CN104717233B/en
Activelegal-statusCriticalCurrent
Anticipated expirationlegal-statusCritical

Links

Classifications

Landscapes

Abstract

Translated fromChinese

本发明公开一种数据库部署方法和装置。其中在数据库部署方法中,当接收到数据库申请用户发送的新建数据库请求时,选择与指定组织相关联的资源包,在预先建立的与指定组织相关联的数据库模板库中,选择相对应的数据库模板;在资源包中设置数据库文件的存储空间和容量,以便利用选择的数据库模板新建数据库;设置新建数据库的参数集,设置新建数据库的用户名和密码,生成新建数据库访问文件和新建数据库通用唯一识别码,将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。从而便于集中管理云平台中不同组织、不同类型的数据库,而无需关心数据库的具体位置和部署过程,提升云平台数据库服务的提供效率。

The invention discloses a database deployment method and device. In the database deployment method, when receiving a new database request sent by a database application user, select the resource package associated with the specified organization, and select the corresponding database in the pre-established database template library associated with the specified organization Template; set the storage space and capacity of the database file in the resource package, so as to use the selected database template to create a new database; set the parameter set of the new database, set the user name and password of the new database, generate the new database access file and the universal unique identification of the new database code, and send the generated new database access file and new database universal unique identification code to the database application user. This facilitates centralized management of different organizations and different types of databases in the cloud platform, without the need to care about the specific location and deployment process of the database, and improves the efficiency of providing database services on the cloud platform.

Description

Translated fromChinese
数据库部署方法和装置Database deployment method and device

技术领域technical field

本发明涉及通信领域,特别涉及一种数据库部署方法和装置。The present invention relates to the communication field, in particular to a database deployment method and device.

背景技术Background technique

随着云计算和虚拟化技术的发展,许多业务平台都部署在云计算平台(以下简称云平台)统一管理的虚拟机中,同时,大部分业务平台均含有数据库部分,初期由于数据库对硬件性能的要求比较高,多安装在独立的物理服务器上,随着虚拟化技术的成熟和稳定,大部分数据库也逐步开始直接在虚拟机上进行安装和配置。With the development of cloud computing and virtualization technology, many business platforms are deployed in virtual machines under the unified management of cloud computing platforms (hereinafter referred to as cloud platforms). At the same time, most business platforms include databases. The requirements are relatively high, and they are mostly installed on independent physical servers. With the maturity and stability of virtualization technology, most databases have gradually begun to be installed and configured directly on virtual machines.

目前数据库在云平台的部署方式主要为:首先云平台管理员部署数据库专用虚拟机并安装操作系统,由数据库管理员通过图形或命令行方式接入虚拟机操作系统,手动安装数据库软件并配置自定义参数,业务平台的其它软件模块通过网络IP(Internet Protocol,互联网协议)地址访问数据库服务。现有的云平台中数据库的管理方式有以下几点问题:At present, the database deployment method on the cloud platform is mainly as follows: first, the cloud platform administrator deploys a virtual machine dedicated to the database and installs the operating system, and the database administrator accesses the virtual machine operating system through graphics or command lines, manually installs the database software and configures the Define parameters, and other software modules of the business platform access the database service through the network IP (Internet Protocol, Internet Protocol) address. The database management methods in the existing cloud platform have the following problems:

第一:云平台中数据库数量不断增长,来自不同部门和业务的数据库混杂在一起。云平台管理员缺少对云平台中数据库和对应虚拟资源的全局监控视图和管理能力。云平台数据库由业务管理员自行安装、配置和监控,影响数据库对虚拟资源的使用效率。First: The number of databases in the cloud platform is constantly growing, and databases from different departments and businesses are mixed together. Cloud platform administrators lack global monitoring views and management capabilities for databases and corresponding virtual resources in the cloud platform. The cloud platform database is installed, configured, and monitored by the business administrator, which affects the efficiency of the database's use of virtual resources.

第二:云平台数据库部署和配置所需时间较长,只能由业务管理员自行手动完成,对数据库申请用户的数据库配置和技术要求较高。Second: The cloud platform database deployment and configuration takes a long time, which can only be done manually by business administrators themselves, and has high database configuration and technical requirements for database application users.

第三:云平台中大量数据库升级、克隆、备份恢复和安全加固等工作只能由业务管理员自行手动完成,无法做到由云平台管理员统一调度和实施。降低了云平台中数据库的运行效率,加大了云平台中数据库和云平台自身的安全风险。Third: A large number of database upgrades, cloning, backup and recovery, and security reinforcement on the cloud platform can only be done manually by business administrators themselves, and cannot be uniformly scheduled and implemented by cloud platform administrators. The operating efficiency of the database in the cloud platform is reduced, and the security risks of the database in the cloud platform and the cloud platform itself are increased.

发明内容Contents of the invention

本发明实施例提供一种数据库部署方法和装置。通过对云平台中数据库统一管理、安装、分配和配置优化,从而向用户提供更快捷易用的数据库服务,减少用户申请数据库的整体部署时间和难度。通过组织架构管理实现云平台承载数据库资源的统一监控、调度和生命周期管理,提高云平台中数据库的管理规范性。通过统一升级、克隆、备份恢复和安全加固,降低云平台中数据库维护的复杂度。Embodiments of the present invention provide a database deployment method and device. Through the unified management, installation, distribution and configuration optimization of the database in the cloud platform, it can provide users with faster and easier-to-use database services, and reduce the overall deployment time and difficulty for users to apply for databases. Through organizational structure management, the unified monitoring, scheduling and lifecycle management of database resources carried by the cloud platform can be realized, and the management standardization of databases in the cloud platform can be improved. Reduce the complexity of database maintenance on the cloud platform through unified upgrade, cloning, backup recovery, and security hardening.

根据本发明的一个方面,提供一种数据库部署方法,包括:According to one aspect of the present invention, a database deployment method is provided, including:

当接收到数据库申请用户发送的新建数据库请求时,从新建数据库请求中提取出组织架构中的指定组织信息、以及数据库模板信息;When receiving the new database request sent by the database application user, extract the specified organization information and database template information in the organizational structure from the new database request;

选择与组织架构中的指定组织相关联的资源包,以便为新建数据库分配相关资源;Select the resource package associated with the specified organization in the organizational structure to allocate relevant resources for the newly created database;

在预先建立的与指定组织相关联的数据库模板库中,选择与数据库模板信息相对应的数据库模板;In the pre-established database template library associated with the specified organization, select a database template corresponding to the database template information;

在资源包中设置数据库文件的存储空间和容量,以便利用选择的数据库模板新建数据库;Set the storage space and capacity of the database file in the resource package, so as to use the selected database template to create a new database;

设置新建数据库的参数集;Set the parameter set for the new database;

设置新建数据库的用户名和密码;Set the username and password for the new database;

生成新建数据库访问文件和新建数据库通用唯一识别码;Generate a new database access file and a new database universal unique identification code;

将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。Send the generated new database access file and the new database universal unique identification code to the database application user.

优选的,在建立与指定组织相关联的数据库模板库时,包括:Preferably, when establishing a database template library associated with a specified organization, it includes:

在云平台中选择服务器集群以作为部署位置;Select a server cluster in the cloud platform as the deployment location;

按需求建立组织架构;Establish organizational structure according to needs;

建立与组织架构中的每个组织相关联的资源包;Create resource bundles associated with each organization in the organizational structure;

建立与每个组织相关联的数据库模板库;Build a library of database templates associated with each organization;

将建立的数据库模板库导入与相应组织相关联的资源包中。Import the established database template library into the resource package associated with the corresponding organization.

优选的,建立与每个组织相关联的数据库模板库的步骤包括:Preferably, the steps of establishing a database template library associated with each organization include:

针对每个组织,在云平台中建立至少一个虚拟机;For each organization, establish at least one virtual machine in the cloud platform;

在建立的虚拟机中安装需要的数据库;Install the required database in the established virtual machine;

将安装数据库的虚拟机封装为数据库模板;Encapsulate the virtual machine where the database is installed as a database template;

建立默认数据库配置参数集。Establishes a default set of database configuration parameters.

优选的,在云平台中选择服务器集群以作为部署位置的步骤包括:Preferably, the step of selecting a server cluster in the cloud platform as a deployment location includes:

判断在云平台中是否存在服务器集群;Determine whether there is a server cluster in the cloud platform;

若在云平台中存在服务器集群,则在云平台中选择已经存在的服务器集群以作为部署位置;If there is a server cluster in the cloud platform, select an existing server cluster in the cloud platform as the deployment location;

若在云平台中不存在服务器集群,则在云平台中新建服务器集群以作为部署位置。If there is no server cluster in the cloud platform, create a new server cluster in the cloud platform as the deployment location.

根据本发明的另一方面,提供一种数据库部署装置,包括接口单元、提取单元、资源包选择单元、模板选择单元、第一设置单元、第二设置单元、第三设置单元和信息生成单元,其中:According to another aspect of the present invention, a database deployment device is provided, including an interface unit, an extraction unit, a resource package selection unit, a template selection unit, a first setting unit, a second setting unit, a third setting unit, and an information generation unit, in:

接口单元,用于接收数据库申请用户发送的新建数据库请求;根据信息生成单元的指示,将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户;The interface unit is used to receive the new database request sent by the database application user; according to the instructions of the information generation unit, send the generated new database access file and the new database universal unique identification code to the database application user;

提取单元,用于当接口单元接收到数据库申请用户发送的新建数据库请求时,从新建数据库请求中提取出组织架构中的指定组织信息、以及数据库模板信息;The extraction unit is used to extract the specified organization information and database template information in the organizational structure from the new database request when the interface unit receives the new database request sent by the database application user;

资源包选择单元,用于选择与组织架构中的指定组织相关联的资源包,以便为新建数据库分配相关资源;A resource package selection unit, configured to select a resource package associated with a specified organization in the organizational structure, so as to allocate relevant resources for the newly created database;

模板选择单元,用于在预先建立的与指定组织相关联的数据库模板库中,选择与数据库模板信息相对应的数据库模板;a template selection unit, configured to select a database template corresponding to database template information in a pre-established database template library associated with a designated organization;

第一设置单元,用于在资源包中设置数据库文件的存储空间和容量,以便利用选择的数据库模板新建数据库;The first setting unit is used to set the storage space and capacity of the database file in the resource package, so as to use the selected database template to create a new database;

第二设置单元,用于设置新建数据库的参数集;The second setting unit is used to set the parameter set of the new database;

第三设置单元,用于设置新建数据库的用户名和密码;The third setting unit is used to set the user name and password of the newly created database;

信息生成单元,用于生成新建数据库访问文件和新建数据库通用唯一识别码;指示接口单元将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。The information generating unit is used to generate a new database access file and a new database universal unique identification code; instruct the interface unit to send the generated new database access file and new database universal unique identification code to the database application user.

优选的,上述装置还包括模板库建立单元,其中模板库建立单元包括集群选择模块、组织架构建立模块、资源包建立模块、模板库建立模块和模板库导入模块,其中:Preferably, the above device further includes a template library building unit, wherein the template library building unit includes a cluster selection module, an organizational structure building module, a resource package building module, a template library building module, and a template library importing module, wherein:

集群选择模块,用于在建立与指定组织相关联的数据库模板库时,在云平台中选择服务器集群以作为部署位置;The cluster selection module is used to select a server cluster in the cloud platform as a deployment location when establishing a database template library associated with a specified organization;

组织架构建立模块,用于按需求建立组织架构;The organizational structure establishment module is used to establish the organizational structure according to the requirements;

资源包建立模块,用于建立与组织架构中的每个组织相关联的资源包;A resource pack establishing module, configured to establish a resource pack associated with each organization in the organizational structure;

模板库建立模块,用于建立与每个组织相关联的数据库模板库;A template library building module, used to create a database template library associated with each organization;

模板库导入模块,用于将建立的数据库模板库导入与相应组织相关联的资源包中。The template library import module is used to import the established database template library into the resource package associated with the corresponding organization.

优选的,模板库建立模块包括虚拟机建立模块、安装模块、封装模块和参数集建立模块,其中:Preferably, the template library building module includes a virtual machine building module, an installation module, an encapsulation module and a parameter set building module, wherein:

虚拟机建立模块,用于针对每个组织,在云平台中建立至少一个虚拟机;The virtual machine establishment module is used for establishing at least one virtual machine in the cloud platform for each organization;

安装模块,用于在建立的虚拟机中安装需要的数据库;The installation module is used to install the required database in the established virtual machine;

封装模块,用于将安装数据库的虚拟机封装为数据库模板;The encapsulation module is used to encapsulate the virtual machine on which the database is installed as a database template;

参数集建立模块,用于建立默认数据库配置参数集。The parameter set establishing module is used to establish a default database configuration parameter set.

优选的,集群选择模块包括识别模块和选择模块,其中:Preferably, the cluster selection module includes an identification module and a selection module, wherein:

识别模块,用于判断在云平台中是否存在服务器集群;An identification module, configured to determine whether there is a server cluster in the cloud platform;

选择模块,用于根据识别模块的判断结果,若在云平台中存在服务器集群,则在云平台中选择已经存在的服务器集群以作为部署位置;若在云平台中不存在服务器集群,则在云平台中新建服务器集群以作为部署位置。The selection module is used to select an existing server cluster in the cloud platform as a deployment location if there is a server cluster in the cloud platform according to the judgment result of the identification module; if there is no server cluster in the cloud platform, then in the cloud platform Create a new server cluster in the platform as the deployment location.

本发明通过在与指定组织相关联的数据库模板库中选择相关的数据库模块,根据设置的存储空间和容量,利用选择的数据库模块新建数据库。从而便于集中管理云平台中不同组织、不同类型的数据库,而无需关心数据库的具体位置和部署过程,提升云平台数据库服务的提供效率。The invention selects a relevant database module in a database template library associated with a designated organization, and uses the selected database module to create a new database according to the set storage space and capacity. This facilitates centralized management of different organizations and different types of databases in the cloud platform, without the need to care about the specific location and deployment process of the database, and improves the efficiency of providing database services on the cloud platform.

附图说明Description of drawings

为了更清楚地说明本发明实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本发明的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动性的前提下,还可以根据这些附图获得其他的附图。In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. For those skilled in the art, other drawings can also be obtained according to these drawings without any creative effort.

图1为本发明数据库部署方法一个实施例的示意图。Fig. 1 is a schematic diagram of an embodiment of the database deployment method of the present invention.

图2为本发明建立数据库模板库一个实施例的示意图。Fig. 2 is a schematic diagram of an embodiment of establishing a database template library in the present invention.

图3为本发明建立数据库模板一个实施例的示意图。Fig. 3 is a schematic diagram of an embodiment of establishing a database template in the present invention.

图4为本发明数据库部署装置一个实施例的示意图。Fig. 4 is a schematic diagram of an embodiment of the database deployment device of the present invention.

图5为本发明数据库部署装置另一实施例的示意图。Fig. 5 is a schematic diagram of another embodiment of the database deployment device of the present invention.

图6为本发明模板库建立单元一个实施例的示意图。Fig. 6 is a schematic diagram of an embodiment of the template library building unit of the present invention.

图7为本发明模板库建立模块一个实施例的示意图。Fig. 7 is a schematic diagram of an embodiment of the template library building module of the present invention.

图8为本发明集群选择模块一个实施例的示意图。Fig. 8 is a schematic diagram of an embodiment of the cluster selection module of the present invention.

图9为本发明云平台数据库管理系统架构一个实施例的示意图。FIG. 9 is a schematic diagram of an embodiment of the cloud platform database management system architecture of the present invention.

图10为本发明云数据库管理平台架构一个实施例的示意图。FIG. 10 is a schematic diagram of an embodiment of the cloud database management platform architecture of the present invention.

图11为本发明数据库接口模块一个实施例的示意图。Fig. 11 is a schematic diagram of an embodiment of the database interface module of the present invention.

图12为本发明数据库管理服务模块一个实施例的示意图。Fig. 12 is a schematic diagram of an embodiment of the database management service module of the present invention.

图13为本发明策略服务管理模块一个实施例的示意图。Fig. 13 is a schematic diagram of an embodiment of the policy service management module of the present invention.

图14为本发明云计算基础架构整合模块一个实施例的示意图。Fig. 14 is a schematic diagram of an embodiment of the cloud computing infrastructure integration module of the present invention.

具体实施方式Detailed ways

下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分实施例,而不是全部的实施例。以下对至少一个示例性实施例的描述实际上仅仅是说明性的,决不作为对本发明及其应用或使用的任何限制。基于本发明中的实施例,本领域普通技术人员在没有作出创造性劳动前提下所获得的所有其他实施例,都属于本发明保护的范围。The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. The following description of at least one exemplary embodiment is merely illustrative in nature and in no way taken as limiting the invention, its application or uses. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

除非另外具体说明,否则在这些实施例中阐述的部件和步骤的相对布置、数字表达式和数值不限制本发明的范围。The relative arrangements of components and steps, numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.

同时,应当明白,为了便于描述,附图中所示出的各个部分的尺寸并不是按照实际的比例关系绘制的。At the same time, it should be understood that, for the convenience of description, the sizes of the various parts shown in the drawings are not drawn according to the actual proportional relationship.

对于相关领域普通技术人员已知的技术、方法和设备可能不作详细讨论,但在适当情况下,所述技术、方法和设备应当被视为授权说明书的一部分。Techniques, methods and devices known to those of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, such techniques, methods and devices should be considered part of the Authorized Specification.

在这里示出和讨论的所有示例中,任何具体值应被解释为仅仅是示例性的,而不是作为限制。因此,示例性实施例的其它示例可以具有不同的值。In all examples shown and discussed herein, any specific values should be construed as illustrative only, and not as limiting. Therefore, other examples of the exemplary embodiment may have different values.

应注意到:相似的标号和字母在下面的附图中表示类似项,因此,一旦某一项在一个附图中被定义,则在随后的附图中不需要对其进行进一步讨论。It should be noted that like numbers and letters denote similar items in the following figures, therefore, once an item is defined in one figure, it does not require further discussion in subsequent figures.

图1为本发明数据库部署方法一个实施例的示意图。如图1所示,本实施例的方法步骤如下:Fig. 1 is a schematic diagram of an embodiment of the database deployment method of the present invention. As shown in Figure 1, the method steps of this embodiment are as follows:

步骤101,当接收到数据库申请用户发送的新建数据库请求时,从新建数据库请求中提取出组织架构中的指定组织信息、以及数据库模板信息。Step 101, when receiving a database creation request sent by a database application user, extract specified organization information in the organization structure and database template information from the database creation request.

步骤102,选择与组织架构中的指定组织相关联的资源包,以便为新建数据库分配相关资源。Step 102, selecting a resource package associated with a specified organization in the organization structure, so as to allocate related resources for the newly created database.

例如,相关资源包括数据库所需的CPU(Central Processing Unit,中央处理单元)和内存资源。For example, related resources include CPU (Central Processing Unit, central processing unit) and memory resources required by the database.

步骤103,在预先建立的与指定组织相关联的数据库模板库中,选择与数据库模板信息相对应的数据库模板。Step 103, in the pre-established database template library associated with the designated organization, select a database template corresponding to the database template information.

步骤104,在资源包中设置数据库文件的存储空间和容量,以便利用选择的数据库模板新建数据库。Step 104, setting the storage space and capacity of the database file in the resource package, so as to use the selected database template to create a new database.

步骤105,设置新建数据库的参数集。Step 105, setting the parameter set of the newly created database.

步骤106,设置新建数据库的用户名和密码。Step 106, setting the user name and password of the newly created database.

步骤107,生成新建数据库访问文件和新建数据库通用唯一识别码(Universally Unique Identifier,缩写:UUID)。Step 107, generating a new database access file and a new database universally unique identifier (Universally Unique Identifier, abbreviation: UUID).

步骤108,将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。Step 108, sending the generated new database access file and the new database universal unique identification code to the database application user.

基于本发明上述实施例提供的数据库部署方法,通过在与指定组织相关联的数据库模板库中选择相关的数据库模块,根据设置的存储空间和容量,利用选择的数据库模块新建数据库。从而便于集中管理云平台中不同组织、不同类型的数据库,而无需关心数据库的具体位置和部署过程,提升云平台数据库服务的提供效率。Based on the database deployment method provided by the above embodiments of the present invention, by selecting the relevant database module in the database template library associated with the specified organization, and using the selected database module to create a new database according to the set storage space and capacity. This facilitates centralized management of different organizations and different types of databases in the cloud platform, without the need to care about the specific location and deployment process of the database, and improves the efficiency of providing database services on the cloud platform.

图2为本发明建立数据库模板库一个实施例的示意图。如图2所示,本实施例的方法步骤包括:Fig. 2 is a schematic diagram of an embodiment of establishing a database template library in the present invention. As shown in Figure 2, the method steps of this embodiment include:

步骤201,在建立与指定组织相关联的数据库模板库时,在云平台中选择服务器集群以作为部署位置。Step 201, when establishing a database template library associated with a designated organization, select a server cluster in the cloud platform as a deployment location.

例如,若干台服务服务器可以组成一个虚拟化集群,实现资源的共享和统一调度。For example, several service servers can form a virtual cluster to realize resource sharing and unified scheduling.

优选的,在选择服务器集群时,判断在云平台中是否存在服务器集群。若在云平台中存在服务器集群,则在云平台中选择已经存在的服务器集群以作为部署位置;若在云平台中不存在服务器集群,则在云平台中新建服务器集群以作为部署位置。Preferably, when selecting a server cluster, it is determined whether there is a server cluster in the cloud platform. If there is a server cluster in the cloud platform, select an existing server cluster in the cloud platform as the deployment location; if there is no server cluster in the cloud platform, create a new server cluster in the cloud platform as the deployment location.

步骤202,按需求建立组织架构。Step 202, establishing an organizational structure according to requirements.

例如,建立一个公司组织X,建立两个下属组织A、B,并建立两个数据库管理员,分别授予组织A、B的管理权限。For example, establish a company organization X, establish two subordinate organizations A and B, and establish two database administrators, and grant management authority to organizations A and B respectively.

步骤203,建立与组织架构中的每个组织相关联的资源包。Step 203, establishing a resource package associated with each organization in the organizational structure.

例如,建立一个资源包,选择云平台集群中的若干台物理服务器,用于后续承载数据库,可设置以下参数:For example, to create a resource package and select several physical servers in the cloud platform cluster for subsequent hosting of the database, the following parameters can be set:

1)CPU和内存资源的份额(总量不能超过物理资源)、预留(最低保证的资源下限)、限制(当前上限,不能超过总量,可后期调整);1) The share of CPU and memory resources (the total amount cannot exceed physical resources), reservation (lower limit of guaranteed resources), limit (current upper limit, cannot exceed the total amount, and can be adjusted later);

2)存储空间(基于云平台共享存储中已导入的逻辑存储块);2) Storage space (based on imported logical storage blocks in the shared storage of the cloud platform);

3)网络配置(本资源包共享的网络参数,包括VLAN(Virtual LocalArea Network,虚拟局域网)、网络掩码、网关、DNS(Domain NameSystem,域名系统)和可分配地址段)。3) Network configuration (network parameters shared by this resource pack, including VLAN (Virtual Local Area Network, virtual local area network), netmask, gateway, DNS (Domain NameSystem, Domain Name System) and assignable address segments).

步骤204,建立与每个组织相关联的数据库模板库。Step 204, establishing a database template library associated with each organization.

步骤205,将建立的数据库模板库导入与相应组织相关联的资源包中。Step 205, import the established database template library into the resource package associated with the corresponding organization.

优选的,在本实施例中,可在步骤201后,建立一台虚拟机,通过该虚拟机执行本实施例的其它步骤。其中虚拟机可设置如下参数:Preferably, in this embodiment, after step 201, a virtual machine can be established, and other steps of this embodiment can be executed through this virtual machine. The virtual machine can set the following parameters:

1)系统管理用网络设置,包括IP地址、网关和DNS;1) Network settings for system management, including IP address, gateway and DNS;

2)云平台管理VLAN和IP地址,用于调用虚拟化层接口;2) The cloud platform manages VLANs and IP addresses, which are used to call virtualization layer interfaces;

3)内部网络通信VLAN,用于数据库和本系统通信;3) Internal network communication VLAN, used for communication between the database and the system;

4)管理员帐号。4) Administrator account.

图3为本发明建立数据库模板一个实施例的示意图。如图3所示,上述步骤204具体包括以下方法步骤:Fig. 3 is a schematic diagram of an embodiment of establishing a database template in the present invention. As shown in Figure 3, the above step 204 specifically includes the following method steps:

步骤301,针对每个组织,在云平台中建立至少一个虚拟机。Step 301, for each organization, establish at least one virtual machine in the cloud platform.

步骤302,在建立的虚拟机中安装需要的数据库。Step 302, installing the required database in the established virtual machine.

步骤303,将安装数据库的虚拟机封装为数据库模板。Step 303, packaging the virtual machine on which the database is installed as a database template.

步骤304,建立默认数据库配置参数集。Step 304, establishing a default database configuration parameter set.

图4为本发明数据库部署装置一个实施例的示意图。如图4所示,该装置包括接口单元401、提取单元402、资源包选择单元403、模板选择单元404、第一设置单元405、第二设置单元406、第三设置单元407和信息生成单元408,其中:Fig. 4 is a schematic diagram of an embodiment of the database deployment device of the present invention. As shown in Figure 4, the device includes an interface unit 401, an extraction unit 402, a resource package selection unit 403, a template selection unit 404, a first setting unit 405, a second setting unit 406, a third setting unit 407 and an information generation unit 408 ,in:

接口单元401,用于接收数据库申请用户发送的新建数据库请求;根据信息生成单元408的指示,将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。The interface unit 401 is used to receive the request for creating a new database sent by the database application user; according to the instruction of the information generating unit 408, send the generated new database access file and the new database universal unique identification code to the database application user.

提取单元402,用于当接口单元401接收到数据库申请用户发送的新建数据库请求时,从新建数据库请求中提取出组织架构中的指定组织信息、以及数据库模板信息。The extraction unit 402 is configured to, when the interface unit 401 receives a database creation request sent by a database application user, extract specified organization information and database template information in the organization structure from the database creation request.

资源包选择单元403,用于选择与组织架构中的指定组织相关联的资源包,以便为新建数据库分配相关资源。The resource package selection unit 403 is configured to select a resource package associated with a specified organization in the organization structure, so as to allocate related resources for the newly created database.

模板选择单元404,用于在预先建立的与指定组织相关联的数据库模板库中,选择与数据库模板信息相对应的数据库模板。The template selection unit 404 is configured to select a database template corresponding to the database template information from a pre-established database template library associated with the specified organization.

第一设置单元405,用于在资源包中设置数据库文件的存储空间和容量,以便利用选择的数据库模板新建数据库。The first setting unit 405 is configured to set the storage space and capacity of the database file in the resource package, so as to use the selected database template to create a new database.

第二设置单元406,用于设置新建数据库的参数集。The second setting unit 406 is configured to set the parameter set of the newly created database.

第三设置单元407,用于设置新建数据库的用户名和密码。The third setting unit 407 is used to set the user name and password of the newly created database.

信息生成单元408,用于生成新建数据库访问文件和新建数据库通用唯一识别码;指示接口单元401将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。The information generation unit 408 is configured to generate a new database access file and a new database universal unique identification code; instruct the interface unit 401 to send the generated new database access file and new database universal unique identification code to the database application user.

基于本发明上述实施例提供的数据库部署装置,通过在与指定组织相关联的数据库模板库中选择相关的数据库模块,根据设置的存储空间和容量,利用选择的数据库模块新建数据库。从而便于集中管理云平台中不同组织、不同类型的数据库,而无需关心数据库的具体位置和部署过程,提升云平台数据库服务的提供效率。Based on the database deployment device provided by the above embodiments of the present invention, by selecting the relevant database module in the database template library associated with the specified organization, according to the set storage space and capacity, use the selected database module to create a new database. This facilitates centralized management of different organizations and different types of databases in the cloud platform, without the need to care about the specific location and deployment process of the database, and improves the efficiency of providing database services on the cloud platform.

图5为本发明数据库部署装置另一实施例的示意图。与图4所示实施例相比,在图5所示实施例中,还包括模板库建立单元501,用于建立数据库模板库。Fig. 5 is a schematic diagram of another embodiment of the database deployment device of the present invention. Compared with the embodiment shown in FIG. 4 , the embodiment shown in FIG. 5 further includes a template library building unit 501 for building a database template library.

图6为本发明模板库建立单元一个实施例的示意图。如图6所示,模板库建立单元包括集群选择模块601、组织架构建立模块602、资源包建立模块603、模板库建立模块604和模板库导入模块605。其中:Fig. 6 is a schematic diagram of an embodiment of the template library building unit of the present invention. As shown in FIG. 6 , the template library building unit includes a cluster selection module 601 , an organizational structure building module 602 , a resource package building module 603 , a template library building module 604 and a template library importing module 605 . in:

集群选择模块601,用于在建立与指定组织相关联的数据库模板库时,在云平台中选择服务器集群以作为部署位置。The cluster selection module 601 is configured to select a server cluster in the cloud platform as a deployment location when establishing a database template library associated with a specified organization.

组织架构建立模块602,用于按需求建立组织架构。The organizational structure establishment module 602 is configured to establish an organizational structure according to requirements.

资源包建立模块603,用于建立与组织架构中的每个组织相关联的资源包。A resource package establishing module 603, configured to establish a resource package associated with each organization in the organizational structure.

模板库建立模块604,用于建立与每个组织相关联的数据库模板库。Template library building module 604, configured to create a database template library associated with each organization.

模板库导入模块605,用于将建立的数据库模板库导入与相应组织相关联的资源包中。The template library importing module 605 is configured to import the established database template library into the resource package associated with the corresponding organization.

图7为本发明模板库建立模块一个实施例的示意图。如图7所示,模板库建立模块包括虚拟机建立模块701、安装模块702、封装模块703和参数集建立模块704。其中:Fig. 7 is a schematic diagram of an embodiment of the template library building module of the present invention. As shown in FIG. 7 , the template library creation module includes a virtual machine creation module 701 , an installation module 702 , an encapsulation module 703 and a parameter set creation module 704 . in:

虚拟机建立模块701,用于针对每个组织,在云平台中建立至少一个虚拟机。The virtual machine establishing module 701 is configured to establish at least one virtual machine in the cloud platform for each organization.

安装模块702,用于在建立的虚拟机中安装需要的数据库。The installation module 702 is configured to install a required database in the created virtual machine.

封装模块703,用于将安装数据库的虚拟机封装为数据库模板。The encapsulation module 703 is configured to encapsulate the virtual machine on which the database is installed as a database template.

参数集建立模块704,用于建立默认数据库配置参数集。A parameter set establishing module 704, configured to establish a default database configuration parameter set.

图8为本发明集群选择模块一个实施例的示意图。如图8所示,集群选择模块包括识别模块801和选择模块802。其中:Fig. 8 is a schematic diagram of an embodiment of the cluster selection module of the present invention. As shown in FIG. 8 , the cluster selection module includes an identification module 801 and a selection module 802 . in:

识别模块801,用于判断在云平台中是否存在服务器集群。The identification module 801 is used to determine whether there is a server cluster in the cloud platform.

选择模块802,用于根据识别模块801的判断结果,若在云平台中存在服务器集群,则在云平台中选择已经存在的服务器集群以作为部署位置;若在云平台中不存在服务器集群,则在云平台中新建服务器集群以作为部署位置。Selection module 802, for according to the judgment result of identification module 801, if there is a server cluster in the cloud platform, then select an existing server cluster in the cloud platform as the deployment location; if there is no server cluster in the cloud platform, then Create a new server cluster on the cloud platform as the deployment location.

下面对云平台数据库管理系统架构进行描述。如图9所示,该系统包括云数据库管理平台901、云计算虚拟化平台902、物理资源集合903和云计算管理平台904。其中:The following describes the architecture of the cloud platform database management system. As shown in FIG. 9 , the system includes a cloud database management platform 901 , a cloud computing virtualization platform 902 , a collection of physical resources 903 and a cloud computing management platform 904 . in:

云数据库管理平台901:业务管理员可以通过本系统浏览和管理本人申请的数据库,云平台管理员可以通过本系统部署和管理所有云平台数据库。本系统利用云计算虚拟化平台902提供的接口调度虚拟资源,同时接受云计算管理平台904的管理。其中在云数据库管理平台中设有本发明涉及的数据库部署装置。Cloud database management platform 901: business administrators can browse and manage the databases applied by themselves through this system, and cloud platform administrators can deploy and manage all cloud platform databases through this system. The system uses the interface provided by the cloud computing virtualization platform 902 to schedule virtual resources, and accepts the management of the cloud computing management platform 904 at the same time. The database deployment device involved in the present invention is provided in the cloud database management platform.

云计算虚拟化平台902:统一管理物理资源集合903,为云数据库管理平台901提供虚拟资源接口。Cloud computing virtualization platform 902: manages the collection of physical resources 903 in a unified manner, and provides a virtual resource interface for the cloud database management platform 901.

物理资源集合903:包括CPU、内存、存储和网络接口资源。Physical resource collection 903: including CPU, memory, storage and network interface resources.

云计算管理平台904:统一管理所有云计算相关资源,实现包括数据库在内的虚拟机管理调度,由云平台管理员操作,同时可以调用接口管理云数据库管理平台901。Cloud computing management platform 904: manages all cloud computing-related resources in a unified manner, realizes virtual machine management and scheduling including databases, is operated by cloud platform administrators, and can call interface management cloud database management platform 901 at the same time.

图10为本发明云数据库管理平台架构一个实施例的示意图。如图10所示,云数据库管理平台包括数据库接口模块1001、数据库管理服务模块1002、策略管理服务模块1003和云计算基础架构整合模块1004。其中:FIG. 10 is a schematic diagram of an embodiment of the cloud database management platform architecture of the present invention. As shown in FIG. 10 , the cloud database management platform includes a database interface module 1001 , a database management service module 1002 , a policy management service module 1003 and a cloud computing infrastructure integration module 1004 . in:

数据库接口模块1001,如图11所示,包括Oracle接口(Oracle CallInterface,简称:OCI)、MySQL接口(C语言API)和Postgres接口(Libpq接口)种数据库接口模块,当然还可以按需求加入支持其它数据库的接口模块。调用这些数据库提供的API和修改配置文件可以完成自动安装数据库、在安装前自定义参数修改数据库配置,安装完成后或复制数据库后自动修改数据库的唯一实例标识SID。Database interface module 1001, as shown in Figure 11, includes Oracle interface (Oracle CallInterface, referred to as: OCI), MySQL interface (C language API) and Postgres interface (Libpq interface) database interface modules, of course, it can also be added to support other The interface module of the database. Calling the API provided by these databases and modifying the configuration files can complete the automatic installation of the database, modify the database configuration by customizing parameters before installation, and automatically modify the unique instance identifier SID of the database after the installation is completed or after the database is copied.

数据库管理服务模块1002,如图12所示,可包括如下模块:The database management service module 1002, as shown in Figure 12, may include the following modules:

数据库部署功能模块:接收用户输入的参数配置和数据库模版选择,调用对应的数据库接口模块,按需在指定的组织和存储位置部署数据库,并完成参数配置。Database deployment function module: Receive user input parameter configuration and database template selection, call the corresponding database interface module, deploy the database in the specified organization and storage location as required, and complete parameter configuration.

数据库更新模块:根据用户选择或指定模版,自动更新单个或多个同一模版生成的数据库,实现批量数据库补丁更新。Database update module: according to the template selected or specified by the user, automatically update the database generated by one or more same templates, and realize batch database patch updates.

数据库备份恢复模块:调用虚拟化功能接口中的虚拟化功能接口模块,利用虚拟机的克隆或快照功能,生成数据库虚拟机的备份文件,实现数据库的备份和恢复。Database backup and recovery module: call the virtualization function interface module in the virtualization function interface, use the clone or snapshot function of the virtual machine to generate the backup file of the database virtual machine, and realize the backup and recovery of the database.

数据库克隆模块:调用虚拟化功能接口中的虚拟化功能接口模块,利用虚拟机的克隆功能直接生成数据库虚拟机的副本,需要修改数据库实例的唯一标识符。Database cloning module: call the virtualization function interface module in the virtualization function interface, use the virtual machine cloning function to directly generate a copy of the database virtual machine, and need to modify the unique identifier of the database instance.

数据库资源监控模块:调用虚拟化功能接口中的虚拟资源调度模块获取数据库虚拟机的运行指标和性能参数,利用数据库模版中内置的脚本,获取数据库的常用性能指标,并通过图形化的方式展现在平台界面中。Database resource monitoring module: Call the virtual resource scheduling module in the virtualization function interface to obtain the running indicators and performance parameters of the database virtual machine, use the built-in script in the database template to obtain the common performance indicators of the database, and display them in a graphical way in the platform interface.

对外功能接口模块:提供以上功能模块的接口API,供外部云管理平台调用。External function interface module: Provide the interface API of the above function modules for calling by the external cloud management platform.

策略管理服务模块1003,如图13所示,可包括如下模块:Policy management service module 1003, as shown in Figure 13, may include the following modules:

组织架构管理模块:对云平台内用户、组织和数据库进行逻辑层级管理,一种组织方法为设定某公司为顶层组织,内部不同部门为二级组织,各部门数据库申请人为用户,各部门组织内存放常用数据库模版和数据库实例。Organizational structure management module: manage users, organizations and databases in the cloud platform at a logical level. One organizational method is to set a company as the top-level organization, different internal departments as secondary organizations, database applicants for each department as users, and organizations for each department Commonly used database templates and database instances are stored in the memory.

安全管理模块:将平台内的各项功能分配为若干项权限。为用户设定所需的的管理权限,同时可以根据组织和每个数据库划分管理权限,实现每个用户仅能浏览或管理指定的数据库。Security management module: assign various functions in the platform to several permissions. Set the required management authority for the user, and at the same time divide the management authority according to the organization and each database, so that each user can only browse or manage the specified database.

模版管理模块:负责生成和管理所有的数据库模版,提供将数据库虚拟机封装为模版的功能,并可以调用对应的数据库接口模块,自定义数据库模版预置参数。Template management module: responsible for generating and managing all database templates, providing the function of packaging the database virtual machine into a template, and calling the corresponding database interface module to customize the preset parameters of the database template.

云计算基础架构整合模块1004,如图14所示,可包括如下模块:The cloud computing infrastructure integration module 1004, as shown in Figure 14, may include the following modules:

虚拟资源调度模块:通过调用虚拟化功能接口模块,利用资源包的资源预留功能,设置指定数据库的虚拟资源上限、下限和变化幅度,实现业务系统数据库的服务质量保障(QoS)。Virtual resource scheduling module: by calling the virtualization function interface module, using the resource reservation function of the resource package, setting the upper limit, lower limit and change range of the virtual resource of the specified database to realize the service quality guarantee (QoS) of the business system database.

虚拟化功能接口模块:通过调用外部云计算虚拟化平台的虚拟机管理功能,提供虚拟机开启关闭、克隆、快照等功能接口。包括VMware、Xen和Hyper-V三种虚拟化接口。Virtualization function interface module: By calling the virtual machine management function of the external cloud computing virtualization platform, it provides functional interfaces such as virtual machine startup and shutdown, cloning, and snapshot. Including VMware, Xen and Hyper-V three virtualization interfaces.

例如,用户登录本系统,首先通过组织架构管理模块新建或选择已有组织,记录在组织结构表中。接下来用户通过虚拟资源调度模块,为该组织分配虚拟资源包,系统通过虚拟化功能接口模块和云计算平台通信,实现虚拟资源分配。然后用户通过模版管理模块新建数据库模版,系统需要调用虚拟化功能接口模块新建模版虚拟机,再调用对应的数据库接口模块在虚拟机中安装、配置数据库。For example, when a user logs in to the system, he first creates or selects an existing organization through the organization structure management module, and records it in the organization structure table. Next, the user allocates a virtual resource package for the organization through the virtual resource scheduling module, and the system communicates with the cloud computing platform through the virtualization function interface module to realize virtual resource allocation. Then the user creates a new database template through the template management module, and the system needs to call the virtualization function interface module to create a new template virtual machine, and then call the corresponding database interface module to install and configure the database in the virtual machine.

然后用户使用数据库部署模块,选择已建立的组织、数据库模版,在指定存储位置新建数据库,并可选自定义数据库配置参数。系统中数据库部署模块调用虚拟化功能接口克隆数据库模版,生成指定配置的虚拟机和数据库,并根据用户输入修改数据库参数。最后系统收集数据库UUID、用户名和密码,导出为数据库访问文件,供用户下载以便连接数据库。Then the user uses the database deployment module, selects the established organization and database template, creates a new database in the specified storage location, and can optionally customize the database configuration parameters. The database deployment module in the system calls the virtualization function interface to clone the database template, generates a virtual machine and database with a specified configuration, and modifies the database parameters according to user input. Finally, the system collects the database UUID, user name and password, and exports them as database access files for users to download to connect to the database.

通过实施本发明,可以得到以下有益效果:By implementing the present invention, the following beneficial effects can be obtained:

1、实现数据库的虚拟化,对用户来说,不用关心数据库的具体位置和部署过程。云平台管理员可以集中管理云平台中不同组织、不同类型的数据库。1. To realize the virtualization of the database, users do not need to care about the specific location and deployment process of the database. Cloud platform administrators can centrally manage databases of different organizations and types in the cloud platform.

2、集中管理数据库的生命周期和资源。根据预先配置的数据库模版、参数模版和组织架构,管理员可以方便快捷的管理云平台数据库的整个生命周期和自定义细节。2. Centrally manage the life cycle and resources of the database. According to the pre-configured database template, parameter template and organizational structure, administrators can easily and quickly manage the entire life cycle and custom details of the cloud platform database.

3、自动化的数据库更新和数据库服务提供方法,提升云平台数据库服务的提供效率,使得业务用户和云平台管理员对数据库技术细节不需深入了解。3. The automatic database update and database service provision method improves the efficiency of cloud platform database service provision, so that business users and cloud platform administrators do not need to have a deep understanding of database technical details.

本领域普通技术人员可以理解实现上述实施例的全部或部分步骤可以通过硬件来完成,也可以通过程序来指令相关的硬件完成,所述的程序可以存储于一种计算机可读存储介质中,上述提到的存储介质可以是只读存储器,磁盘或光盘等。Those of ordinary skill in the art can understand that all or part of the steps for implementing the above embodiments can be completed by hardware, and can also be completed by instructing related hardware through a program. The program can be stored in a computer-readable storage medium. The above-mentioned The storage medium mentioned may be a read-only memory, a magnetic disk or an optical disk, and the like.

本发明的描述是为了示例和描述起见而给出的,而并不是无遗漏的或者将本发明限于所公开的形式。很多修改和变化对于本领域的普通技术人员而言是显然的。选择和描述实施例是为了更好说明本发明的原理和实际应用,并且使本领域的普通技术人员能够理解本发明从而设计适于特定用途的带有各种修改的各种实施例。The description of the present invention has been presented for purposes of illustration and description, but is not intended to be exhaustive or limited to the invention in the form disclosed. Many modifications and changes will be apparent to those of ordinary skill in the art. The embodiment was chosen and described in order to better explain the principles of the invention and the practical application, and to enable others of ordinary skill in the art to understand the invention and design various embodiments with various modifications as are suited to the particular use.

Claims (8)

Translated fromChinese
1.一种数据库部署方法,其特征在于,包括:1. A database deployment method, characterized in that, comprising:当接收到数据库申请用户发送的新建数据库请求时,从新建数据库请求中提取出组织架构中的指定组织信息、以及数据库模板信息;When receiving the new database request sent by the database application user, extract the specified organization information and database template information in the organizational structure from the new database request;选择与组织架构中的指定组织相关联的资源包,以便为新建数据库分配相关资源;Select the resource package associated with the specified organization in the organizational structure to allocate relevant resources for the newly created database;在预先建立的与指定组织相关联的数据库模板库中,选择与数据库模板信息相对应的数据库模板;In the pre-established database template library associated with the specified organization, select a database template corresponding to the database template information;在资源包中设置数据库文件的存储空间和容量,以便利用选择的数据库模板新建数据库;Set the storage space and capacity of the database file in the resource package, so as to use the selected database template to create a new database;设置新建数据库的参数集;Set the parameter set for the new database;设置新建数据库的用户名和密码;Set the username and password for the new database;生成新建数据库访问文件和新建数据库通用唯一识别码;Generate a new database access file and a new database universal unique identification code;将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。Send the generated new database access file and the new database universal unique identification code to the database application user.2.根据权利要求1所述的方法,其特征在于,2. The method of claim 1, wherein,在建立与指定组织相关联的数据库模板库时,包括:When building a library of database templates associated with a given organization, include:在云平台中选择服务器集群以作为部署位置;Select a server cluster in the cloud platform as the deployment location;按需求建立组织架构;Establish organizational structure according to needs;建立与组织架构中的每个组织相关联的资源包;Create resource bundles associated with each organization in the organizational structure;建立与每个组织相关联的数据库模板库;Build a library of database templates associated with each organization;将建立的数据库模板库导入与相应组织相关联的资源包中。Import the established database template library into the resource package associated with the corresponding organization.3.根据权利要求2所述的方法,其特征在于,3. The method of claim 2, wherein,建立与每个组织相关联的数据库模板库的步骤包括:The steps to establish a library of database templates associated with each organization include:针对每个组织,在云平台中建立至少一个虚拟机;For each organization, establish at least one virtual machine in the cloud platform;在建立的虚拟机中安装需要的数据库;Install the required database in the established virtual machine;将安装数据库的虚拟机封装为数据库模板;Encapsulate the virtual machine where the database is installed as a database template;建立默认数据库配置参数集。Establishes a default set of database configuration parameters.4.根据权利要求2所述的方法,其特征在于,4. The method of claim 2, wherein,在云平台中选择服务器集群以作为部署位置的步骤包括:The steps for selecting a server cluster as a deployment location in the cloud platform include:判断在云平台中是否存在服务器集群;Determine whether there is a server cluster in the cloud platform;若在云平台中存在服务器集群,则在云平台中选择已经存在的服务器集群以作为部署位置;If there is a server cluster in the cloud platform, select an existing server cluster in the cloud platform as the deployment location;若在云平台中不存在服务器集群,则在云平台中新建服务器集群以作为部署位置。If there is no server cluster in the cloud platform, create a new server cluster in the cloud platform as the deployment location.5.一种数据库部署装置,其特征在于,包括接口单元、提取单元、资源包选择单元、模板选择单元、第一设置单元、第二设置单元、第三设置单元和信息生成单元,其中:5. A database deployment device, characterized in that it includes an interface unit, an extraction unit, a resource package selection unit, a template selection unit, a first setting unit, a second setting unit, a third setting unit and an information generation unit, wherein:接口单元,用于接收数据库申请用户发送的新建数据库请求;根据信息生成单元的指示,将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户;The interface unit is used to receive the new database request sent by the database application user; according to the instructions of the information generation unit, send the generated new database access file and the new database universal unique identification code to the database application user;提取单元,用于当接口单元接收到数据库申请用户发送的新建数据库请求时,从新建数据库请求中提取出组织架构中的指定组织信息、以及数据库模板信息;The extraction unit is used to extract the specified organization information and database template information in the organizational structure from the new database request when the interface unit receives the new database request sent by the database application user;资源包选择单元,用于选择与组织架构中的指定组织相关联的资源包,以便为新建数据库分配相关资源;A resource package selection unit, configured to select a resource package associated with a specified organization in the organizational structure, so as to allocate relevant resources for the newly created database;模板选择单元,用于在预先建立的与指定组织相关联的数据库模板库中,选择与数据库模板信息相对应的数据库模板;a template selection unit, configured to select a database template corresponding to database template information in a pre-established database template library associated with a specified organization;第一设置单元,用于在资源包中设置数据库文件的存储空间和容量,以便利用选择的数据库模板新建数据库;The first setting unit is used to set the storage space and capacity of the database file in the resource package, so as to use the selected database template to create a new database;第二设置单元,用于设置新建数据库的参数集;The second setting unit is used to set the parameter set of the new database;第三设置单元,用于设置新建数据库的用户名和密码;The third setting unit is used to set the user name and password of the newly created database;信息生成单元,用于生成新建数据库访问文件和新建数据库通用唯一识别码;指示接口单元将生成的新建数据库访问文件和新建数据库通用唯一识别码发送给数据库申请用户。The information generating unit is used to generate a new database access file and a new database universal unique identification code; instruct the interface unit to send the generated new database access file and new database universal unique identification code to the database application user.6.根据权利要求5所述的装置,其特征在于,还包括模板库建立单元,其中模板库建立单元包括集群选择模块、组织架构建立模块、资源包建立模块、模板库建立模块和模板库导入模块,其中:6. The device according to claim 5, further comprising a template library building unit, wherein the template library building unit includes a cluster selection module, an organizational structure building module, a resource package building module, a template library building module, and a template library import module, where:集群选择模块,用于在建立与指定组织相关联的数据库模板库时,在云平台中选择服务器集群以作为部署位置;The cluster selection module is used to select a server cluster in the cloud platform as a deployment location when establishing a database template library associated with a designated organization;组织架构建立模块,用于按需求建立组织架构;The organizational structure establishment module is used to establish the organizational structure according to the requirements;资源包建立模块,用于建立与组织架构中的每个组织相关联的资源包;A resource pack establishing module, configured to establish a resource pack associated with each organization in the organizational structure;模板库建立模块,用于建立与每个组织相关联的数据库模板库;A template library building module, used to create a database template library associated with each organization;模板库导入模块,用于将建立的数据库模板库导入与相应组织相关联的资源包中。The template library import module is used to import the established database template library into the resource package associated with the corresponding organization.7.根据权利要求6所述的装置,其特征在于,模板库建立模块包括虚拟机建立模块、安装模块、封装模块和参数集建立模块,其中:7. The device according to claim 6, wherein the template library building module includes a virtual machine building module, an installation module, an encapsulation module and a parameter set building module, wherein:虚拟机建立模块,用于针对每个组织,在云平台中建立至少一个虚拟机;The virtual machine establishment module is used for establishing at least one virtual machine in the cloud platform for each organization;安装模块,用于在建立的虚拟机中安装需要的数据库;The installation module is used to install the required database in the established virtual machine;封装模块,用于将安装数据库的虚拟机封装为数据库模板;The encapsulation module is used to encapsulate the virtual machine on which the database is installed as a database template;参数集建立模块,用于建立默认数据库配置参数集。The parameter set establishing module is used to establish a default database configuration parameter set.8.根据权利要求6所述的装置,其特征在于,集群选择模块包括识别模块和选择模块,其中:8. The device according to claim 6, wherein the cluster selection module includes an identification module and a selection module, wherein:识别模块,用于判断在云平台中是否存在服务器集群;An identification module, configured to determine whether there is a server cluster in the cloud platform;选择模块,用于根据识别模块的判断结果,若在云平台中存在服务器集群,则在云平台中选择已经存在的服务器集群以作为部署位置;若在云平台中不存在服务器集群,则在云平台中新建服务器集群以作为部署位置。The selection module is used to select an existing server cluster in the cloud platform as a deployment location if there is a server cluster in the cloud platform according to the judgment result of the identification module; if there is no server cluster in the cloud platform, then in the cloud platform Create a new server cluster in the platform as the deployment location.
CN201310671059.9A2013-12-112013-12-11Database portion arranging method and deviceActiveCN104717233B (en)

Priority Applications (1)

Application NumberPriority DateFiling DateTitle
CN201310671059.9ACN104717233B (en)2013-12-112013-12-11Database portion arranging method and device

Applications Claiming Priority (1)

Application NumberPriority DateFiling DateTitle
CN201310671059.9ACN104717233B (en)2013-12-112013-12-11Database portion arranging method and device

Publications (2)

Publication NumberPublication Date
CN104717233Atrue CN104717233A (en)2015-06-17
CN104717233B CN104717233B (en)2019-03-19

Family

ID=53416194

Family Applications (1)

Application NumberTitlePriority DateFiling Date
CN201310671059.9AActiveCN104717233B (en)2013-12-112013-12-11Database portion arranging method and device

Country Status (1)

CountryLink
CN (1)CN104717233B (en)

Cited By (14)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN106020857A (en)*2016-04-062016-10-12杭州沃趣科技股份有限公司Automatic disposition method used for Oracle Real Application Cluster database cluster
CN106844643A (en)*2017-01-132017-06-13王洋A kind of Database Dynamic generation method based on template engine
CN107247812A (en)*2017-07-252017-10-13郑州云海信息技术有限公司The generation method and generating means of a kind of database
CN107330682A (en)*2017-06-302017-11-07杭州创匠信息科技有限公司A kind of mobile payment deployment system and its method
CN107665141A (en)*2016-07-272018-02-06腾讯科技(深圳)有限公司A kind of configuration method for database and its equipment
CN107818104A (en)*2016-09-132018-03-20腾讯科技(深圳)有限公司A kind of database portion arranging method, database deployment device, control device and system
CN108920685A (en)*2018-07-122018-11-30郑州云海信息技术有限公司The management method and device of database in cloud data system
CN108959385A (en)*2018-05-312018-12-07康键信息技术(深圳)有限公司Database portion arranging method, device, computer equipment and storage medium
CN109522295A (en)*2018-11-162019-03-26中国银行股份有限公司A kind of database object constructs automatically, dispositions method and device
CN110781189A (en)*2019-10-252020-02-11北京达佳互联信息技术有限公司Document platform construction method and device, electronic equipment and storage medium
CN111581179A (en)*2019-02-192020-08-25上海云桓信息科技有限公司 A method and tool for data migration from Oracle to MySQL
CN112579143A (en)*2020-12-242021-03-30江苏杰瑞信息科技有限公司Management platform system for designing software information security
CN113076112A (en)*2021-04-072021-07-06网易(杭州)网络有限公司Database deployment method and device and electronic equipment
CN113778462A (en)*2021-09-142021-12-10中国电信集团系统集成有限责任公司Method for personalized configuration of operating system and intelligent integration platform

Citations (3)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN101477549A (en)*2009-01-202009-07-08中国测绘科学研究院Knowledge base supported spatial database design method
CN102880715A (en)*2012-10-092013-01-16南京市测绘勘察研究院有限公司Data pool management method and data pool management system on basis of cloud storage
US20130325890A1 (en)*2012-05-312013-12-05Ca, Inc.Leveraging persisted data queries in stream-based complex event processing

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN101477549A (en)*2009-01-202009-07-08中国测绘科学研究院Knowledge base supported spatial database design method
US20130325890A1 (en)*2012-05-312013-12-05Ca, Inc.Leveraging persisted data queries in stream-based complex event processing
CN102880715A (en)*2012-10-092013-01-16南京市测绘勘察研究院有限公司Data pool management method and data pool management system on basis of cloud storage

Cited By (21)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN106020857A (en)*2016-04-062016-10-12杭州沃趣科技股份有限公司Automatic disposition method used for Oracle Real Application Cluster database cluster
CN107665141B (en)*2016-07-272020-12-29腾讯科技(深圳)有限公司Database configuration method and equipment thereof
CN107665141A (en)*2016-07-272018-02-06腾讯科技(深圳)有限公司A kind of configuration method for database and its equipment
CN107818104B (en)*2016-09-132021-12-14腾讯科技(深圳)有限公司Database deployment method, database deployment device, control equipment and system
CN107818104A (en)*2016-09-132018-03-20腾讯科技(深圳)有限公司A kind of database portion arranging method, database deployment device, control device and system
CN106844643A (en)*2017-01-132017-06-13王洋A kind of Database Dynamic generation method based on template engine
CN107330682A (en)*2017-06-302017-11-07杭州创匠信息科技有限公司A kind of mobile payment deployment system and its method
CN107247812A (en)*2017-07-252017-10-13郑州云海信息技术有限公司The generation method and generating means of a kind of database
CN107247812B (en)*2017-07-252021-01-15苏州浪潮智能科技有限公司Database generation method and generation device
CN108959385A (en)*2018-05-312018-12-07康键信息技术(深圳)有限公司Database portion arranging method, device, computer equipment and storage medium
CN108959385B (en)*2018-05-312024-02-06康键信息技术(深圳)有限公司Database deployment method, device, computer equipment and storage medium
CN108920685A (en)*2018-07-122018-11-30郑州云海信息技术有限公司The management method and device of database in cloud data system
CN108920685B (en)*2018-07-122021-11-26郑州云海信息技术有限公司Management method and device for database in cloud data system
CN109522295B (en)*2018-11-162021-07-20中国银行股份有限公司Automatic database object constructing and deploying method and device
CN109522295A (en)*2018-11-162019-03-26中国银行股份有限公司A kind of database object constructs automatically, dispositions method and device
CN111581179A (en)*2019-02-192020-08-25上海云桓信息科技有限公司 A method and tool for data migration from Oracle to MySQL
CN110781189A (en)*2019-10-252020-02-11北京达佳互联信息技术有限公司Document platform construction method and device, electronic equipment and storage medium
CN110781189B (en)*2019-10-252022-08-26北京达佳互联信息技术有限公司Document platform construction method and device, electronic equipment and storage medium
CN112579143A (en)*2020-12-242021-03-30江苏杰瑞信息科技有限公司Management platform system for designing software information security
CN113076112A (en)*2021-04-072021-07-06网易(杭州)网络有限公司Database deployment method and device and electronic equipment
CN113778462A (en)*2021-09-142021-12-10中国电信集团系统集成有限责任公司Method for personalized configuration of operating system and intelligent integration platform

Also Published As

Publication numberPublication date
CN104717233B (en)2019-03-19

Similar Documents

PublicationPublication DateTitle
CN104717233A (en)Database deployment method and device
US11611487B2 (en)Model driven process for automated deployment of domain 2.0 virtualized services and applications on cloud infrastructure
CN108536519B (en)Method for automatically building Kubernetes main node and terminal equipment
EP3455728B1 (en)Orchestrator for a virtual network platform as a service (vnpaas)
US9843531B2 (en)Asynchronous framework for management of IaaS
US12107849B2 (en)Methods and systems for providing wake-on-demand access to session servers
US10601666B2 (en)Network functions virtualization management and orchestration policy descriptor management method and apparatus
CN102567075B (en)Virtual machine context setting method in cloud computing environment
JP2022550402A (en) Network resource management method, system, network equipment and readable storage medium
CN102110009A (en)Method for deploying application in virtual platform and virtual platform manager
WO2016015558A1 (en)Method and apparatus for applying for license
JP2020510384A (en) Network slice management method, unit, and system
CN104781783A (en)Integrated computing platform deployed in an existing computing environment
US11032178B2 (en)System and method for creating, deploying, and administering distinct virtual computer networks
JP7611817B2 (en) Method, device, storage medium and electronic device for allocating resources required for network functions
JP2017528855A (en) Hierarchical subscription management
CN111245634A (en)Virtualization management method and device
CN116113923A (en)Container cluster management method and system
CN112099913A (en)Method for realizing safety isolation of virtual machine based on OpenStack
KR101493828B1 (en)Method for virtual machine auto-configuration and method for providing virtual machine auto-configuration service
CN109660575B (en)Method and device for realizing NFV service deployment
US20250068435A1 (en)Method for managing the desired states of software-defined data centers
CN118035965B (en) Method and device for collaborative use of graphics processor computing power by multiple users
CN117950798A (en) A cluster management method and computing device
CN116795463A (en)Cloud desktop management system, deployment method and storage medium

Legal Events

DateCodeTitleDescription
C06Publication
PB01Publication
EXSBDecision made by sipo to initiate substantive examination
SE01Entry into force of request for substantive examination
GR01Patent grant
GR01Patent grant
EE01Entry into force of recordation of patent licensing contract
EE01Entry into force of recordation of patent licensing contract

Application publication date:20150617

Assignee:Tianyiyun Technology Co.,Ltd.

Assignor:CHINA TELECOM Corp.,Ltd.

Contract record no.:X2024990000675

Denomination of invention:Database deployment method and device

Granted publication date:20190319

License type:Common License

Record date:20241219


[8]ページ先頭

©2009-2025 Movatter.jp