Frazer Clement

426 reputation

	426 reputation	bio	website	tardis.ed.ac.uk/~fmc	visits	member for	1 year, 6 months
22 badges		location			seen	Apr 17 at 14:14

12 Actions

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