MySQL Forums
Forum List  »  NDB clusters

Clustering my wiki DB
Posted by: Fletcher Cocquyt
Date: March 16, 2005 03:05PM

Greetings fellow opensource DB clustering people,

I have configured a cluster in the lab according to the tutorial.
I have a test bb-mysql server logging to a NDBCLUSTER table (instead of MyISAM) through a load balancer and its working great.

So I thought it'd be cool to import my wiki database into the cluster.
Here is what I did:

1) mysqldump tikiwikiDB (from non clustered mysql) > tw.dump
2) sed s/TYPE=MyISAM/TYPE=NDBCLUSTER/g tw.dump > twCluster.dump
3) mysql -u root -h mysqlcluster -p tiki < twCluster.dump (first I created the tiki DB on both nodes)

The import is happy until:

ERROR 1073 (42000) at line 990: BLOB column 'heading' can't be used in key specification with the used table type

Is there a workaround to get the import to work and have my wiki DB clustered?

Thanks!
Fletch.

Options: ReplyQuote


Subject
Views
Written By
Posted
Clustering my wiki DB
2960
March 16, 2005 03:05PM
2099
March 16, 2005 04:45PM


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.