11 messages in com.mysql.lists.clusterRe: More than an API on a computer| From | Sent On | Attachments |
|---|---|---|
| Tatiana Peña | 21 Sep 2004 09:53 | |
| Mikael Ronström | 21 Sep 2004 13:46 | |
| Tatiana Peña | 22 Sep 2004 20:34 | |
| Tomas Ulin | 23 Sep 2004 02:44 | |
| Tatiana Peña | 23 Sep 2004 07:16 | |
| Tomas Ulin | 23 Sep 2004 11:52 | |
| Tatiana Peña | 25 Sep 2004 17:15 | |
| Magnus Svensson | 26 Sep 2004 01:15 | |
| Tatiana Peña | 27 Sep 2004 17:08 | |
| Tatiana Peña | 27 Sep 2004 17:12 | |
| Magnus Svensson | 28 Sep 2004 00:19 |
| Subject: | Re: More than an API on a computer |
|---|---|
| From: | Magnus Svensson (msve...@mysql.com) |
| Date: | 09/28/2004 12:19:58 AM |
| List: | com.mysql.lists.cluster |
Quoting Tatiana Peña <tayo...@hotpop.com>:
Hi!
Magnus, how can I run more than an API in the same computer?
You said in you mail that I have to modify my config.ini file, but how can I start the servers? Do I have to configure the Ndb.cfg file different?
Yes, either you have on Ndb.cfg for each API, and set the NodeId parameter different in each one, this gives better control of what nodeid is assigned to a certain application/node.
The other way is to remove the NodeId parameter from Ndb.cfg, this will allow the MGM server to assign you the first free nodeid for that host.
You can also provide this information in the my.cnf file using the parameter ndb-connectstring=<host:port>
Best regards Magnus
-- Tatiana Peña <tayo...@hotpop.com>
El dom, 26-09-2004 a las 03:15, Magnus Svensson escribió:
Quoting Tatiana Peña <tayo...@hotpop.com>:
Hi!
I changed my config.ini and when I set MaxNoOfConcurrentOperations= 10000 TimeBetweenWatchDogCheck= 30000
I got the same error creating the 21th table: $ create_sept.sh user passwd ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040921.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040922.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040923.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040924.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040925.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040926.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040927.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040928.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040929.frm' (errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040930.frm' (errno: 709) $
:(
But when I put the setting Diskless= 1
it works perfectly! and I could insert more than 150000 rows on one of the tables created.
Can you please try the script without this parameter? I need my tables to be permanent.
Yes,
have you increased the MaxNoTable, MaxNoAttributes, MaxNoIndexes and MaxNoOrderedIndexes parameters? Please try to increase them.
Also, following your instructions I tried to run ndb_show_tables on the MGM but I got another error:
#ndb_show_tables Configuration error: Could not alloc node id: No free node id found for mysqld(API). waitUntilReady - 4269: No connection to ndb management server
NDBT_ProgramExit: 1 - Failed
What I'm doing wrong??
You should add some more API nodes to your config.ini! In that way you can connect with more simultaneous clients to the cluster.
[API] Id: 6 ExecuteOnComputer: 2
[API] Id: 7 ExecuteOnComputer: 3
[API] Id: n ExecuteOnComputer: n
Thanks for your help!!
-- Tatiana Peña <tayo...@hotpop.com>
I tested this successfully:
mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | t1 | | t2 | | t3 | | tbl_20040901 | | tbl_20040902 | | tbl_20040903 | | tbl_20040904 | | tbl_20040905 | | tbl_20040906 | | tbl_20040907 | | tbl_20040908 | | tbl_20040909 | | tbl_20040910 | | tbl_20040911 | | tbl_20040912 | | tbl_20040913 | | tbl_20040914 | | tbl_20040915 | | tbl_20040916 | | tbl_20040917 | | tbl_20040918 | | tbl_20040919 | | tbl_20040920 | | tbl_20040921 | | tbl_20040922 | | tbl_20040923 | | tbl_20040924 | | tbl_20040925 | | tbl_20040926 | | tbl_20040927 | | tbl_20040928 | | tbl_20040929 | | tbl_20040930 | | transport | +----------------+ 34 rows in set (0.00 sec)
my config file:
[ndbd default] NoOfReplicas= 2 MaxNoOfConcurrentOperations= 10000 DataMemory= 40M IndexMemory= 12M Diskless= 1 TimeBetweenWatchDogCheck= 30000 DataDir= /home/tomas/mysql/mysql-test/ndbcluster-2200
[ndbd] HostName= localhost
[ndbd] HostName= localhost
[ndb_mgmd] DataDir= /home/tomas/mysql/mysql-test/ndbcluster-2200 PortNumber= 2200
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[tcp default] PortNumber= 2202
Please run:
ndb_show_tables to see what tables are present in the cluster... and
verify that these are the same as you see through the mysql client
this is what it looks like for me:
bash-2.05b$ ndb_show_tables id type state logging database schema name 0 SystemTable Online Yes sys def SYSTAB_0 2 SystemTable Online Yes sys def NDB$EVENTS_0 4 UserTable Online Yes test def tbl_20040901 6 UserTable Online Yes test def tbl_20040902 8 UserTable Online Yes test def tbl_20040903 10 UserTable Online Yes test def tbl_20040904 12 UserTable Online Yes test def tbl_20040905 14 UserTable Online Yes test def tbl_20040906 16 UserTable Online Yes test def tbl_20040907 18 UserTable Online Yes test def tbl_20040908 20 UserTable Online Yes test def tbl_20040909 22 UserTable Online Yes test def tbl_20040910 24 UserTable Online Yes test def tbl_20040911 26 UserTable Online Yes test def tbl_20040912 28 UserTable Online Yes test def tbl_20040913 30 UserTable Online Yes test def tbl_20040914 32 UserTable Online Yes test def tbl_20040915 34 UserTable Online Yes test def tbl_20040916 36 UserTable Online Yes test def tbl_20040917 38 UserTable Online Yes test def tbl_20040918 40 UserTable Online Yes test def tbl_20040919 42 UserTable Online Yes test def tbl_20040920 44 UserTable Online Yes test def tbl_20040921 46 UserTable Online Yes test def tbl_20040922 48 UserTable Online Yes test def tbl_20040923 50 UserTable Online Yes test def tbl_20040924 52 UserTable Online Yes test def tbl_20040925 54 UserTable Online Yes test def tbl_20040926 56 UserTable Online Yes test def tbl_20040927 58 UserTable Online Yes test def tbl_20040928 60 UserTable Online Yes test def tbl_20040929 62 UserTable Online Yes test def tbl_20040930
NDBT_ProgramExit: 0 - OK
Tatiana Peña wrote:
Hi!! This is the bash script than I'm using to create 30 tables, one for each day from September. The parameters it needs are the user and the password to the database
------ create_sept.sh----- #!/bin/bash # $1 is the user from the database # $2 is the password from the user function create() { mysql cdr -u$2 -p$3 -Ne " create table $1 ( recordType varchar(2), callTransactionType varchar(3), servedmsisdn varchar(15), servedIMEITAC varchar(6), servedIMEIFAC varchar(2), servedIMEISNR varchar(6), servedIMEISP varchar(2), servedMSRN varchar(15), startOfChargingdate date, timeStamp time, callDuration integer, otherpartylongnumberb varchar(20), dialledOtherPartyB varchar(20), thirdpartyb varchar(20), exchangeId varchar(15), tgrpNameIc varchar(10), cicIc varchar(6), tgrpNameOg varchar(10), cicOg varchar(6), sequenceNumber integer, CIDMCC varchar(3), CIDMNC varchar(3), CIDLAC varchar(3), cId varchar(5), inflag varchar(2), inservicekey varchar(2), intermediateSequenceNumber integer, drcCallId varchar(16), drcCallRN varchar(16) ) TYPE=NDB ; " } for i in `seq 1 30`; do if [ $i -lt 10 ]; then create tbl_2004090$i $1 $2 else create tbl_200409$i $1 $2 fi done -----END create_sept.sh----- -- Tatiana Peña <_tayotas@hotpop.com_ <mailto:tayo...@hotpop.com El jue, 23-09-2004 a las 04:44, Tomas Ulin escribió: /Tatiana, please send your script so we can test. Thanks, T Tatiana Peña wrote: Hi! Mysql 4.1.5-gamma is installed with the same config.ini file I've sent. Error 4336 seems not to appear anymore :) I also was trying to create 30 tables using a script but it creates some of them and for the others the system returns: mysql CREATE TABLE ctest13 (i INT) ENGINE=NDBCLUSTER; ERROR 1005 (HY000): Can't create table './cdr/ctest3.frm' (errno: 709) If I delete one table it is possible to create another tables (more than one), but eventually the same error occurs :S What could be the cause of the error? /
Tatiana,
please send your script so we can test.
Thanks,
T
Tatiana Peña wrote:
Hi!
Mysql 4.1.5-gamma is installed with the same config.ini file I've sent. Error 4336 seems not to appear anymore :)
I also was trying to create 30 tables using a script but it creates some of them and for the others the system returns:
mysql> CREATE TABLE ctest13 (i INT) ENGINE=NDBCLUSTER; ERROR 1005 (HY000): Can't create table './cdr/ctest3.frm' (errno: 709)
If I delete one table it is possible to create another tables (more than one), but eventually the same error occurs :S
What could be the cause of the error?
-- Magnus Svensson, Software Engineer MySQL AB, www.mysql.com Office: +46 (0)709 164 491
---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.