Tuesday Oct 02, 2012

Slides of my HOL on MySQL Cluster


Thanks everyone who attended my hands-on lab on MySQL Cluster at MySQL Connect last Saturday.

The following are the links for the slides, the HOL instructions, and the code examples.

I'll try to summarize my HOL below.

Aim of the HOL was to help attendees to familiarize with MySQL Cluster. In particular, by learning:
  1. the basics of MySQL Cluster Architecture
  2. the basics of MySQL Cluster Configuration and Administration
  3. how to start a new Cluster for evaluation purposes and how to connect to it

We 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-nothing Architecture, 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
  • 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 higly impacts development of application (in MySQL Cluster the sharding is automatic and transparent to the application)
  • there are real time 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 from eDelivery for evaluation purposes)

MySQL Carrier Grade Edition adds on the top of the Community Edition:

  • Commercial Extensions (MySQL Cluster Manager, MySQL Enterprise Monitor, MySQL Cluster Installer)
  • Oracle's Premium Support Services (largest team of MySQL experts backed by MySQL developers, forward compatible hot fixes, multi-language support, and more)

We concluded talking about the MySQL Cluster vision:

MySQL Cluster is the default database for anyone deploying rapidly evolving, realtime transactional services at web-scale, where downtime is simply not an option.

From a practical point of view the HOL's steps were:

  • MySQL Cluster installation
  • start & monitoring of the MySQL Cluster processes
  • client connection to the Management Server and to an SQL Node
  • connection using the NoSQL NDB API and the Connector J

In the hope that this blog post can help you get started with MySQL Cluster, I take the opportunity to thank you for the questions you made both during the HOL and at the MySQL Cluster booth.

Slides are also on SlideShares:

Happy Clustering!

Thursday Sep 27, 2012

Getting Started with MySQL Cluster, Hands-on Lab, Next Saturday, MySQL Connect


I'm speaking at MySQL Connect next Saturday, Sep. 29. My Session is a hands-on lab (HOL) on MySQL Cluster.

If you are interested in familiarize a bit with MySQL Cluster this is definitely a session for you.

I will start by briefly introducing MySQL Cluster and its architecture. Then I will guide you through the needed steps to install a local MySQL Cluster, connect to it (using the command line), monitor its logs, and safe shutdown it.

We will hence have a chance to see which are the most common commands using in MySQL Cluster administration (e.g. Cluster backup) as well as the most common operations (e.g. online datanode add).

Cluster's users and customers have the flexibility to choose whether they prefer to use a SQL or NoSQL approach to connect to MySQL Cluster, so, during the last part of the HOL, we will see how to connect to MySQL Cluster using the NoSQL NDB API.

If there is enough time at the end, we will also compile and execute some simple Java programs that make use of Connector J to connect to the SQL Nodes of our Cluster.

I hope this HOL will be of your interest! Below are some details if you decide to attend:

When:   Saturday Sep. 29, 4 pm
Where: Hilton San Francisco - Plaza Room A

If you are interested in other MySQL Cluster sessions, you will find the info you need in this post.

The full program of the MySQL Connect Conference is here, and if you are not registered yet, remember that you can still save US $300 over the on-site fee – Register Now!

See you at MySQL Connect!

My name is Santo Leto. I work in the Support Team of MySQL at Oracle and I am a member of the Oracle Global Support's Compliance Management Forum. I'm based in Italy.


« December 2016