Andrew Morgan’s MySQL Cluster Database Blog
MySQL Cluster database & MySQL Replication
Information on MySQL Cluster and MySQL Replication
Publicising announcements and other information that has been released by MySQL/Oracle as well as other useful information connected with using MySQL Cluster or replication.
-
MySQL Cluster 7.1 Cheat Sheet
The latest GA release is MySQL Cluster 7.1. All of the functionality available in MySQL Cluster 7.0 is still there in 7.1 and all tasks can be performed in the same way. In addition, MySQL Cluster 7.1 introduces the following:
- ndbinfo is a read-only database presenting information on what is happening within the cluster – in particular, within the data nodes. This database contains a number of views, each providing data about MySQL Cluster node status, resource usage and operations. The use of ndbinfo is described in the “MySQL Cluster 7.0 & 7.1: Architecture and New Features” white paper – available from http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster7_architecture.php
- MySQL Cluster Manager provides the ability to control the entire cluster as a single entity, while also supporting very granular control down to individual processes within the cluster itself. Administrators are able to create and delete entire clusters, and to start, stop and restart the cluster with a single command. As a result, administrators no longer need to manually restart each data node in turn, in the correct sequence, or to create custom scripts to automate the process.
MySQL Cluster Manager automates on-line management operations, including the upgrade, downgrade and reconfiguration of running clusters, without interrupting applications or clients accessing the database. Administrators no longer need to manually edit configuration files and distribute them to other cluster nodes, or to determine if rolling restarts are required. MySQL Cluster Manager handles all of these tasks, thereby enforcing best practices and making on-line operations significantly simpler, faster and less error-prone.
The use of MySQL Cluster Manager is described in detail in the “MySQL Cluster Manager” white paper (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_manager.php ) and there is a demonstration video available at http://www.mysql.com/products/database/cluster/mcm/cluster_install_demo.html - MySQL Cluster Connector for Java introduces 2 new methods for Java applications to access MySQL Cluster. ClusterJ is a proprietary Object Relational Mapping which provides much faster access than JDBC and removes the need for the Java developer to convert between Java objects and the relational model. ClusterJPA provides a plug-in for OpenJPA providing access to MySQL Cluster using a standards-based Java Persistence API (JPA) interface. The performance of OpenJPA is much better when using ClusterJPA rather than the traditional JDBC approach.
The use of these new Java APIs is described in the “MySQL Cluster Connector for Java” white paper available from http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_connector_for_java.php and is described in 2 recorded webinars: http://www.mysql.com/news-and-events/on-demand-webinars/display-od-487.html and http://www.mysql.com/news-and-events/on-demand-webinars/display-od-488.html
You can also get an overview of MySQL Cluster 7.1 by watching the webinar replay at http://www.mysql.com/news-and-events/on-demand-webinars/display-od-529.html
Jonas’s Blog
- Brewing in MySQL Cluster 7.2.x October 28, 2011
Mikaels’s Blog
- MySQL Thread Pool: Storage Engines November 1, 2011
Bernd Ocklin
- O’Reilly Conference MySQL Cluster slides available April 19, 2011
- Around the volcano and home from US in 20 hours April 20, 2010
- MySQL Cluster 7.1.1 is there February 1, 2010