Re: can not use indexes with mySQL Cluster?
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.
Subject
Views
Written By
Posted
3405
April 01, 2005 06:45PM
2288
April 02, 2005 02:28AM
2132
April 04, 2005 09:09AM
2093
April 04, 2005 09:29AM
2256
April 29, 2005 01:47PM
Re: can not use indexes with mySQL Cluster?
2186
May 05, 2005 08:06AM
2123
June 01, 2005 06:59AM
2145
June 01, 2005 01:12PM
2165
June 01, 2005 01:10PM
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.