Hi!Thanks everyone who attended the hands-on lab session on MySQL Cluster at Oracle OpenWorld today.
The following are the links for the slides , the HOL instructions , and the HOL extra instructions .
Will try to summarize the HOL session below.Aim of the HOL was to help attendees to familiarize with MySQL Cluster.
In particular, by:Learning the basics of MySQL Cluster Architecture Learning the basics of MySQL Cluster Configuration and Administration Learning how to start a new Cluster for evaluation purposes and how to connect to it
Started by introducing MySQL Cluster.
MySQL Cluster is a proven technology that today is successfully servicing the most performance-intensive workloads. MySQL Cluster is deployed across telecom networks and is powering mission-critical web applications.
Without trading off use of commodity hardware, transactional consistency and use of complex queries, MySQL Cluster provides:Web Scalability(web-scale performance on both reads and writes) Carrier Grade Availability(99.999%) Developer Agility(freedom to use SQL or NoSQL access methods)
MySQL Cluster implements:An Auto-Sharding, Multi-Master, Shared-nothingArchitecture, where independent nodes can scale horizontally on commodity hardware with no shared disks, no shared memory, no single point of failure
In the architecture of MySQL Cluster it is possible to find three types of nodes:Management nodes: responsible for reading the configuration files, maintaining logs, and providing an interface to the administration of the entire cluster Data nodes: where data and indexes are stored SQL/API nodes: provide the external connectivity (e.g. the NDB engine of the MySQL Server, APIs, Connectors)
MySQL Cluster is recommended in the situations where:It is crucial to reduce service downtime, because this produces a heavy impact on business Sharding the database to scale write performance highly impacts development of application (in MySQL Cluster the sharding is automatic and transparent to the application) There are real-time responses needs There are unpredictable scalability demands It is important to have data-access flexibility (SQL & NoSQL)
MySQL Cluster is available in two Editions:Community Edition(Open Source, freely downloadable from mysql.com) Carrier Grade Edition(Commercial Edition, can be downloaded fromeDelivery)
MySQL Carrier Grade Edition adds on the top of the Community Edition:Commercial Extensions(MySQL Cluster Manager, MySQL Enterprise Monitor, MySQL Cluster Auto-Installer) Oracle's Premium Support Services(largest team of MySQL experts backed by MySQL developers, forward compatible hotfixes, multi-language support, and more)
From a practical point of view the HOL's steps were:Installation of MySQL Cluster Start & Monitoring of MySQL Cluster Connecting to MySQL Cluster Overview of MySQL Cluster’s Admin Commands & Operations
Even though not possible to do a couple of extra practices, these include:Backup & Restore of MySQL Cluster MySQL Cluster online reconfiguration
In the hope that this blog post can help you get started with MySQL Cluster, take the opportunity to thank you for the questions you made during the HOL session.