I used the configurator tool for a 4 node MySQL Cluster im creating.
Node 1: MGMA & SQLA Node
Node 2: MGMB & SQLB Node
Node 3: NDBA
Node 4: NDBB
I have created databases using the cluster option and see databases created succesfully and replicated between the Data nodes (NDBA & NDBB). But I also see data being created and stored on the SQL Nodes as well. Im fairly new to MySQL so was wondering if someone could advise why data is being stored on the SQL nodes, and is it being replicated. Is this is bad configuration setup, as the MGM nodes only know about the 2 data nodes.
Attached are my config files. im using the same my.cnf across all data and SQL nodes.
Thanks in advance for your help.
Please sign in to leave a comment.