This free Developer Edition AMI available from the AWS Marketplace supports a single-node version of ClustrixDB. While not clusterable, it is suitable for compatibility testing or development, but not to assess performance or serve production workloads. It otherwise contains all the features and functionality of the clusterable version of ClustrixDB.
To obtain ClustrixDB for a multi-node environment on AWS or elsewhere, please contact Clustrix Sales.
Go to the AWS EC2 Dashboard and select the “Security Groups” link under Network & Security on the left-side menu.
Then click the “Create Security Group” button.
Enter a Group Name and Description for the Security Group, and select the VPC in which the ClustrixDB instances will run. Select the "Add Rule" button 3 times to add the following rules:
You may customize the Source of each rule. Just be sure that the rule allows proper access from SSH, HTTP, and MySQL clients. We recommend starting with the Source set to “Anywhere” as the rules can be configured to be more restrictive after the installation is complete.
Click the “Create” button, a list of Security Groups will appear.
Now we must add two more rules that were not easy to add in the previous screen. Select the Security Group you just created from this list of groups, and choose Actions → Edit inbound rules.
Add an “All TCP” and an “All UDP” rule. For each of these rules the Source should be “Custom” and the Group Name of this Security Group. These rules will allow all TCP and UDP traffic ONLY within this Security Group.
After selecting “Custom IP” for the Source, in the field to the right start typing this Security Group’s name (e.g. in our example: “clustrixdb-sg”). As you type, a selection menu will appear and you can click the Security Group’s name to cause the ID to be populated.
Please double-check your Security Group settings. Errors in the Security Group are the most common misconfiguration we see with ClustrixDB in AWS.
Click the “Save” button.
Still within the AWS Console, select the EC2 service and then select AMIs from the left-hand menu under the IMAGES category.
The AMI for ClustrixDB Developer Edition can be found at: Clustrix Scale-Out SQL Database: Developer Edition. Click Continue to proceed.
The ClustrixDB Marketplace AMI can also be launched from the EC2 console > AMI section, as well as from the AWS CLI or API.
The next steps will guide you through choosing configuration options for your EC2 instance:
Once you have supplied the desired configuration options, launch your ClustrixDB instance. Once the launch has been initiated, identify the Instance Id and Public IP assigned to your new instance.
Your Developer Edition of ClustrixDB is now set up and ready to use. You can ssh to the server, or connect to it directly via mysql. Be sure ports 22 and 3306 are open for your IP.
Sample showing ssh to the node and connect to the DB.
When logged on to a clustrixDB server as a sudo user, you can access the DB as root without password.
2. Sample showing connecting to the node directly with mysql.
Clustrix implemented its own database engine but the SQL prompt for ClustrixDB was designed to emulate MySQL.
Here are some links that might be useful for your next steps with Clustrix: