Skip to main content

Vertica AWS POCT

  • February 8, 2016
  • 1 reply
  • 7 views
ChenSha
Forum|alt.badge.img+2

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

    1 reply

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • February 8, 2016

    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 

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement