[root@vm11 /]# cd /vob/fwk_mysql_test0/mysql/QA/ [root@vm11 QA]# ping vm10 PING VM10 (172.25.126.10) 56(84) bytes of data. 64 bytes from VM10 (172.25.126.10): icmp_seq=1 ttl=64 time=2.39 ms 64 bytes from VM10 (172.25.126.10): icmp_seq=2 ttl=64 time=0.725 ms --- VM10 ping statistics --- 2 packets transmitted, 2 received, 0% packet loss, time 1013ms rtt min/avg/max/mdev = 0.725/1.561/2.397/0.836 ms [root@vm11 QA]# ./tools/createSlaveSimplex => Enter Slave server id , User name, masterHost host (separate by blank) (ex : 12 root vm11 ) => 11 root vm10 Slave server id is : 11 User name is : root masterHost host is : 172.25.126.10 VM10 vm10 PRESS ENTER to CONFIRM (CTRL_C to EXIT) *** Start of createSlaveSimplex 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 vm11 MySQL processes (MDSXMVC032) => Erasing vm11 MySQL database (MDSXMVC032) => mysql database is installed in /user/database/mysql directory (MDSXMVC032) => Launching vm11 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 vm11 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 vm11 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 vm11 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: unknown state (Version 0.0.0) Connected to Management Server at: STATION_A:2200 Node 3: not started (Version 5.1.8) (MDSXMVC032) => Opening mysqld server-id=11 (waiting for 5 sec) (MDSXMVC032) => Creation of hlr database (MDSXMVC032) => Definition of database users and acces right attribution (MDSXMVC032) => (1) GRANT ALL ON *.* to root@vm11; GRANT GRANT OPTION ON *.* to root@vm11; (MDSXMVC032) => (2) CREATE USER root@vm10; (MDSXMVC032) => (3) GRANT ALL ON *.* TO root@vm10; (MDSXMVC032) => (4) GRANT GRANT OPTION ON *.* TO root@vm10; (MDSXMVC032) => (5) CHANGE MASTER TO MASTER_HOST="vm10", MASTER_PORT=3306, MASTER_USER="root"; (MDSXMVC032) => Result of ps -ef | grep '/usr/mysql' command : ----------------------------------------------------------------------------------------------------------- root 1503 1 3 08:57 pts/0 00:00:00 /usr/mysql/libexec/ndb_mgmd --config-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/config.ini --nodaemon root 1527 1 0 08:57 ? 00:00:00 /usr/mysql/libexec/ndbd --defaults-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/my.cnf --initial root 1528 1527 13 08:57 ? 00:00:01 /usr/mysql/libexec/ndbd --defaults-file=/vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/mysql/my.cnf --initial root 1587 1395 1 08:57 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=11 --ndbcluster --skip-slave-start ----------------------------------------------------------------------------------------------------------- *** End of createSlaveSimplex *** [root@vm11 QA]# mysql -D hlr < /vob/fwk_mysql_test0/mysql/QA/MDSXMVC032/data/test/createtable.sql [root@vm11 QA]# [root@vm11 QA]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 5.1.8-beta Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> change master to MASTER_LOG_FILE="vm10-bin.000001",MASTER_LOG_POS=2493; Query OK, 0 rows affected (0.00 sec) mysql> start slave; Query OK, 0 rows affected (0.00 sec) mysql> select * from cluster.apply_status; +-----------+-------+ | server_id | epoch | +-----------+-------+ | 10 | 289 | +-----------+-------+ 1 row in set (0.01 sec) mysql> mysql> select count(*) from hlr.IMSI; +----------+ | count(*) | +----------+ | 10000 | +----------+ 1 row in set (0.00 sec) mysql> mysql> use hlr Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> describe 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> alter table IMSI add vInt2 int(11); Query OK, 10000 rows affected (4.29 sec) Records: 10000 Duplicates: 0 Warnings: 0 mysql> describe 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 | | | | | vInt2 | int(11) | YES | | | | +-----------------+-----------------------+------+-----+---------+-------+ 19 rows in set (0.01 sec) mysql> mysql> select * from IMSI where mykey < 3\G; *************************** 1. row *************************** mykey: 0 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: vInt2: NULL *************************** 2. row *************************** mykey: 2 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: vInt2: NULL *************************** 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: vInt2: NULL 3 rows in set (1.05 sec) ERROR: No query specified mysql>