Vertica AWS POCT

Hi all,

I have Vertica 10 nodes production environment on physical servers and I want to create DR environment at AWS.

I have created an environment in AWS (same as my physical environment) and started Copy Cluster from the physical environment to AWS environment and after it I want to run some POCT on AWS environment to see how it works compare to the physical environment.

 

physical servers (production environment): Vertica 7.1.1-10, 10 nodes, 40TB database size.
AWS environment: Vertica 7.2.1, r3.4xlarge 10 nodes cluster backed by EBS.

 

The tests that I thought to do:
- CPU processing speed test by Vcpuperf (https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/InstallationGuide/scripts/vcpuperf.htm)
- CopyCluster load time
- 10GB load time
- 5 queries select time and check there explain plan.

Does anyone have suggestions for more tests I can do?

 

Thanks
Chen

Comments

  • Hi ,

    in AWS you need to make sure your DR environment able to provide the same IOPS and network latency  as your locale production environment provide .

     

    On top of your plan , make sure you also execute :

    • viopref 
    • vnetpref

    I hope you will find it useful

     

    Thanks 

Leave a Comment

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