So you’ve done all the hard work, now what?
We need to test that everything is working. Ie:
- That the Management Daemon can see the NDB instances.
- That the NDB instances are running on the two cluster nodes
- The MySQL client can connect and talk to the NDB presented tables
start the MySQL client
and execute the following command to show available NDB nodes:
show global status like 'ndb_number_of%';
mysql -uroot -p[password you set when first running mysql]
root@cgepi1:/var/lib/mysql-cluster# mysql -uroot -phelpdesk Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.25a-ndb-7.3.0-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is[Read more...]