Hi there

I successfully set up a MySQL cluster. Everything seems to work. But there is one problem with creating indexes:

mysql> CREATE UNIQUE INDEX name_index ON domains(name); ERROR 1005 (HY000): Can't create table './pdns/#sql-78b6_19.frm' (errno: 743)

According to perror this means:

db01:/d1# perror --ndb 743 Error code 743: Unsupported character set in table or index: Permanent error: Schema error

I can't really imagine where the problem is. I hope, someone can help me in that case. I've attached more information about my environment below.

Thanks.

Regards, Thomas.

---- Things I already verified

- The user under which mysql runs has full permissions to my datadir

---- The database I use

mysql> show create database pdns; Database Create Database pdns CREATE DATABASE `pdns` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci */

mysql> show create table domains; Table Create Table domains CREATE TABLE `domains` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(255) collate latin1_german1_ci NOT NULL default '',\n `master` varchar(20) collate latin1_german1_ci default NULL,\n `last_check` int(11) default NULL,\n `type` varchar(6) collate latin1_german1_ci NOT NULL default '',\n `notified_serial` int(11) default NULL,\n `account` varchar(40) collate latin1_german1_ci default NULL,\n PRIMARY KEY (`id`)\n) ENGINE=ndbcluster DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci

mysql> select VERSION(); +-----------+ | VERSION() | +-----------+ | 4.1.7-log | +-----------+ 1 row in set (0.00 sec)

---- Configuration of the cluster

NDB> show Cluster Configuration

--------------------- [ndbd(NDB)] 2 node(s) id=2 @212.24.20.198 (Version: 3.5.3, Nodegroup: 0) id=3 @212.24.20.199 (Version: 3.5.3, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s) id=1 @212.24.20.198 (Version: 3.5.3)

[mysqld(API)] 2 node(s) id=4 @212.24.20.198 (Version: 3.5.3) id=5 @212.24.20.199 (Version: 3.5.3)

--- config.ini

[NDBD DEFAULT] NoOfReplicas=2 DataDir=/d1/mysql/cluster

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

[COMPUTER] Id=1 HostName=db01.company.com

[COMPUTER] Id=2 HostName=db02.company.com

[NDB_MGMD] ExecuteOnComputer=1 DataDir=/d1/mysql/cluster

[NDBD] ExecuteOnComputer=1

[NDBD] ExecuteOnComputer=2

[MYSQLD] ExecuteOnComputer=1

[MYSQLD] ExecuteOnComputer=2