Re: data backup question
Re: data backup question
- Subject: Re: data backup question
- From: "Musall, Maik" <email@hidden>
- Date: Mon, 15 May 2017 16:48:19 +0200
Hi Ted,
finally a question which I really feel qualified to answer. :)
For the regular filesystem part of it, I have a set of scripts that use rsync to back up to a backup target. The beauty of it is that all it needs is ssh login, with no other dependencies, and you can store the backup to whereever you can go through networking. It uses several advanced rsync features, like backup files for copies of old versions and exclude lists. It also has a pre/post hook where you can put a shell script that is executed before and after the update. That is where I initiate postgresql backup mode and stop it again, so that the filesystem copy of the database is recoverable, should I ever need to go that way.
In addition, I make dialy dumps and pg base backups.
I also use postgresql streaming replication. I have a hot standby on site, and another one off site, tunneled through ssh/vpn. In the case the main server dies and takes the database with it, I would just touch the recovery file on the standby server, which would than take over as new master. Point the new instance there, and you're up again.
I also rsync the filesystem storage of applications to the offsite system every 5 minutes so I have a reasonable current version of that ready there, too.
I don't feel comfortable to post the entire scripts here publicly, but if you want I can email them to you personally.
Maik
> Am 15.05.2017 um 16:36 schrieb Theodore Petrosky <email@hidden>:
>
> Over the past few months I have been experimenting with using hosted systems for my WO apps. I know there are others that are using hosted systems. How are you backing up your data?
>
> Internally it was easy. I ran a script on my Postgresql database, then offsite backed it up with Crashplan.
>
> How are you backing up data, especially when it gets to be a big database?
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden