888334 - Backup storage location for Tableau Server

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[bsullins]

Part of the continuity plan for Tableau Server is to store backups of the server in another location then the server itself. Please create such a storage location and provide SCP access so I may script copying the nightly backups to this location. I estimate we need 40GB for now. Each backup is about 3GB and we store 7 days at a time. Please let me know if you have any questions!

Comment 1

[Ludovic Hirlimann [:Usul]]

Where's the server situated  phx or scl3 ?

Comment 2

[bsullins]

tableau1.metrics.scl3.mozilla.com

Comment 3

[bsullins]

Any update on this?

Comment 4

[Ludovic Hirlimann [:Usul]]

oulan:metrics ludo$ svn diff
Index: nodes.pp
===================================================================
--- nodes.pp	(revision 70448)
+++ nodes.pp	(working copy)
@@ -178,6 +178,12 @@
 
     include tableau::portal
 }
+node "tableau1.metrics.scl3.mozilla.com" {
+    class {
+      'netvault':
+         netvault_ports     => '20031-21031',
+    }
+}
 
 node /^bandar.stage.metrics.scl3.mozilla.com$/{
   include ldap_users::com

Adding the client on the machine in r70449

Comment 5

[Ludovic Hirlimann [:Usul]]

Q what's the beast way to remote access the machine and what credentials can I use to install a backup client there ?

Comment 6

[Ludovic Hirlimann [:Usul]]

(In reply to Ludovic Hirlimann [:Usul] from comment #5)
> Q what's the beast way to remote access the machine and what credentials can
> I use to install a backup client there ?

Comment 7

[Q]

.\administrator
 password is set to the same password as the tableau bind user password ( in sysadmins file)

Comment 8

[Ludovic Hirlimann [:Usul]]

Ben client is running on it now. Do you want us to backup C:\tableau-backups ? Is that what needs to be backed up ? At what frequency are you creating those backups ?

Comment 9

[bsullins]

Hi Ludovic,

Is it possible to take full-disk backups? If not this directory will be fine and I will schedule nightly backups of tableau to be created in that location.

Thanks,
Ben

Comment 10

[Ludovic Hirlimann [:Usul]]

(In reply to bsullins from comment #9)
> Hi Ludovic,
> 
> Is it possible to take full-disk backups? If not this directory will be fine
> and I will schedule nightly backups of tableau to be created in that

We usually don't do that - but we don't have much windows servers so for this time I'll save the full disk.

Comment 11

[Ludovic Hirlimann [:Usul]]

First full of c:\ completed.