MySQL User Camp: MySQL Cluster

•

6 likes•1,634 views

Priyanka, a MySQL cluster developer, presented MySQL cluster in the MySQL User camp. The slide deck contains an introduction to the cluster module- the architecture, auto-sharding, failover etc in the cluster module.

MySQL Cluster
Priyanka Sangam
(priyanka.sangam@oracle.com)
Insert Picture Here

Safe Harbour Statement
The following is intended to outline our
general product direction. It is intended for
information purposes only, and may not be
incorporated into any contract.
It is not a commitment to deliver any
material, code, or functionality, and should
not be relied upon in making purchasing
decisions. The development, release, and
timing of any features or functionality
described for Oracle’s products remains at
the sole discretion of Oracle.

Agenda
• Introduction to MySQL Cluster
• Working with Cluster tables
• Cluster Nodes
• Architecture
• Auto-sharding
• Failover

Introduction to MySQL Cluster
• Distributed transactional database
• In-memory storage
• Auto-sharding
• Shared-nothing architecture
• Automatic failover and recovery
• Runs on commodity hardware
• SQL + NoSQL interfaces

mysql> create table t1(id int primary key, value varchar(10))engine=ndb;
Query OK, 0 rows affected (0.80 sec)
mysql> show create table t1;
+++
| Table | Create Table                              |
+++
| t1    | CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `value` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1          |
+++
1 row in set (0.00 sec)
mysql> insert into t1 values(1, "one"), (2,"two");
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0
mysql> select * from t1;
+++
| id | value |
+++
|  1 | one   |
|  2 | two   |
+++
2 rows in set (0.00 sec)
Working with Cluster Tables

Cluster Nodes
•Data Nodes
•Store cluster data
•Data partitioned + replicated across many data nodes
•ndbd (single-threaded) or ndbmtd (multi-threaded)
•SQL Nodes
•Access cluster data by querying data nodes
•SQL + NoSQL
•mysqld
•Management Nodes
•Manage other nodes
•Config, startup, shutdown, backup etc.
•ndb_mgmd

ndb_mgm
mysql@host1:~$ ndb_mgm e show
Connected to Management Server at: localhost:1186
Cluster Configuration

[ndbd(NDB)]     2 node(s)
id=2    @127.0.0.1  (mysql5.5.36 ndb7.2.16, Nodegroup: 0, *)
id=4    @127.0.0.1  (mysql5.5.36 ndb7.2.16, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1    @127.0.0.1  (mysql5.5.36 ndb7.2.16)
[mysqld(API)]   4 node(s)
id=3    @127.0.0.1  (mysql5.5.36 ndb7.2.16)
id=5 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)

Failover
• << Initial state >>
• Node1: Primary F1, Secondary F2, Nodegroup 0
• Node2: Primary F2, Secondary F1, Nodegroup 0
• Node3: Primary F3, Secondary F4, Nodegroup 1
• Node4: Primary F4, Secondary F3, Nodegroup 1
• << Node1 fails >>
• Node2: Primary F1, Primary F2
• Node3: Primary F3, Secondary F4, Nodegroup 1
• Node4: Primary F4, Secondary F3, Nodegroup 1
• << Node2 fails >>
• Cluster failure due to missing nodegroup
• Node3. Node4 shut down

References
• Introduction to MySQL Cluster:
http://www.slideshare.net/andrewjamesmo
rgan/mysql-cluster-introduction
• Cluster Reference Manual:
http://dev.mysql.com/doc/mysql-cluster-ex
cerpt/5.1/en/index.html

What's hot

MySQL Performance Best Practices

Olivier DASINI

MySQL Performance Best Practices document discusses various techniques for optimizing MySQL performance. It covers monitoring performance with tools like MySQL Enterprise Monitor, optimizing configurations such as increasing the InnoDB buffer pool size, balancing data consistency versus performance by adjusting the innodb_flush_log_at_trx_commit setting, and summarizes that monitoring is essential to identify performance issues and test configuration changes before deploying to production.

NoSQL and MySQL: News about JSON

Mario Beck

NoSQL & SQL - Best of both worlds - BarCamp Berkshire 2013

Andrew Morgan

The document discusses blending NoSQL and SQL databases by leveraging the strengths of both. It describes how MySQL Cluster provides massively scalable performance through its NoSQL-style data storage and replication abilities, while also supporting SQL queries, joins, and ACID transactions like a traditional relational database. This allows applications to use NoSQL for simple operations and scalability while still using SQL for complex queries and transactions as needed.

MySQL for Software-as-a-Service (SaaS)

Mario Beck

The Software as a Service or SaaS market is large and growing. Demands of 24/7 availability, high performance, back-up, security, affordability, scalability, manageability, audit ability and easy integration when delivering your product and or service to your customers, are business challenges which we will address in this presentation. By demonstrating MySQL’s proven ability in this area, we will show how we can help new and seasoned SaaS vendors.

MySQL Day Paris 2016 - State Of The Dolphin

Olivier DASINI

MySQL Cluster Scaling to a Billion Queries

Bernd Ocklin

MySQL Cluster is a distributed database that provides extreme scalability, high availability, and real-time performance. It uses an auto-sharding and auto-replicating architecture to distribute data across multiple low-cost servers. Key benefits include scaling reads and writes, 99.999% availability through its shared-nothing design with no single point of failure, and real-time responsiveness. It supports both SQL and NoSQL interfaces to enable complex queries as well as high-performance key-value access.

MySQL Cluster

Abel Flórez

The document provides an overview of MySQL Cluster, including its history, architecture, components, and data partitioning. MySQL Cluster was originally developed by Ericsson in the late 1990s to provide highly reliable, real-time performance for telecommunications databases. It has since been acquired and maintained by Oracle. MySQL Cluster uses multiple data nodes to store and replicate data fragments across the cluster, providing high availability and linear scalability.

What's new in MySQL Cluster 7.4 webinar charts

Andrew Morgan

MySQL Cluster powers the subscriber databases of major communication services providers as well as next generation web, cloud, social and mobile applications. It is designed to deliver: - Real-time, in-memory performance for both OLTP and analytics workloads - Linear scale-out for both reads and writes 99.999% High Availability - Transparent, cross-shard transactions and joins - Update-Anywhere Geographic replication - SQL or native NoSQL APIs All that while still providing full ACID transactions.

20141011 my sql clusterv01pptx

Ivan Ma

This document provides an overview and summary of MySQL Cluster. It discusses how MySQL Cluster provides high availability, scalability and performance through features like auto-sharding, multi-master replication, ACID compliance, and built-in high availability. It also provides examples showing how MySQL Cluster can scale to handle over 1 billion updates per minute and discusses how operations like restarts have been improved in MySQL Cluster 7.4.1.

MySQL cluster 7.4

Mark Swarbrick

MySQL Enterprise Edition

MySQL Brasil

The document provides an overview of Oracle's MySQL product direction and strategy. It outlines Oracle's continued investment in MySQL through rapid innovation, improved support offerings, and making MySQL more reliable and scalable. New product releases and upcoming features are highlighted. Case studies showcase how major companies rely on MySQL for critical applications. Performance benchmarks demonstrate significant gains in MySQL 5.5. Key capabilities such as high availability, security, and scalability features in MySQL Enterprise Edition are summarized.

Oracle MySQL Tutorial -- MySQL NoSQL Cloud Buenos Aires Nov, 13 2014

Manuel Contreras

MySQL InnoDB Cluster - A complete High Availability solution for MySQL

Olivier DASINI

MySQL InnoDB Cluster provides a complete high availability solution for MySQL. It uses MySQL Group Replication, which allows for multiple read-write replicas of a database to exist with synchronous replication. MySQL InnoDB Cluster also includes MySQL Shell for setup, management and orchestration of the cluster, and MySQL Router for intelligent connection routing. It allows databases to scale out writes across replicas in a fault-tolerant and self-healing manner.

MySQL 5.7 Replication News

Ted Wennmark

The document discusses new features in MySQL 5.7 related to replication. It covers improvements to usability through online reconfiguration of global transaction IDs and replication filters. It also describes enhanced replication monitoring using performance schema tables and improved applier performance through locking-based parallelism. The agenda includes sections on replication features in 5.7, news from development, and future plans.

MySQL Manchester TT - 5.7 Whats new

Mark Swarbrick

The document discusses performance improvements and new features in MySQL 5.7. Key points include: - MySQL 5.7 shows significant performance gains over previous versions, with benchmarks showing 3x faster query performance and 82% faster connection throughput. - New features include enhanced replication, a new optimizer cost model, performance schema improvements, and native JSON support. - The optimizer and parser were refactored for improved maintainability, readability and stability. A new cost-based optimizer model provides better performance and tunability.

2015: Whats New in MySQL 5.7, At Oracle Open World, November 3rd, 2015

Geir Høydalsvik

MySQL 5.7 includes many new features and improvements such as faster performance, easier configuration and management, and enhanced security. It provides benefits like increased speed for queries, replication, and data compression as well as new capabilities for JSON data, spatial indexing, and instrumentation. Oracle presented benchmarks showing MySQL 5.7 is up to 6 times faster than previous versions.

MySQL Document Store for Modern Applications

Olivier DASINI

Case Study: MySQL migration from latin1 to UTF-8

Olivier DASINI

This document summarizes Olivier Dasini's presentation on migrating a MySQL database from the latin1 character set to UTF-8. Some key points: - The migration involved converting database tables, columns, and data to the UTF-8 character set and UTF-8 collations to support non-Latin characters from around the world. - Challenges included minimizing downtime to avoid loss of income, dealing with legacy data issues, and handling errors due to differences between character sets. - The solution involved a rolling upgrade approach, with slaves being migrated first to test the process before a master-slave switchover. - Significant effort was required to clean legacy data issues and handle errors manually

Mysql Enterprise Edition Feature and Tools

jones4u

The document summarizes the features and capabilities of MySQL Enterprise Edition, which includes advanced features, management tools, and technical support to achieve high levels of scalability, security, reliability, and uptime for MySQL databases. It provides concise overviews of the various MySQL Enterprise Edition components and tools like the MySQL Database, MySQL Enterprise Monitor, MySQL Workbench, and Oracle Premier Support.

Moodle Moot Spain: Moodle Available and Scalable with MySQL HA - InnoDB Clust...

Keith Hollman

This document provides an overview of MySQL high availability and replication solutions. It discusses InnoDB Cluster, which allows MySQL to provide high availability and scaling features through MySQL Group Replication, MySQL Shell, and MySQL Router. It also covers MySQL InnoDB ReplicaSet, which provides an easy way to set up MySQL replication with MySQL Router. Additionally, it provides background information on MySQL replication, how it works, and its key components.

What's hot (20)

MySQL Performance Best Practices

NoSQL and MySQL: News about JSON

NoSQL & SQL - Best of both worlds - BarCamp Berkshire 2013

MySQL for Software-as-a-Service (SaaS)

MySQL Day Paris 2016 - State Of The Dolphin

MySQL Cluster Scaling to a Billion Queries

MySQL Cluster

What's new in MySQL Cluster 7.4 webinar charts

20141011 my sql clusterv01pptx

MySQL cluster 7.4

MySQL Enterprise Edition

Oracle MySQL Tutorial -- MySQL NoSQL Cloud Buenos Aires Nov, 13 2014

MySQL InnoDB Cluster - A complete High Availability solution for MySQL

MySQL 5.7 Replication News

MySQL Manchester TT - 5.7 Whats new

2015: Whats New in MySQL 5.7, At Oracle Open World, November 3rd, 2015

MySQL Document Store for Modern Applications

Case Study: MySQL migration from latin1 to UTF-8

Mysql Enterprise Edition Feature and Tools

Moodle Moot Spain: Moodle Available and Scalable with MySQL HA - InnoDB Clust...

Viewers also liked

MySQL Troubleshooting with the Performance Schema

Sveta Smirnova

This document discusses using the Performance Schema in MySQL to troubleshoot performance issues. It provides an overview of the Performance Schema and what information it collects. It then discusses how to use specific Performance Schema tables like events_statements_history_long, events_stages_history_long, and others to identify statements that examine too many rows, issues with index usage, and which internal operations are taking a long time. The document provides examples of queries to run and what to look for in the Performance Schema output to help troubleshoot and optimize SQL statements.

Performance Schema in MySQL (Danil Zburivsky)

Ontico

The document discusses the Performance Schema feature in MySQL 5.5, which instruments and collects data about internal operations to help identify performance bottlenecks. It is implemented as a storage engine that collects data about events like query execution steps, locks, I/O, and threads into tables that provide visibility into where the server spends its time. This helps address the lack of good instrumentation previously available in MySQL for performance tuning.

The MySQL Performance Schema & New SYS Schema

Ted Wennmark

MySQL Performance - SydPHP October 2011

Graham Weldon

MySQL Tech Tour 2015 - Progettare, installare e configurare MySQL Cluster

Par-Tec S.p.A.

Il TechAdvisor Mirko Conte spiega come progettare, installare e configurare MySQL Cluster, la versione di punta del database open source più utilizzato al mondo. Durante la presentazione, Mirko ha condiviso numerose informazioni teoriche e pratiche per comprendere dove, come e quando utilizzare al meglio MySQL Cluster. In questa sessione ha trattato i seguenti punti: - Valutare MySQL Cluster nel proprio progetto - Esempi di architettura - Requisiti hardware/network - Sessione hands-on Per saperne di più, scaricate le slide e guardate il video della presentazione del nostro TechAdvisor su http://www.par-tec.it/progettare-installare-gestire-e-ottimizzare-mysql-cluster#progettare

MySQL user camp march 11th 2016

Venkatesh Duggirala

The document provides an overview of new replication features in MySQL 5.7, including: 1. Online reconfiguration of global transaction identifiers and replication filters which allow changing replication settings without restarting servers or interrupting reads/writes. 2. Online reconfiguration of replication receivers and appliers which enables changing the replication topology during failover without stopping applier threads. 3. Improved replication monitoring through new performance schema tables that provide more accurate and extensive monitoring of replication components.

MySQL Oslayer performace optimization

Louis liu

This document provides 10 tips for optimizing MySQL database performance at the operating system level. The tips include using SSDs instead of HDDs for faster I/O, allocating large amounts of memory, avoiding swap space, keeping the MySQL version up to date, using file systems without barriers, configuring RAID cards for write-back caching, and leveraging huge pages. Overall, the tips aim to improve I/O speeds and memory usage to enhance MySQL query processing performance.

An Overview to MySQL SYS Schema

Mydbops

MySQL Developer Day conference: MySQL Replication and Scalability

MySQL User Camp: MySQL Cluster

More Related Content

What's hot

What's hot (20)

Viewers also liked

Viewers also liked (20)

Similar to MySQL User Camp: MySQL Cluster

Similar to MySQL User Camp: MySQL Cluster (20)

More from Shivji Kumar Jha

More from Shivji Kumar Jha (17)

Recently uploaded

Recently uploaded (20)

MySQL User Camp: MySQL Cluster