mysql集群搭建 pdf_MySQL数据库集群方案.pdf

Three steps to clustering

——MNC、MGC与MIC

周彦伟

2017.5

关于我

Renren DB Team (2009-2013)

Qunar DB Team (2013-2017)

All China MySQL User Group (ACMUG)

《MySQL运维内参》 (公众号：formysql)

Oracle MySQL ACE Director

MySQL Clustering

MNC

MySQL NDB Cluster

MGC

MySQL Galera Cluster

Percona XtraDB Cluster

MariaDB Cluster

MIC

MySQL InnoDB Cluster

MySQL NDB Cluster(MNC)

Network DataBase

In-Memory

Shared-Nothing

Auto-Sharding

High-Availability

Data-Persisnce

Read/Write consistency/scalability

MNC Components

SQL Nodes—MySQL Servers

SQL Access to data

Round-robin app access

Geographic Replication

Scale out for performance

MNC Components

Data Nodes—Ndbd Servers

Data storage & management

Transparent sharding

Synchronous replication

Scale out for capacity/performance

MNC Components

Management servers

Distribute configuration data

Control Cluster membership

Arbitrator in case of network partitioning

NDB API — NoSQL

Node Groups、Replicas、Partitions

Management of MNC

MySQL Cluster Auto-installer

Client Program

ndb_mgm

Rolling Restart

ndbinfo—NDB Cluster Infomation

Problems of MNC

Cluster size

Network dependence

Complex SQL Optimazition

Management & Cost

Limitations of NDB Cluster

昨夜西风凋

碧树，独上

高楼，望断

天涯路！

MySQL Galera Cluster (MGC)

True Multi-Master Cluster

Read and Write to any cluster node

Synchronous Replication

True Parallel Replication

Auto Management

MySQL Galera Cluster (MGC)

Certification-Based Replication

Transactional Database

Atomic Changes

Global Ordering