List:Cluster« Previous MessageNext Message »
From:Joshua Gordon Date:October 8 2010 5:35pm
Subject:RE: changing the location of online backup.
View as plain text  
This is good advice. The real issue is when upgrading my cluster to new HD's we have run
into an issue with a specific query. I have reported this to the support at mysql but have
not found a solution. So I am a bit concerned and do not want to upgrade my primary
cluster drives until I get the other issue resolved. The NFS is actually a connection to a
large storage array are you suggesting a fiber san? Do you have any other suggestions?

Thanks Joshua Gordon

-----Original Message-----
From: Hartmut Holzgraefe [mailto:hartmut.holzgraefe@stripped] 
Sent: Friday, October 08, 2010 1:36 AM
To: cluster@stripped
Subject: Re: changing the location of online backup.

On 10/08/2010 09:27 AM, Geert Vanderkelen wrote:

> IMHO, you should backup locally, then copy. NFS might fail and it
 > might take to much bandwidth, which might cause data node failure.
> Also, I think it's good to keep the last backup locally on disk.
 > Just incase you need to restore and need to do it fast.

agree ... personally i'd store backups locally first and use
rsync (with --bwlimit option to make sure that the network is
not saturated by this -> so it does not affect latency in cluster
node communication) to have centralized copies of the backups
for the case that a data nodes local disk fails.

Or use a reliable shared SAN device ... NFS i'd personally not
trust enough for this either ...

Hartmut Holzgraefe | MySQL Regional Support Manager, EMEA

Phone: +49-2102-4511-0
Oracle MySQL Support

ORACLE Deutschland B.V. & Co. KG | Brandenburger Straße 2 | 40880 Ratingen

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven

MySQL Cluster Mailing List
For list archives:
To unsubscribe:

changing the location of online backup.Joshua Gordon7 Oct
  • Re: changing the location of online backup.Geert Vanderkelen8 Oct
    • Re: changing the location of online backup.Hartmut Holzgraefe8 Oct
      • RE: changing the location of online backup.Joshua Gordon8 Oct
        • Re: changing the location of online backup.Geert Vanderkelen11 Oct