MySQL Forums
Forum List  »  NDB clusters

Re: can not use indexes with mySQL Cluster?
Posted by: Anton Aleksandrov
Date: May 05, 2005 08:06AM

Guys.. Could you please give me simple answer - does MySQL cluster support indexes and primary keys or not? I have setup MySQL cluster with the following configuration: 6 data nodes, 3 API nodes, 1 management server (which is one of the API nodes at the same time). It works until I try to run the following SQL...

mysql> CREATE TABLE GBbuffer (
-> id int(10) NOT NULL default '0',
-> til int(6) NOT NULL default '0',
-> fra int(6) NOT NULL default '0',
-> beskjed text,
-> tid datetime default NULL,
-> PRIMARY KEY (id)
-> ) ENGINE=NDBCLUSTER;
ERROR 1005 (HY000): Can't create table './test/GBbuffer.frm' (errno: 4009)

After that all data nodes crashes and I have to go and start them again. I would appreciate your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: can not use indexes with mySQL Cluster?
2186
May 05, 2005 08:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.