Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for constructing mpp public cloud and local private cloud

A partial and automatic construction technology, applied in security communication devices, office automation, instruments, etc., can solve problems such as unfavorable database error troubleshooting and performance optimization, lack of system monitoring, and increased information error rate, so as to facilitate multi-level database management , The effect of simple deployment process

Active Publication Date: 2022-02-22
GUANGDONG ESHORE TECH
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of this solution is: the application of GP is complicated, and manual deployment through IP, port, user, user password and other information requires DBA to have strong experience in network, system, database, etc.; PG application is also relatively complicated and requires DBA Assistance again; in the whole process, the communication is through email, which is inefficient and the error rate of information is greatly increased; the lack of systematic monitoring is not conducive to database error troubleshooting and performance optimization
The disadvantages of this solution are: the entire process is communicated by email, which is inefficient, and the error rate of information is greatly increased; every time it is needed, the DBA still needs to log in to the server for remote batch operations; the monitoring is a messy script, which is not easy to view, and the log Still need DBA to extract

Method used

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for constructing mpp public cloud and local private cloud
  • Method and device for constructing mpp public cloud and local private cloud
  • Method and device for constructing mpp public cloud and local private cloud

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to illustrate the idea and purpose of the present invention, the present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0055] DBA, full name: Database Administrator, Chinese: database administrator, is a general term for the relevant staff engaged in the management and maintenance of the database management system (DBMS), belonging to a branch of operation and maintenance engineers, mainly responsible for business database design, testing, deployment and delivery full life cycle management.

[0056] GP, the full name of Greenplum, Greenplum's architecture uses MPP (massively parallel processing).

[0057] PG is PostgreSQL, which constitutes a GP cluster, where the PG database refers to a database created in the GP cluster.

[0058]MPP stands for Massively Parallel Processor. In a database non-shared cluster, each node has an independent disk storage system and memory system, and business da...

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

PUM

No PUM Login to View More

Abstract

The invention discloses a method and device for constructing an MPP public cloud and a local private cloud. The method includes the following steps: planning server resources, and writing them into a background database table; receiving a work order application, and obtaining role information of an application object; The role information checks whether the application object has the application authority; if the application object has the application authority, the corresponding GP cluster or PG database will be automatically built according to the work order application. This solution is based on Greenplum (referred to as GP), and does not need to specify IP, server resources and other information to deploy GP, and the deployment process is simple; for the application of PG database, there is no need to specify IP, port and other information, and the PG database can be automatically applied for, and at the same time through The multi-authority level tenant system builds public cloud databases and private clouds at the same time, which facilitates multi-level database management.

Description

technical field [0001] The invention relates to the field of server resource deployment, in particular to a method and device for constructing an MPP public cloud and a local private cloud. Background technique [0002] MPP is a massively parallel processing database cluster, which is built on the basis of GP. Simply put, GP is an object-oriented relational database like Oracle, DB2, and PG. In essence, it is a relational database cluster, a logical database composed of several independent database services. GP adopts the Shared-Nothing architecture. The entire cluster consists of multiple data nodes and control nodes. Each data node can run multiple databases independently of each other. The biggest feature of GP is that it can still support large-scale high-performance data warehouses and business intelligence queries without high-end hardware support. In the application of data warehouse and business intelligence, it can efficiently handle the process of I / O data throug...

Claims

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

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): H04L67/10H04L9/40H04L43/0817G06Q30/06G06Q10/10G06F11/30
CPCH04L67/10H04L63/102H04L63/105H04L43/0817G06F11/3034G06Q30/0645G06Q30/0609G06Q10/10G06F16/284
Inventor 刘亚光何广柏张伟刘海忠曾培植杨超
Owner GUANGDONG ESHORE TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com