466 reputation
32
bio website tardis.ed.ac.uk/~fmc
location
age
visits member for 3 years
seen Apr 17 '13 at 14:14

Dec
8
awarded  Yearling
May
10
awarded  Enlightened
May
10
awarded  Nice Answer
Apr
17
answered Redo Logs Mysql Cluster
Dec
8
awarded  Yearling
Mar
5
answered Unable to connect to MySQL cluster database
Jan
10
comment Does mysqld --ndb-cluster need to be run on MySQL Cluster data nodes?
You need to add engine=ndb; to your create table statements to have them stored in the cluster. e.g.CREATE TABLE t1 (a int primary key, b int) engine=ndb; The data itself is stored by the data nodes. The data nodes datadir looks quite different to the MySQL datadir, and it's not really possible to identify files belonging to individual tables. The MySQL nodes store a .frm file and an almost empty .ndb file for each table, but do not store any data.
Jan
10
answered Using all the CPU cores by NDBD and MySQL
Jan
10
answered MySQL Cluster RAM requirement
Dec
22
answered What's the difference between master and slave nodes in MySQL Cluster?
Dec
19
comment MySQL Sharding vs MySQL Cluster
Hi Rolando, Thanks for clarifying your statements. It's true that non-pruned ordered index scans are 'expensive' in Cluster, as all data nodes are involved. It sounds like these scans on low cardinality indices would be expensive on any system, but on Cluster they became visibly expensive. Your caution and pessimism have no doubt saved you more than once :) Thanks for the +1
Dec
8
awarded  Teacher
Dec
8
answered MySQL Sharding vs MySQL Cluster