On Monday, September 12, 2016 at 8:53:47 PM UTC+2, Sean Beckett wrote:
> Backups are documented here: 
> http://docs.influxdata.com/influxdb/v1.0/administration/backup_and_restore/
> 
> 
> They are always full backups, so there's nothing more complex to the backup 
> strategy than what you describe. Backups can be run against a live instance.
> 
> 
> > Also what stops me from doing rsync on the directories used by InfluxDB?
> 
> 
> Race conditions. Memory and files are changing all the time. Rsync doesn't 
> grab a cohesive snapshot of the full directory, it merely grabs the latest 
> version of each file serially. There is very little chance that grabbing 
> files serially will produce a consistent backup unless the cluster is under 
> extremely low load. Even then, I think it's unlikely restoring an rsync'd 
> copy would work more than half the time.
> 
> 
> On Mon, Sep 12, 2016 at 12:41 PM,  <[email protected]> wrote:
> Hey, I am interested using InfluxDB in production but cant afford the 
> Enterprise/Cloud products.
> 
> 
> 
> So I am interested in ways to ensure I wont lose data when going live.
> 
> 
> 
> What are you doing regarding backups? Care to share your scripts?
> 
> 
> 
> 
> 
> Is it as basic as this?
> 
> 
> 
> S1: influxd backup /path/to/metadata
> 
> S1: influxd backup -database mydatabase /path/to/backup
> 
> S2: influxd restore /tmp/backup
> 
> S2: influxd restore -database mydatabase /tmp/backup
> 
> 
> 
> 
> 
> Also what stops me from doing rsync on the directories used by InfluxDB? I 
> could keep a second server in sync (without the process running) and if 
> something happens to master I could simply do "service start influxdb" on the 
> second server to get up and running without doing any backup restores.
> 
> 
> 
> Thanks
> 
> 
> 
> --
> 
> Remember to include the InfluxDB version number with all issue reports
> 
> ---
> 
> You received this message because you are subscribed to the Google Groups 
> "InfluxDB" group.
> 
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to [email protected].
> 
> To post to this group, send email to [email protected].
> 
> Visit this group at https://groups.google.com/group/influxdb.
> 
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/influxdb/f4e45893-3a7a-4a19-85ff-26096a9ed706%40googlegroups.com.
> 
> For more options, visit https://groups.google.com/d/optout.
> 
> 
> 
> 
> 
> -- 
> 
> 
> Sean Beckett
> Director of Support and Professional Services
> InfluxDB


Hey Sean, thanks for the answer.

I know about the backup docs but they are not clear enough for me. I come from 
MySQL backups so its a bit confusing for me.

Scenario: My dedicated server burns down, I only have backups and I am planning 
to restore them on a new server.

    1. Does metastore backup continues queries as well? Or I will need to 
re-create them?
    2. Lets say it took me 1 hour to setup the new server. After restoring I 
insert all the missing data for the 1 hour the DB was down. Will CQ process the 
data correctly since its technically from the past?
    3. In the above scenario do I need to do anything else to get a new server 
with 1:1 data as the old one except from the commands below?


S1: influxd backup /path/to/metadata
S1: influxd backup -database mydatabase /path/to/backup
S2: influxd restore /tmp/backup
S2: influxd restore -database mydatabase /tmp/backup


Thanks

-- 
Remember to include the InfluxDB version number with all issue reports
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/7d7be83e-4b99-4e48-b561-bae1e764eb36%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to