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

MySQL database horizontal-sharding method, and MySQL connection establishment method and device

A technology of horizontal segmentation and connection establishment, applied in the field of MYSQL data storage, it can solve the problems of inability to re-segment the MYSQL database, large business impact, difficult data migration, etc., and achieve flexible segmentation and migration, good scalability and disaster prevention. sexual effect

Inactive Publication Date: 2013-09-25
UCWEB
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in this case, since the client segmentation rules are hard-coded, when re-segmenting the MYSQL database, all client segmentation rules need to be changed, making it almost impossible to re-segment the MYSQL database
[0007] In addition, regardless of the MYSQL proxy scheme with dispatch rules or the client dispatch scheme, data migration will be difficult
Moreover, during the migration process, the service of the entire database cluster needs to be stopped, which has a great impact on the business

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 database horizontal-sharding method, and MySQL connection establishment method and device
  • MySQL database horizontal-sharding method, and MySQL connection establishment method and device
  • MySQL database horizontal-sharding method, and MySQL connection establishment method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] Various aspects of the disclosure are described below. It should be appreciated that the teachings herein may be embodied in a wide variety of forms and that any specific structure, function, or both disclosed herein are merely representative. Based on the teachings herein one skilled in the art should appreciate that an aspect disclosed herein may be implemented independently of any other aspects and that two or more of these aspects may be combined in various ways. For example, an apparatus may be implemented or a method practiced using any number of the aspects set forth herein. In addition, such an apparatus may be implemented or such a method may be practiced with other structure, functionality, or structure and functionality in addition to or in addition to one or more of the aspects set forth herein. Additionally, any aspect described herein may comprise at least one element of a claim.

[0042] Various embodiments of the present invention will be described bel...

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 provides a MySQL database horizontal-sharding method. The method includes: distributing a data ID range (Min(n), Max(n)) for a database in a database cluster according to a preset data ID range distribution strategy; and storing MySQL data to each database with the data ID range including data IDs according to the data IDS of the MySQL data. The letter N is a total of the databases in the database cluster, the Min(n) is a minimum boundary value of the data ID range of the n-th database, and the Max(n) is a maximum boundary value of the data ID range of the n-th database. Through the method, the MySQL databases can be sharded and transferred flexibly and extensibility is improved.

Description

technical field [0001] The invention relates to the field of MYSQL data storage, and more specifically, to a MYSQL database horizontal switching method, a MYSQL connection establishment method and a device. [0002] Background technique [0003] As the data stored in MYSQL becomes larger and larger, one MYSQL database cannot store all the data, so the data will inevitably be stored in several MYSQL databases, which requires database sharding. [0004] Database segmentation methods mainly include two types: vertical segmentation and horizontal segmentation. Straight splitting refers to splitting different columns in the database and storing them in different MYSQL databases. Horizontal splitting refers to splitting different rows in the database and storing them in different databases. Since vertical splitting does not have good scalability, horizontal splitting is usually used when splitting MYSQL databases. [0005] At present, the representative open source horizontal ...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 梁捷王尧佳
Owner UCWEB
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