[root@vm10 /]# cd /vob/fwk_mysql_test0/mysql/QA/ [root@vm10 QA]# ./tools/createMasterSimplex () => Enter Master server id , User name, Slave host (separate by blank) (ex : 11 root vm12 ) => 10 root vm11 Master server id is : 10 User name is : root Slave host is : 172.25.126.11 VM11 vm11 PRESS ENTER to CONFIRM (CTRL_C to EXIT) () => No reference hosts file to check vm10 hosts file *** Start of createMasterSimplex for 'hlr' DataBase *** MDSSMBA004 MDSSMVC000 MDSSMVC001 MDSSMVC002 MDSSMVC003 MDSSMVC004 MDSSMVC005 MDSSMVC006 MDSSMVC007 MDSSMVC008 MDSXMBA000 MDSXMBA002 MDSXMBA004 MDSXMBA005 MDSXMBA007 MDSXMBA008 MDSXMBR000 MDSXMBR001 MDSXMMP000 MDSXMMP001 MDSXMMP002 MDSXMMP003 MDSXMMP004 MDSXMMP005 MDSXMMP006 MDSXMMP007 MDSXMMP008 MDSXMMP009 MDSXMRP000 MDSXMRP001 MDSXMRP003 MDSXMRP004 MDSXMVC000 MDSXMVC001 MDSXMVC002 MDSXMVC003 MDSXMVC004 MDSXMVC005 MDSXMVC006 MDSXMVC007 MDSXMVC008 MDSXMVC032 MDSXMVS000 MDSXMVS001 Choose TestCase name => MDSXMVC032 working test case is : MDSXMVC032 ? PRESS ENTER to CONFIRM (CTRL_C to EXIT) (MDSXMVC032) => Confirm start from scrash (killCluster) ... ? PRESS ENTER to CONFIRM (CTRL_C to EXIT) Cleaning by shutdown /usr/mysql/bin/ndb_mgm -e "shutdown" Unable to connect with connect string: nodeid=0,STATION_A:2200 Retrying every 5 seconds. Attempts left: 2 1, failed. (MDSXMVC032) => Killing vm10 MySQL processes (MDSXMVC032) => Erasing vm10 MySQL database (MDSXMVC032) => mysql database is installed in /user/database/mysql directory (MDSXMVC032) => Launching vm10 MySQL database installation (mysql_install_db) >>>/usr/mysql/bin/mysql_install_db --datadir=/user/database/mysql/< Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/mysql/bin/mysqladmin -u root password 'new-password' /usr/mysql/bin/mysqladmin -u root -h vm10 password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd /usr/mysql ; /usr/mysql/bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the /usr/mysql/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com (MDSXMVC032) => Launching vm10 MySQL database cluster manager (ndb_mgmd) >>>/usr/mysql/libexec/ndb_mgmd --config-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/config.ini --nodaemon&< (MDSXMVC032) => Launching vm10 MySQL database node (ndbd) >>>/usr/mysql/libexec/ndbd --defaults-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/my.cnf --initial< (MDSXMVC032) => waiting for MySQL database 1 node status evolution ('started'/'starting') >>>/usr/mysql/bin/ndb_mgm -e "all status"< Unable to connect with connect string: nodeid=0,STATION_A:2200,STATION_B:2200 Retrying every 5 seconds. Attempts left: 12NDB Cluster Management Server. Version 5.1.8 (beta) Id: 1, Command port: 2200 trying 1 time(s) Connected to Management Server at: STATION_A:2200 Node 3: not connected trying 2 time(s) Connected to Management Server at: STATION_A:2200 Node 3: unknown state (Version 0.0.0) trying 3 time(s) Connected to Management Server at: STATION_A:2200 Node 3: starting (Phase 1) (Version 5.1.8) trying 4 time(s) Connected to Management Server at: STATION_A:2200 Node 3: starting (Phase 1) (Version 5.1.8) trying 5 time(s) Connected to Management Server at: STATION_A:2200 Node 3: starting (Phase 4) (Version 5.1.8) trying 6 time(s) Connected to Management Server at: STATION_A:2200 Node 3: starting (Phase 4) (Version 5.1.8) trying 7 time(s) Connected to Management Server at: STATION_A:2200 Node 3: started (Version 5.1.8) Connected to Management Server at: STATION_A:2200 Node 3: started (Version 5.1.8) (MDSXMVC032) => Launching mysqld server-id=10 (waiting for 10 sec) (MDSXMVC032) => Creation of hlr database (MDSXMVC032) => Definition of database users and acces right attribution (MDSXMVC032) => Result of ps -ef | grep '/usr/mysql' command : ----------------------------------------------------------------------------------------------------------- root 1505 1 4 08:50 pts/0 00:00:01 /usr/mysql/libexec/ndb_mgmd --config-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/config.ini --nodaemon root 1531 1 0 08:50 ? 00:00:00 /usr/mysql/libexec/ndbd --defaults-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/my.cnf --initial root 1537 1531 12 08:50 ? 00:00:03 /usr/mysql/libexec/ndbd --defaults-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/my.cnf --initial root 1704 1397 1 08:50 pts/0 00:00:00 /usr/mysql/libexec/mysqld --defaults-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/my.cnf --user=root --server-id=10 --log-bin=vm10-bin --binlog-format=row --ndbcluster ----------------------------------------------------------------------------------------------------------- *** End of createMasterSimplex *** [root@vm10 QA]# mysql --version mysql Ver 14.12 Distrib 5.1.8-beta, for pc-linux-gnu (i686) using EditLine wrapper [root@vm10 QA]# mysql -D hlr < /vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/test/createtable.sql [root@vm10 QA]# [root@vm10 QA]# /vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/rh9/bin/basic-type-popul To drop created table use: echo "drop table IMSI" | mysql hlr -u root [root@vm10 QA]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 5.1.8-beta-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from cluster.binlog_index; +----------+-------------------+-------+---------+---------+---------+-----------+ | Position | File | epoch | inserts | updates | deletes | schemaops | +----------+-------------------+-------+---------+---------+---------+-----------+ | 2493 | ./vm10-bin.000001 | 287 | 2028 | 0 | 0 | 0 | | 1215518 | ./vm10-bin.000001 | 288 | 5358 | 0 | 0 | 0 | | 6848831 | ./vm10-bin.000001 | 289 | 2614 | 0 | 0 | 0 | +----------+-------------------+-------+---------+---------+---------+-----------+ 3 rows in set (0.01 sec) mysql> mysql> select count(*) from hlr.IMSI; +----------+ | count(*) | +----------+ | 10000 | +----------+ 1 row in set (0.04 sec) mysql> mysql> describe hlr.IMSI; +-----------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------------------+------+-----+---------+-------+ | mykey | int(10) unsigned | NO | PRI | | | | vvBin | varbinary(255) | YES | | | | | vvchar | varchar(255) | YES | | | | | vvlBin | varbinary(256) | YES | | | | | vvlchar | varchar(256) | YES | | | | | vchar | char(255) | YES | | | | | vbinary | binary(255) | YES | | | | | vUnsigned | int(10) unsigned | YES | | | | | vBigunsigned | bigint(20) unsigned | YES | | | | | vMediumunsigned | mediumint(8) unsigned | YES | | | | | vTinyunsigned | tinyint(3) unsigned | YES | | | | | vSmallunsigned | smallint(5) unsigned | YES | | | | | vBigint | bigint(20) | YES | | | | | vMediumint | mediumint(9) | YES | | | | | vInt | int(11) | YES | | | | | vSmallint | smallint(6) | YES | | | | | vTinyint | tinyint(4) | YES | | | | | vBit | bit(10) | YES | | | | +-----------------+-----------------------+------+-----+-- -------+-------+ 18 rows in set (0.01 sec) mysql> quit Bye [root@vm10 QA]# pwd /vob/fwk_mysql_test0/mysql/QA [root@vm10 QA]# /vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/rh9/bin/basic-type-ope [root@vm10 QA]# mysql -D hlr Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 59 to server version: 5.1.8-beta-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from IMSI where mykey <3\G; *************************** 1. row *************************** mykey: 0 vvBin: u vvchar: u vvlBin: u vvlchar: u vchar: u vbinary: u vUnsigned: 5 vBigunsigned: 5 vMediumunsigned: 16736773 vTinyunsigned: 5 vSmallunsigned: 5 vBigint: 5 vMediumint: 5 vInt: 5 vSmallint: 5 vTinyint: 5 vBit: *************************** 2. row *************************** mykey: 2 vvBin: u vvchar: u vvlBin: u vvlchar: u vchar: u vbinary: u vUnsigned: 5 vBigunsigned: 5 vMediumunsigned: 16736773 vTinyunsigned: 5 vSmallunsigned: 5 vBigint: 5 vMediumint: 5 vInt: 5 vSmallint: 5 vTinyint: 5 vBit: *************************** 3. row *************************** mykey: 1 vvBin: A vvchar: A vvlBin: A vvlchar: A vchar: 1 vbinary: 1 vUnsigned: 0 vBigunsigned: 0 vMediumunsigned: 0 vTinyunsigned: 0 vSmallunsigned: 0 vBigint: -9223372036854775808 vMediumint: -8388608 vInt: -2147483648 vSmallint: -32768 vTinyint: -128 vBit: 3 rows in set (0.64 sec) ERROR: No query specified mysql>