Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • System Architecture
      • DataMiner Releases & Updates
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Central database offload compatible with MySQL Cluster?

Solved1.04K views18th July 2023central database Offload MySQL
4
Ruben Vandepitte [SLC] [DevOps Advocate]2.28K 2nd November 2021 0 Comments

Hi,

Is the DataMiner Central Database Offload feature compatible with MySQl Cluster?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
2
Wouter Bogaert [SLC] [DevOps Advocate]969 Posted 11th March 2022 0 Comments

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.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2023
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

How is Automation run scripts count run calculated by Skyline? 0 Answers | 1 Vote
Saml attributs in Dataminer 0 Answers | 1 Vote
Table layout changing 1 Answer | 1 Vote

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (110) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (153) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin