Article Title: ubuntu: NDB node configuration. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
NDB node configuration
1. Create a database for ldirector
Now, we create an ldirectordb database and grant the database permission to the ldirector user. Ldirector uses the database to check the running status of the two database nodes.
On the mysql-data1.mytest.com, create the database:
$ Mysql-u root-p
On the MySQL command line interface, enter the following command:
Mysql> grant all on ldirectordb. * TO 'lctor ctor '@' % 'identified by 'ldirectorpassw ord ';
Mysql> flush privileges;
Mysql> create database ldirectordb;
Mysql> USE ldirectordb;
Mysql> create table connectioncheck (Status INT) ENGINE = NDBCLUSTER;
Mysql> insert into connectioncheck () VALUES (1 );
Mysql> quit
Then, create the database on the mysql-data2.mytest.com and the data is automatically copied from the mysql-data1:
$ Mysql-u root-p
On the MySQL command line interface, enter the following command:
Mysql> grant all on ldirectordb. * TO 'lctor ctor '@' % 'identified by 'ldirectorpassw ord ';
Mysql> flush privileges;
Mysql> create database ldirectordb;
Mysql> quit
[1] [2] [3] [4] [5] [6] Next page