9 responses to “MySQL Cluster 7.1.15 released”

• 

  Ram September 13th, 2011 at 11:03

  I have small query. In mysql cluster can we do the following scenarios?
  Let us assume we have 4 data nodes. Each data node has different tables.
  1)If I query one table, if it is available in all the data nodes with different data. Will it fetch union of all and gives us the result?
  2)Can i query multiple columns from multiple tables from multiple nodes?

• 

  admin September 14th, 2011 at 09:54

  The table data is automatically horizontally partitioned across all of the data nodes. You don’t get to choose that you want a particular table to be stored on a particular data node.

  The MySQL Server chooses a data node to send the query to and that data node will co-ordinate with the other data nodes if necessary to provide the response back to the MySQL Server. You can send a query (read or write) to any MySQL Server as they all have access to all data nodes.

  You can perform complex queries including cross-table joins.

  Regards, Andrew.

• 

  Ram September 19th, 2011 at 09:31

  Can you please send me some doc/url guide to install data nodes and cluster mgmt setup in Linux redhad systems. I have 4systems, i want to put data nodes across all the machines and retrieve. how to retrieve also please send me doc.

• 

  admin September 19th, 2011 at 10:02

  A good place to start for deploying a cluster over multiple Linux hosts is http://www.clusterdb.com/mysql-cluster/deploying-mysql-cluster-over-multiple-hosts/

• 

  Ram September 20th, 2011 at 11:30

  Hi, i’m doing this in two window boxs.
  workstation 1(172.20.1.82) config file:
  [ndb_mgmd]
  hostname=172.20.1.82
  datadir=D:\mysql-cluster\Users\user1\my_cluster\ndb_data
  id=1

  [ndbd default]
  noofreplicas=1

  [ndbd]
  hostname=172.20.0.131
  id=3

  [ndbd]
  hostname=172.20.1.181
  id=4

  [mysqld]
  Id=50

  workstation 1(172.20.1.82) my.cnf file:
  [mysqld]
  ndbcluster
  datadir=D:\\mysql-cluster\\Users\\user1\\my_cluster\\mysqld_data
  basedir=D:\\mysql-cluster\\mysqlc
  port=3306

  workstation 2 (172.20.0.131) config file:
  [ndbd default]
  noofreplicas=1
  datadir=E:\mysql-cluster\Users\user1\my_cluster\ndb_data

  [ndb_mgmd]
  hostname=172.20.0.131
  id=1

  [ndbd]
  hostname=172.20.0.131
  datadir=E:\mysql-cluster\Users\user1\my_cluster\ndb_data
  id=3

  [mysqld]
  id=50
  workstation 2 (172.20.0.131) my.cnf file:
  [mysqld]
  ndbcluster
  ndb-connectstring=’host=172.20.1.82′
  [mysql_cluster]
  ndb-connectstring=’host=172.20.1.82′

  when i try to run on workstation, it is unable to connect workstation 2. just please guide me do how to configure in two window systems. how to i connect one each other etc

• 

  Ram September 21st, 2011 at 05:24

  Hi the above problem was solved. but now i want to load 4GB of data, but it is breaking. how n where should i mention those memory related stuff?

• 

  admin September 21st, 2011 at 08:04

  Hi Ram,

  you don’t mention what errors your seeing but it could well be that you haven’t configured enough memory for your data nodes. MySQL Cluster doesn’t allocate memory dynamically – when the data nodes start up the total amount of memory is allocated and then you eat into that as rows are added. You configure the amount of memory allocated by setting the DataMemory and IndexMemory parameters in the [ndbd default] section of your config.ini file.

  Regards, Andrew.

• 

  Ram September 22nd, 2011 at 04:56

  I have two systems, 2GB RAM, i configured ndbd defualt with following values.
  [ndbd default]
  noofreplicas=2
  DataMemory= 1024M
  IndexMemory= 256M

  I put the same in both the machines. I’m trying to load 4GB data table, around 13million records. but it got inserted 10Lack records after that getting error as table is full. then i increased memory 1024 to 1280 and restarted mysqlcluster in both the systems.

  [ndbd default]
  noofreplicas=2
  DataMemory= 1280M
  IndexMemory= 256M

  after it got inserted some more, now it has 1.3Million again started table is full. What is the calculation i need to follow as per my RAM. Is that data memory value is multiple of some value like 265,512,1024 etc. Is this RAM memory or harddisk memory?

  if you dont mind i want to do live chat with you. if possible add my gmail a.c and ping me ramprasadmca@gmail.com

• 

  admin September 22nd, 2011 at 07:18

  Hi Ram,

  note that as you have set noofreplicas to 2, every row in a cluster table will be stored twice (once on each of 2 data nodes) and so your 4 Gbyte table will actually require 8 GBytes – if you have 2 servers than that means 4 GBytes on each. If you need to store that table on those servers (and can’t add more memory) then consider storing at least some of the columns on disk rather than in memory… http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html

  Regards, Andrew.