MySQL Forums
Forum List  »  NDB clusters

Re: Can't create table (errno:4242 )
Posted by: Peter Schulz
Date: February 07, 2006 10:32AM

my config ini - configured by hoster... ... we want to use large databases (up 2 4gb, at least 700mb... but the sql i run was about 1MB or so... ) - > should we change some settings hmmm?... ,...

-------------------------
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

# TCP/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead

# Management process options:
[NDB_MGMD]
hostname=192.168.10.20 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
hostname=192.168.10.38 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# Options for data node "B":
[NDBD]
hostname=192.168.10.40 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# SQL node options:
#[MYSQLD]
#hostname=192.168.10.34 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

#[MYSQLD]
#hostname=192.168.10.36 # Hostname or IP address
[MYSQLD]
[MYSQLD]
------------------------------------------------

hope it helps for anaylsis... we have 4 servers in our cluster - 2 for web, 2 for db, the db-servers we want to have that storage engine "ndbcluster" for performance purposes... the sql statement was send to the mgmtd...

_pete®

Options: ReplyQuote


Subject
Views
Written By
Posted
2776
February 06, 2006 09:47AM
1424
February 06, 2006 11:39AM
1639
February 06, 2006 12:15PM
1608
February 07, 2006 09:21AM
Re: Can't create table (errno:4242 )
1486
February 07, 2006 10:32AM
1523
February 07, 2006 10:36AM
1470
February 08, 2006 02:04AM
1514
February 10, 2006 03:43AM
1545
February 12, 2006 01:08PM
1693
February 15, 2006 06:47AM
1441
February 15, 2006 07:09AM
1344
February 15, 2006 07:24AM
1468
February 15, 2006 07:48AM
1523
February 15, 2006 07:49AM
1390
February 15, 2006 08:02AM
1413
February 15, 2006 09:11AM
1603
March 07, 2006 11:34AM
1571
March 07, 2006 11:38AM


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.