All posts by Thomas Nielsen

About Thomas Nielsen

Thomas Nielsen is a software engineer, and the Team Lead for MySQL Cluster Manager, at Oracle. He has worked on different high availability products and technologies in databases, as well as JavaDB, before joining the MySQL Cluster team. He holds an engineering degree from the Norwegian University of Science and Technology, and his past-time passion is gliding instruction and cross country soaring. View all posts by Thomas Nielsen →

MySQL Cluster Manager 1.4.7 released!

December 17, 2018High Availability, MySQL ClusterMySQL, MySQL Cluster, MySQL Cluster CGE, MySQL Cluster ManagerThomas Nielsen

MySQL Cluster Manager 1.4.7 is now available for download from My Oracle Support.

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

June 18, 2018High Availability, MySQL ClusterMySQL, MySQL Cluster, MySQL Cluster CGE, MySQL Cluster ManagerThomas Nielsen

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

June 6, 2018High Availability, MySQL ClusterMySQL, MySQL Cluster, MySQL Cluster CGE, MySQL Cluster ManagerThomas Nielsen

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

June 4, 2018High Availability, MySQL ClusterMySQL, MySQL Cluster, MySQL Cluster CGE, MySQL Cluster ManagerThomas Nielsen

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 Manager 1.4.6 released!

May 9, 2018High Availability, MySQL ClusterMySQL, MySQL Cluster, MySQL Cluster CGE, MySQL Cluster ManagerThomas Nielsen

MySQL Cluster Manager 1.4.6 is now available for download from My Oracle Support.

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.

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)

mcm> list backups --agent mysite;

+------------+-------+---------+----------------------+---------+

+------------+-------+---------+----------------------+---------+

| 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:

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)

mcm> list backups --agent --backupid=1522914121 mysite;

+------------+-------+---------+----------------------+---------+

+------------+-------+---------+----------------------+---------+

| 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!

January 26, 2018High Availability, MySQL ClusterMySQL, MySQL Cluster, MySQL Cluster CGE, MySQL Cluster ManagerThomas Nielsen

MySQL Cluster Manager 1.4.5 is now available for download from My Oracle Support.

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.…