Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.1

...

To join the ClustrixDB servers into a single unified cluster, connect to one ClustrixDB server and run a few SQL commands.

# set permissions for the pem file


shell> chmod 600 
<path
path_to_ec2_private_key.
pem>
pem
# SSH into one of the ClustrixDB servers


shell> ssh –i 
<path
path_to_ec2_private_key.
pem>
pem 
[email protected]<ip
[email protected]_of_one_clustrixdb_
server>
server
# Launch the mysql client
shell> mysql -u root   


Note

The ClustrixDB AMI uses the clxd OS user to run the database process. An additional management (clustrix) is also configured. See Overview of OS Users and Managing Users and Privileges for more information.

Run the commands below where ip is the internal/private ip address of each node (10.0.x.y).

-- Set the cluster license
sql> SET GLOBAL license = 'license_key';

-- Create a cluster with the other nodes

sql> ALTER CLUSTER ADD 'ip', 'ip';

The ALTER CLUSTER command will initiate a short group change , after which the cluster is formed.

...

Create a user to be used during the import:. This should be done while logged into ClustrixDB as the root DB user.

-- Create a user for importing
 

mysql>
sql> grant all on *.* to '
<importuser>
importuser'@'%' identified by '
<importuserpasswd>
importuserpasswd';

For more information see: clustrix_import

...

The ClustrixGUI must be started with the following commands before the first time you access it.

shell> /opt/clustrix/bin/clx nanny stop_job clxdbi

shell> /opt/clustrix/bin/clx nanny start_job clxdbi 

Access the ClustrixGUI by typing the ip or hostname of one of your nodes into a web browser, include port :8080.  Chrome is the recommended web browser. 

...