Release Notes:
This ami upgrades to Vertica 3.5.9. This version also updates the kernel to 2.6.21 resolving a kernel memory leak that was triggered during multi-week trickle loads.
Previous version (updated to 3.0.18): ami-1806e471
To get started with the Vertica Analytic Database, run the ami using any 64 bit server such as m1.large, m1.xlarge or c1.large.
Specify your key so you can have root access to the server. You may also choose to open one or more of the following ports:
- Port 22 for secure shell access
- Port 80 for web access to your Vertica welcome page
- Port 5433 for remote access to your Vertica database over JDBC or ODBC
- Port 10000 for access to the Vertica web based administration console
Note that if launching in a non-default security group you must explicitly open port 5433/TCP, 4833/UDP and TCP and sufficient higher number ports for cluster communication within the security group.
You can open these ports using the ec2auth command:
$ ec2auth -p [PORT] [GROUP]
You may also restrict the source subnet to your company's public subnet or IP address the -s argument or to another group within EC2 such as the group for your application server using the -o argument.
For an example of configuring Elastic Block Storage see the instance script /root/vertica/ebs_setup.
At launch, the Vertica Analytic Database is installed and configured with the Vertica web based administration console.
Once the server has started, check the console output for the database administrator's (username dbadmin) password.
From the cli tools you can issue the following commands to retrieve the hostname and password:
$ ec2din i-XXXXXXXX
RESERVATION r-XXXXXXXX [account_id] default
INSTANCE i-XXXXXXXX ami-ffd83e96 ec2-XX-XX-XX-XX.compute-1.amazonaws.com
m1.large 2009-05-28T15:49:57+0000 us-east-1a
$ ec2gcons i-XXXXXXXX | grep "dbadmin password"
Vertica dbadmin password: [random_pass]
When you enter the hostname in your web browser you will see a welcome page with a link to useful resources
such as documentation and client drivers as well ass the Vertica administration tools:
Clicking on the administration tools link will bring you to a license page followed by a sign up or sign in page.
If you already have a Vertica.com website login you can use your existing username and password. If you are
new to vertica, you can register directly from this sign up page. If you already have a Vertica license key you
can also upload the license key from this page. One you sign in you will see the Vertica administration tools main page.
Clicking on the Configuration Menu will bring to the configuration page where you can create your first Vertica database.
Follow the database creation wizard after which your database will start automatically.
|
