The Automatic Schema Synchronization mechanism, detailed in a two part series: part 1 and part 2, automatically detects and synchronizes mismatches in metadata between NDB Dictionary and MySQL Server’s Data Dictionary. Information about the mechanism is exposed through different MySQL Server status variables.…
In part 1, we took a brief, high-level look at the various protocols and mechanisms used to keep the Data Dictionary (DD) of MySQL servers connected to a MySQL Cluster in synchronization with each other and with the NDB Dictionary.…
Data nodes are the distributed, sharded storage core of MySQL NDB Cluster. Its data is usually accessed by MySQL Servers (also called SQL nodes in NDB parlance). The MySQL servers each have their own transactional Data Dictionary (DD) where all the metadata describing tables, databases, tablespaces, logfile groups, foreign keys, and other objects are stored for use by MySQL server.…
MySQL Cluster Manager 1.4.7 is now available for download from My Oracle Support.
MCM 1.4.7 continues to improve MySQL Cluster Manager by adding some sought after features – and some important bugfixes.
The 1.4.7 release bundles MySQL Cluster 7.6.8.…
Bootstrap and go!
- Download and install MCM and MySQL Cluster
- Bootstrap a cluster with MCM
$ mcmd –bootstrap
- Connect to the database, and have at it
$ mysql -h 127.0.0.1
It gives us great pleasure to announce that the 7.6 release of MySQL Cluster is now ready for prime time.
MySQL Cluster is the distributed database combining linear scalability and high availability. It provides in-memory real-time access with transactional consistency across partitioned and distributed datasets designed for mission critical applications.…
MySQL Cluster Manager 1.4.6 is now available for download from My Oracle Support.
In MCM 1.4.6, the list backups command has been extended with a new –agent option for listing agent backups created with the backup agents command.
MySQL Cluster Manager 1.4.5 is now available for download from My Oracle Support.
MCM 1.4.5 contains further stability and usability improvements of MySQL Cluster Manager.
The 1.4.5 release bundles MySQL Cluster 7.5.9. However, since MySQL Cluster 7.5.7, system tables contain sufficient information for MCM to properly support rolling reconfigurations when ndb_cluster_connection_pool is enabled for mysqlds.…