Ubuntu System: Cluster connectivity Status test

A. Cluster connectivity status test

First, we go back to the Management node (mysql-mgm.mtest.com). On the server, execute the following command:

$ ndb_mgm

After the command is executed, it enters the MGM client interface and displays the MGM prompt:

--NDB Cluster--Management Client--

Ndb_mgm>

At this prompt, enter the show command to view the current connection status:

Ndb_mgm> Show

Under normal circumstances, you should display the following:

From the above we can see that two NDB nodes 192.168.1.13 and 192.168.1.14 are already connected to the management node. Configuration Successful!

Execute quit or exit command to exit MGM client:

Ndb_mgm> quit

Now let's take a look at the cluster's normal data storage. We will perform data operations on two storage nodes, respectively.

1. Data Synchronization Test

First, on the node mysql-data1.mytest.com, we create a database and insert a row of data.

$ mysql-u Root-p

After entering the password, the MySQL client's command line interface is entered. In the interface, enter the following command: