LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   How to convert/changes MySQL Tables from MyISAM to NDBCLUSTER (http://www.linuxquestions.org/questions/linux-software-2/how-to-convert-changes-mysql-tables-from-myisam-to-ndbcluster-851572/)

cparapat 12-21-2010 07:09 AM

How to convert/changes MySQL Tables from MyISAM to NDBCLUSTER
 
Hi guys,

Is there somebody knows about how to convert or changes tables on MySQL ?
I was working a lot of months with MySQL with localhost. And now will setting up to MySQL database Cluster. I was success to setup the clustered with "MySQL-Cluster-gpl-7.0.16" on CentOS environment.
But, when I tried to restore database from localhost to clustering system, I get this message error when do changes from MyISAM to NDBCLUSTER Tables "Error, Can't create table 'dbname.sql-3ef9_a8'(errno: 708).

How can I changes the table ?

Thank very much before..

chickenjoy 12-22-2010 01:50 AM

Did you do a quick google search on what does errno: 708 meant? and what have you tried already?

cparapat 12-23-2010 12:18 AM

Quote:

Originally Posted by chickenjoy (Post 4199724)
Did you do a quick google search on what does errno: 708 meant? and what have you tried already?

In the first time, i get that message error when I do converting with Navicat. I guess, it looks like configuration problem. I try to reconfigured this. And I am not using Navicat (MySQL GUI) to convert the tables. I used MySQL command with "alter" option. I can convert some tables, but not all of the tables. Because in the middle of converting, I get back again that message error. It's looks like the server not strongly to serve the converting tables. I don't get many information from the logs. I guess, maybe this is a bug ?

For reference, here is my configuration ;

In NDB_MGMD
#########################################################
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
[NDB_MGMD]
# IP address of the management node (this system)
HostName=172.32.10.1
# Section for the storage nodes
[NDBD]
# IP address of the first storage node
HostName=172.32.10.2
DataDir=/var/lib/mysql-cluster
DataMemory=1024M
[NDBD]
# IP address of the second storage node
HostName=172.32.10.3
DataDir=/var/lib/mysql-cluster
DataMemory=1024M
[MYSQLD]
[MYSQLD]
[MYSQLD]
##############################################

And this is configuration in NodeDB ;

##############################################
# vi /etc/my.cnf
[client]
port=3306
socket=/var/lib/mysql/mysql.sock

[mysqld]
ndbcluster
# IP address of the cluster management node
ndb-connectstring=172.32.10.1
default-storage-engine=NDBCLUSTER

#max_connections=341
#query_cache_size=16M
#thread_concurrency = 4

[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=172.32.10.1
####################################################

cparapat 02-04-2011 04:05 AM

Is there solutions ? :(


All times are GMT -5. The time now is 11:12 AM.