Re: data backup question
Re: data backup question
- Subject: Re: data backup question
- From: Theodore Petrosky <email@hidden>
- Date: Mon, 15 May 2017 13:36:35 -0400
it sounds fair to say you are comfortable with shell scripts. I only dabbled a bit in college and really never went that far :)
I am using a script to launch on startup the WO pieces (wotaskd and JavaMonitor). I was playing with the script and added a ‘status’ section. I could only think of an if statement checking if the PID was > 1 to see it they were running.
Is that bad?
status)
WOTASKD_PID=`ps aux | awk '/WOPort 1085/ && !/awk/ {print $2}'`
if [ $WOTASKD_PID > 1 ]; then
echo -e "wotaskd is running with PID " $WOTASKD_PID
else echo "wotaskd in not running"
fi
MONITOR_PID=`ps aux | awk '/WOPort 56789/ && !/awk/ {print $2}'`
if [ $MONITOR_PID > 1 ]; then
echo -e "JavaMonitor is running with PID " $MONITOR_PID " \n"
else echo "JavaMonitor in not running"
fi
;;
> On May 15, 2017, at 10:48 AM, Musall, Maik <email@hidden> wrote:
>
> 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
_______________________________________________
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