Vertica AWS POCT

Moderator: NorbertKrupa

Post Reply
chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Vertica AWS POCT

Post by chenshaulian » Mon Feb 08, 2016 12:12 pm

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/ ... puperf.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

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Vertica AWS POCT

Post by NorbertKrupa » Mon Feb 08, 2016 7:07 pm

vioperf & vnetperf.
Checkout vertica.tips for more Vertica resources.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Vertica AWS POCT

Post by JimKnicely » Mon Feb 08, 2016 8:24 pm

I'd make sure to run /opt/vertica/bin/vioperf on your data directory. Make sure you meet the minimum spec. of 20 MB/s per physical core. I'm always a bit leery of any non bare-metal solutions.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Vertica AWS POCT

Post by chenshaulian » Thu Feb 11, 2016 1:54 pm

Thank you for your answers :)

Post Reply

Return to “Vertica Database Administration”