content_image/857963.jpg
id=1 @198.51.100.1 (8.0.26-ndb-8.0.26, Nodegroup: 0, *) id=2 @198.51.100.2 (8.0.26-ndb-8.0.26, Nodegroup: 0) id=3 @198.51.100.3 (8.0.26-ndb-8.0.26, Nodegroup: 1 ) id=4 @198.51.100.4 (8.0.26-ndb-8.0.26, Nodegroup: 1 ) [ndb_mgmd(MGM)] 1 node(s) id=10 @198.51.100.10 (8.0.26-ndb-8.0.26) [mysqld(API)] 2 node(s) id=20 @198.51.100.20 (8.0.26-ndb-8.0.26) id=21 @198.51.100.21 (8.0.26-ndb-8.0.26) 

Step 7: Redistribute cluster data.  When a node group is created, existing data and indexes are not automatically distributed to the new node group’s data nodes, as you can see by issuing the appropriate REPORT  command in the management client: 

ndb_mgm> ALL REPORT MEMORY Node 1: Data usage is 5%(177 32K pages of total 3200) Node 1: Index usage is 0%(108 8K pages of total 12832) Node 2: Data usage is 5%(177 32K pages of total 3200) Node 2: Index usage is 0%(108 8K pages of total 12832) Node 3: Data usage is 0%(0 32K pages of total 3200) Node 3: Index usage is 0%(0 8K pages of total 12832) Node 4: Data usage is 0%(0 32K pages of total 3200) Node 4: Index usage is 0%(0 8K pages of total 12832) 

By using ndb_desc  with the -p  option, which causes the output to include partitioning information, you can see that the table still uses only 2 partitions (in the Per partition info  section of the output, shown here in bold text): 

shell> ndb_desc -c 198.51.100.10 -d n ips -p -- ips -- Version: 1 Fragment type: 9 K Value: 6 Min load factor: 78 Max load factor: 80 Temporary table: no Number of attributes: 6 Number of primary keys: 1 Length of frm data: 340 Row Checksum: 1 Row GCI: 1 SingleUserMode: 0 ForceVarPart: 1 FragmentCount: 2 TableStatus: Retrieved -- Attributes -- id Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR country_code Char(2;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY type Char(4;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY ip_address Varchar(15;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY addresses Bigunsigned NULL AT=FIXED ST=MEMORY date Bigunsigned NULL AT=FIXED ST=MEMORY -- Indexes -- PRIMARY KEY(id) - UniqueHashIndex PRIMARY(id) - OrderedIndex 

<img src='content_image/857963.jpg'>

