Protecting HP Vertica Cluster

Availability for the Always-On Enterprise

Protecting HP Vertica Cluster

Veeam Logoby tinto1970 » Thu Oct 20, 2016 8:46 am

Hi everyone,

Vertica is a database cluster used for "big data" https://goo.gl/1PgM0a
From system administrator's point of view, it's a shared-nothing cluster running on linux.

We have installed a 3 node cluster on sles, configured a backup job with VMTools quiescence disabled. It seems that the brief stun during snapshot creation/removal is not tolerated from che Vertica cluster, which shuts down itself.

Naturally the best approach is to reduce the impact of the snapshot on VMs (i.e. upgrading from ESXi5.5 to 6.x, and implementing Storage Snapshot integretion on Veeam), but it's possible that even after the best tuning, the Vertica Cluster will remain "too sensitive". So it will probably necessary to implement a script to put the DB in halted state before backup and restart it later.

Has someone here experience with this particular product?

Thanks in advance.
Alessandro Tinivelli aka Tinto
@tinto1970
tinto1970
Enthusiast
 
Posts: 69
Liked: 25 times
Joined: Thu Sep 26, 2013 8:40 am
Location: Bologna, Italy
Full Name: Alessandro Tinivelli

Re: Protecting HP Vertica Cluster

Veeam Logoby Andreas Neufert » Thu Oct 20, 2016 5:57 pm 1 person likes this post

No, but general rules for SnapShot commit applies here.
Reduce VM disc count (to 1-4), Install ESXi 6 with Feb 2016 Patch level (new Snapshot commit technology), usage of block instead of NFS technology.... as well place all disks incl boot disk on fast storage. Usage of Backup from Storage Snapshot is as well a good ideas as you said. Avoid HotAdd backup mode (with NFS Storage).

Many cluster heartbeats can be tuned as well.
Andreas Neufert
Veeam Software
 
Posts: 2201
Liked: 360 times
Joined: Wed May 04, 2011 8:36 am
Location: Germany
Full Name: @AndyandtheVMs Veeam PM

Re: Protecting HP Vertica Cluster

Veeam Logoby tinto1970 » Wed Oct 26, 2016 8:45 am

Andreas Neufert wrote:No, but general rules for SnapShot commit applies here.
Avoid HotAdd backup mode (with NFS Storage).

Many cluster heartbeats can be tuned as well.


yes i have forced all my proxies in network mode, waiting for the storage snapshot integration.
I have searched the documentation of this database cluster, but i haven't still found any "sensitivity tuning" parameter. I will try asking on their forum.

At the moment we are going to implement a pre/post script to shutdown and restart the db before/after the job. I will post here when done, maybe it could bo useful for someother in future.

thank you for your reply.
Tschüß
Alessandro Tinivelli aka Tinto
@tinto1970
tinto1970
Enthusiast
 
Posts: 69
Liked: 25 times
Joined: Thu Sep 26, 2013 8:40 am
Location: Bologna, Italy
Full Name: Alessandro Tinivelli

Re: Protecting HP Vertica Cluster

Veeam Logoby Kellen.Flood » Tue Jul 25, 2017 2:43 pm

Has anyone had any additional experience with Veeam and Vertica?
Kellen.Flood
Enthusiast
 
Posts: 41
Liked: 3 times
Joined: Fri Apr 19, 2013 8:30 pm
Full Name: Kellen Flood


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: No registered users and 12 guests