MySQL Cluster Configuration - SQL Node storing data also?

Follow

Vinay Mistry

• December 10, 2011 22:10

Hi,

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.

my.cnf
config.ini

0

• 

  Chris B.

  • February 22, 2012 10:02

  Hi Vinay,

  is it possible that you have any tables wich are NOT NDB-Tables?!

  I think these tables (like MyIsam, InnoDB) would be stored in the local SQL-Instance.

   

  BR
  Chris

  0

  Comment actions Permalink
• 

  Johan

  • February 23, 2012 11:33

  Just adding some more info on Chris'  very good comment:

  If you do a 

  SHOW TABLE STATUS 

  you will see what engine your tables are using.

  If you in your CREATE TABLE statements have  ENGINE=INNODB  or ENGINE=MYISAM, the tables are non-clustered and stored on the local SQL Node.  

  You can then do

  ALTER TABLE table_name ENGINE=ndbcluster;

  on those, and they will be converted into clustered ndb tables.

  Best regards,

  Johan

   

  0

  Comment actions Permalink

Please sign in to leave a comment.