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.0

...

From the AWS Console, gather the private IP address of each EC2 instance that will run the ClustrixDB software. You will need these IP addresses during the installation.

...

Form the ClustrixDB Cluster

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

# 
SSH
set 
into
permissions 
one
for 
of
the 
ClustrixDB
pem 
servers
file
shell> chmod 600 <path_to_ec2_private_key.pem>
# SSH into one of the ClustrixDB servers
shell> ssh –i <path_to_ec2_private_key.pem> [email protected]<ip_of_one_clustrixdb_server>
# Launch the mysql client
shell> mysql -u root

In the MySQL client:

...


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.


-- Set the cluster license
sql> SET GLOBAL license = '
<license
license_key
_here>
';
-- Create a cluster with the other nodes
-- Replace <nodeX_ip_address>, and list all of the other ClustrixDB serverssql>
sql> ALTER CLUSTER ADD '
<node2_private_ip>
ip', '
<node3_private_ip>
ip';

After the The ALTER CLUSTER command , the cluster will form. There may be a brief moment where the MySQL client does not respond while the cluster forms. You can run will initiate a short group change , after which the cluster is formed.

Run the clx command-line utility to view the status of the ClustrixDB nodes. This command can be run on any of the ClustrixDB servers as the clustrix user.

shell> /opt/clustrix/bin/clx stat
Cluster Name:    claef30606ca58824f
Cluster Version: 5.0.45-clustrix-9.0.4
Cluster Status:  OK
Cluster Size:    3 nodes - 16 CPUs per Node
Current Node:    ip-10-76-3-58 - nid 1

nid |     Hostname    | Status |  IP Address  | TPS |      Used      |  Total
----+-----------------+--------+--------------+-----+----------------+--------
  1 |  ip-10-76-3-58  |     OK |  10.76.3.58  | 0   | 10.6M (0.01%)  | 119.0G 
  2 |  ip-10-76-3-105 |     OK | 10.76.3.105  | 0   |  5.9M (0.00%)  | 119.0G 
  3 |  ip-10-76-3-232 |     OK | 10.76.3.232  | 0   |  5.9M (0.00%)  | 119.0G
----+-----------------+--------+--------------+-----+----------------+--------
                                                0   | 22.4M (0.01%)  | 357.0G

Post Installation Setup

Create a user to be used during the import:

-- Create a user for importing           
mysql> grant 
0
all on *.* 
| 22.4M (0.01%) | 357.0G
to '<importuser>'@'%' identified by '<importuserpasswd>';

For more information see: clustrix_import

ClustrixGUI

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. 

Provide the following credentials:

Setting up a Load Balancer

Select the “Load Balancers” link on the left-side menu.

...