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.…
The MySQL NDB Cluster team works on fundamental redesigns of core parts of NDB architecture. One of these changes is the partial checkpoint algorithm. You can now take full advantage of it when building much larger clusters: NDB 8.0 can use 16 TB data memory per data node for in-memory tables.…
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
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.…