Supercharge Your Innovation With Domain-Expert AI Agents!

MYSQL (my structured query language)-based database cloud and construction method for same

A database and user data technology, applied in the database field, can solve the problems that the IO performance of the database system cannot meet the requirements, achieve the effect of ensuring business continuity and business performance, realizing load balancing or separation of reading and writing, and enhancing security

Inactive Publication Date: 2013-12-25
CEC CYBERSPACE GREAT WALL
View PDF4 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The present invention aims at the problem that in the prior art, deploying a database in a physical server leads to difficulties in migrating and responding to a variety of different business requirements, and the IO performance of the database system deployed on a simple virtual machine cannot meet the requirements, and provides a database cloud based on MYSQL, which can realize database Rapid deployment of hot migration, and provide high IO performance, and can also meet the diverse needs of some businesses on the database

Method used

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • MYSQL (my structured query language)-based database cloud and construction method for same
  • MYSQL (my structured query language)-based database cloud and construction method for same
  • MYSQL (my structured query language)-based database cloud and construction method for same

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The present invention will be described below in conjunction with the accompanying drawings.

[0025] The present invention relates to a kind of database cloud based on MYSQL, its structure is as follows figure 1 As shown, including the MYSQL databases deployed on the virtual machines of the two host machines in the cloud computing environment and the high-performance storage devices installed outside the host machines, the two MYSQL databases are connected to the high-performance storage through the network communication interface 1 established by BONDING technology. The devices are connected, and the MYSQL database receives the user's database request and stores the user data in a high-performance storage device installed outside the host machine. The MYSQL database performs heartbeat detection and the two MYSQL databases are synchronized in real time.

[0026] According to the diverse needs of different enterprises, the MYSQL-based database cloud can be as follows: ...

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

PUM

No PUM Login to View More

Abstract

The invention relates to a MYSQL (my structured query language)-based database cloud and a construction method for the same. The database cloud comprises MYSQL databases and high-performance storage equipment, wherein the MYSQL databases are deployed on virtual machines of two host computers in a cloud computing environment respectively; the high-performance storage equipment is arranged outside the host computers; the two MYSQL databases are both connected with the high-performance storage equipment through network communication interfaces established by a BONDING technology, are used for storing user data in the high-performance storage equipment outside the host computers after receiving database requests of a user, and performing heartbeat detection, and are synchronized in real time. According to the database cloud, the live migration rapid-deployment of the databases can be realized, high IO (input / output) performance is ensured, and the diversified requirements of a part of services of an enterprise on the databases can also be met.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a MYSQL-based database cloud and its establishment method. Background technique [0002] Enterprises have various requirements for databases, especially for completely resource-isolated database products with different configurations, different capacities, and different functions. Currently, deploying single-configuration database products is difficult to meet the diverse needs of enterprises. The database products on the market are basically deployed in physical servers, which makes it difficult to migrate, back up and respond to various business needs; if the database is directly deployed on the virtual machine in the cloud computing environment, a simple database system will be formed The IO performance cannot meet the demand, and the security performance of data resources is relatively poor. Contents of the invention [0003] The present invention aims at the problem tha...

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
IPC IPC(8): G06F17/30H04L29/08
Inventor 王贵宗马洪军
Owner CEC CYBERSPACE GREAT WALL
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More