LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 12-21-2010, 06:09 AM   #1
cparapat
LQ Newbie
 
Registered: Jun 2010
Location: Indonesia
Distribution: Mac OS X, Centos, OpenSuSE, Redhat, FreeBSD.
Posts: 26

Rep: Reputation: 0
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..
 
Old 12-22-2010, 12:50 AM   #2
chickenjoy
Member
 
Registered: Apr 2007
Distribution: centos,rhel, solaris
Posts: 200

Rep: Reputation: 30
Did you do a quick google search on what does errno: 708 meant? and what have you tried already?
 
Old 12-22-2010, 11:18 PM   #3
cparapat
LQ Newbie
 
Registered: Jun 2010
Location: Indonesia
Distribution: Mac OS X, Centos, OpenSuSE, Redhat, FreeBSD.
Posts: 26

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by chickenjoy View Post
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
####################################################
 
Old 02-04-2011, 03:05 AM   #4
cparapat
LQ Newbie
 
Registered: Jun 2010
Location: Indonesia
Distribution: Mac OS X, Centos, OpenSuSE, Redhat, FreeBSD.
Posts: 26

Original Poster
Rep: Reputation: 0
Is there solutions ?
 
  


Reply

Tags
clustering, mysql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Overhead tables MyISAM in MySQL Stephan_Craft Linux - Software 2 07-20-2008 04:38 PM
Tutorial: Setting up MySQL quotas for users (MyISAM) nileshgr Linux - Server 4 02-04-2008 06:37 AM
what mysql version does support NDBCLUSTER for slackware flatform sardonyx Linux - Software 0 04-18-2006 01:35 AM
mysql reinstallation distorted by previous tables in /var/mysql mad4linux Linux - Software 0 10-04-2005 01:39 PM
mysql tables with a - pk21 Linux - Software 7 05-23-2003 06:27 AM


All times are GMT -5. The time now is 08:50 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration