Creating MySQL Cluster Tables (4.2)
To create the necessary tables in the database:
Connect to the MySQL client as described in the MySQL documentation https://dev.mysql.com/doc/mysql-cluster-excerpt/8.1/en/, for example:
$ mysql -u root -p <password> -h <IP address to the MySQL Server>
Â
Show existing databases:
mysql> show databases;
The current databases should be displayed.
ÂCreate the PCC database:
mysql> create database pcc;
The PCC database should now be created.
ÂConnect to the database:
mysql> use pcc;
The database should now be changed to pcc.
ÂCreate the
bucket_storage
table by executing the following sql statement:CREATE TABLE bucket_storage ( id bigint NOT NULL PRIMARY KEY, bucketinfo varbinary(13900) NOT NULL ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=1000000000;
Â
Create the
config_storage
 table by executing the following sql statement:CREATE TABLE config_storage ( name varbinary(255) NOT NULL, item int NOT NULL, data varbinary(13700) DEFAULT NULL, PRIMARY KEY using hash(name,item) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
Verify that the tables have been created:
mysql> describe bucket_storage; mysql> describe config_storage;
Â