Got it

GaussDB 200 MPP vs MySql

Created: Sep 27, 2019 14:50:35Latest reply: Mar 15, 2022 06:50:07 1703 3 0 0 0
  Rewarded HiCoins: 0 (problem resolved)

Hello!
Does mpp support partitioned tables, what are the advantages of mpp and mysql? MPP load balancing is introduced.

Thank you!

  • x
  • convention:

Featured Answers
songminwang
Created Sep 27, 2019 14:53:11

Hello!

Mpp is a supported partition table for specific reference product documentation


Mpp actually has a vague concept of table space because Mpp is a distributed database, unlike mysql, which has a strong concept of table space.

GaussDB 200 is an enterprise-level relational database for large-scale parallel processing. GaussDB 200 adopts the massively parallel processing (MPP) architecture, supports both row-based and column-based storage, and provides processing capabilities of PB-level (two to the fiftieth power) data.

GaussDB 200 has many core technology advantages over conventional databases. It can solve issues concerning data processing performance for users in many industries, provide a general cost-effective computing platform for large-scale data management, and support various data warehouse systems, business intelligence (BI) systems, and decision-making support systems, to support decision analysis of upper-layer applications in a unified manner.

Mysql tends to data storage, Mysql is a relational database


What Is LVS

LVS+Keepalived comprise an open source software solution for load balancing.

The following figure shows the typical network model for load balancing in a cluster.

I hope help you!

View more
  • x
  • convention:

Laiheang
Laiheang Created Mar 15, 2022 06:50:02 (0) (0)
well  
All Answers
songminwang
songminwang Created Sep 27, 2019 14:53:11

Hello!

Mpp is a supported partition table for specific reference product documentation


Mpp actually has a vague concept of table space because Mpp is a distributed database, unlike mysql, which has a strong concept of table space.

GaussDB 200 is an enterprise-level relational database for large-scale parallel processing. GaussDB 200 adopts the massively parallel processing (MPP) architecture, supports both row-based and column-based storage, and provides processing capabilities of PB-level (two to the fiftieth power) data.

GaussDB 200 has many core technology advantages over conventional databases. It can solve issues concerning data processing performance for users in many industries, provide a general cost-effective computing platform for large-scale data management, and support various data warehouse systems, business intelligence (BI) systems, and decision-making support systems, to support decision analysis of upper-layer applications in a unified manner.

Mysql tends to data storage, Mysql is a relational database


What Is LVS

LVS+Keepalived comprise an open source software solution for load balancing.

The following figure shows the typical network model for load balancing in a cluster.

I hope help you!

View more
  • x
  • convention:

Laiheang
Laiheang Created Mar 15, 2022 06:50:02 (0) (0)
well  
Laiheang
Laiheang Created Mar 15, 2022 06:50:07

cool
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.