Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 25th October 2006, 18:17
asyadiqin asyadiqin is offline
Senior Member
 
Join Date: Jul 2006
Posts: 120
Thanks: 0
Thanked 1 Time in 1 Post
Default MySQL Cluster On FC5 : error while unpacking from engine

I have 1 management node (192.168.0.1) and 2 storage nodes (node1:192.168.0.2 / node2:192.168.0.3).

On the mgm node, the config.ini is as follows :-

Quote:
[NDBD DEFAULT]
NoOfReplicas=2

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]

[NDB_MGMD]
HostName=192.168.0.1

[NDBD]
HostName=192.168.0.2
DataDir= /var/lib/mysql-cluster

[NDBD]
HostName=192.168.0.3
DataDir= /var/lib/mysql-cluster

[MYSQLD]
[MYSQLD]
On both node machines, the my.cnf are as follows:

Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqld]
ndbcluster
# IP address of the cluster management node
ndb-connectstring=192.168.0.1

[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=192.168.0.1
On the mgm node, these are what is shown in the mgm console.

Quote:
-- NDB Cluster -- Management Client --
ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.2 (Version: 5.0.26, starting, Nodegroup: 0)
id=3 @192.168.0.3 (Version: 5.0.26, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 (Version: 5.0.26)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
Previously, I have created a test database with 1 table (cluster.table_1). Below is the error in both storage nodes.

Quote:
[root@fc5-g2 ~]# mysql -uroot -pmypassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.26-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cluster |
| db_ispconfig |
| mysql |
| test |
+--------------------+
5 rows in set (0.00 sec)

mysql> USE cluster;

Database changed
mysql> SHOW TABLES;
+-------------------+
| Tables_in_cluster |
+-------------------+
| table_1 |
+-------------------+
1 row in set, 1 warning (0.00 sec)

mysql> SELECT * FROM table_1;
ERROR 1105 (HY000): Failed to open 'table_1', error while unpacking from engine

mysql> DROP TABLE table_1;
ERROR 1051 (42S02): Unknown table 'table_1'

mysql> DROP DATABASE cluster;
ERROR 1051 (42S02): Unknown table 'table_1'
First of all, what is happening? Is there anyway I can either access or delete that database at all.

I am quite new to MySQL clustering and do not understand why this is happening. Any help is appreciated. Thanks.
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with load-balanced mysql cluster MvdB HOWTO-Related Questions 4 16th October 2006 12:15
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 05:55
Mysql error during FC5 Perfect Setup g8rbait HOWTO-Related Questions 1 12th August 2006 18:27
MySQL Cluster linux_traveler Server Operation 4 30th July 2006 01:14
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 06:10.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.