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.…
Category Archives: MySQL Cluster
Automatic Schema Synchronization in NDB Cluster 8.0: Part 2
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.…
Automatic Schema Synchronization in NDB Cluster 8.0: Part 1
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 released!
Overview
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.…
Setting up NDB cluster connection pooling with MySQL Cluster Manager
Cluster connection pooling
The new MySQL Cluster 7.6 GA supports NDB connection pooling – using multiple NDBAPI connections from a single mysqld to NDB – to allow increased concurrency and throughput.
Cluster connection pooling has been supported in MySQL Cluster for quite a while.
Using –login-path with MySQL Cluster Manager
Protective convenience
Recent versions of MySQL has an added security feature, the –login-path option. This feature puts your username and password in an encrypted file, and you refer clients to this file instead of typing plain text passwords on the console, or putting them in scripts.
Getting started with MySQL Cluster 7.6 using MySQL Cluster Manager 1.4.6
MySQL Cluster 7.6 is GA!
If you’re eager to give the recently announced MySQL Cluster 7.6 GA a spin, I’ll walk you through a quick and simple way to get started using MySQL Cluster Manager 1.4.6.
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 -P 3306 -u root
That simple.…
MySQL Cluster 7.6 is Generally Available
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 released!
Overview
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.
|
1 2 3 4 5 6 7 8 9 |
mcm> list backups --agent mysite; +------------+-------+---------+----------------------+---------+ | BackupId | Agent | Host | Timestamp | Comment | +------------+-------+---------+----------------------+---------+ | 1522914101 | 0 | tonfisk | 2018-04-05 07:41:41Z | | | 1522914105 | 0 | tonfisk | 2018-04-05 07:41:45Z | | | 1522914121 | 0 | tonfisk | 2018-04-05 07:42:01Z | | +------------+-------+---------+----------------------+---------+ 3 rows in set (0.00 sec) |
The output can be filtered with the –backupid option:
|
1 2 3 4 5 6 7 |
mcm> list backups --agent --backupid=1522914121 mysite; +------------+-------+---------+----------------------+---------+ | BackupId | Agent | Host | Timestamp | Comment | +------------+-------+---------+----------------------+---------+ | 1522914121 | 0 | tonfisk | 2018-04-05 07:42:01Z | | +------------+-------+---------+----------------------+---------+ 1 row in set (0.07 sec) |
The backupids for agent backups reflect the Unix Epoch times at which the backups were taken.…
MySQL Cluster Manager 1.4.5 released!
Overview
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.…