Category Archives: MySQL Cluster

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 7.6 is Generally Available

June 1, 2018High Availability, MySQL ClusterBernd Ocklin

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!

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