Hi,
Is the DataMiner Central Database Offload feature compatible with MySQl Cluster?
Hi Ruben,
I'm definitely not an export on this subject, but after having tested this, I can tell you that it is compatible.
I've created a test setup with 2 data nodes and was able to properly offload and consult the data.
It's important that when creating the database structure, you modify the SQL commands in the CentralTabledef.txt file (found in the C:\Skyline DataMiner\Tools folder) to make all tables use the NDBCLUSTER engine instead of the InnoDB engine. Note that some tables now do not specify an engine, so be sure to add it to those as well if the default engine is not set to NDBCLUSTER on the MySQL Cluster installation.
Also make sure to create the database beforehand yourself, taking into account the above remarks, so DataMiner doesn't create it automatically (as described here). Otherwise you will end up with tables that use the InnoDB engine that doesn't support the distributed concept that you want when using MySQL Cluster.
Hope this helps.