Vertica does not allow me to create Eon mode database

raphael_costaraphael_costa Registered User

Hi,
We are trying to evaluate Eon mode database.
But I couldn't do it.
First, I installed a 3 node cluster deploying vertica.deb's at each node and after running install_script -s option.
After that I created a Enterprise Mode Database through admintools.
After some test, I decided to drop the Enterprise Mode database and create a Eon mode database through admintools also. But, after inform all the information to create database and hit ok, admintools return a error informing that it can't access the S3 repository.
So, I created once again a Enterprise mode database, setup the S3 backup and started. Just works! I check that the problem is not my access to S3.
So I decided to uninstall vertica in all nodes, installed the deb again, install Management Console and one of the Nodes and create the Vertica Cluster through MC choosing EON Mode cluster.
But failed again. MC does not allow me to create a Vertica Cluster. Just that!
If someone can help that will be much appreciate.

Best Answer

  • Accepted Answer

    Make sure that the instances have access to the S3 bucket via an IAM Role from the AWS console. This role must provide S3 Read/Write access and MUST be assigned to the EC2 instance you are running.

    Then you can proceed to install manually using admintools.

    admintools -t create_db -d dbname -s ipaddr1,ipaddr2,ipaddr3 -c /path/to/catalog -D /path/to/data --shard-count=3 --communal-storage-location=s3://path/to/bucket --depot-path=/path/to/depot --depot-size=80%

    *change you shard count, ip addresses, depot size and directories accordingly

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file