Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL (NDB) Cluster Best Practices (Die Hard VIII)

MySQL (NDB) Cluster Best Practices (Die Hard VIII)

 26 April - 3:30 PM - 4:20 PM @ Room 210
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Topics:
MySQL
High Availability
Sharding

Description

MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. It provides shared-nothing clustering and auto-sharding for MySQL, accessed via SQL and NoSQL interfaces. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability. MySQL Cluster is implemented through the NDB or NDBCLUSTER storage engine for MySQL. In this session we will talk about - Core architecture and Design principles of NDB Cluster - APIs for data access (SQL and NoSQL interfaces) - Important configuration parameters - Best practices: indexing and schema We will also compare performance between MySQL Cluster 7.5 and Galera (MySQL 5.6/5.7), and how to best make use of the feature set of MySQL Cluster 7.5.

Speakers

Johan Andersson's picture

Johan Andersson

CTO, Severalnines

Biography:

Johan is CTO at Severalnines, a company that enables developers to easily deploy, manage, monitor and scale highly-available MySQL clusters in the data center, in hosted environments and on the cloud. Prior to Severalnines, Johan worked at MySQL/Sun/Oracle and was the Principal Consultant and lead of the MySQL Clustering and High Availability consulting group, where he designed and implemented large-scale MySQL systems at key customers.

Share this talk