On 23 Feb 2012, at 00:50, Jérôme Blion wrote:
> On Wed, 22 Feb 2012 15:13:26 +0000 (GMT), Joe Nyland wrote:
>> On 22 Feb, 2012,at 02:11 PM, Jérôme Blion wrote:
>>
>>> On Wed, 22 Feb 2012 08:29:22 -0500, John Drescher wrote:
>>> > 2012/2/22 :
>>> >>
>>> >> Hi,
>>> >>
>>> >> I'm in the process of setting up MySQL backups in Bacula, using
>>> >> mysqldump
>>> >> for full backups and backing up my bin logs for incremental
>>> backups.
>>> >>
>>> >> What I would like to do is to perform a full backup to my full
>>> >> backup pool
>>> >> at 00:00 every night, then perform incremental backups to my
>>> >> incremental
>>> >> pool every hour thereafter.
>>> >>
>>> >> Just as a rough config, I have the current schedule at the
>>> moment,
>>> >> whilst
>>> >> testing:
>>> >>
>>> >> Schedule {
>>> >> Name = "TestServer MySQL Database Schedule"
>>> >> Run = Level=Full pool=TestServer_MySQL_Full
>>> >> Storage=TestServer_MySQL_Full
>>> >> daily at 00:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 01:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 02:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 03:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 04:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 05:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 06:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 07:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 08:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 09:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 10:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 11:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 12:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 13:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 14:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 15:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 16:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 17:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 18:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 19:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 20:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 21:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 22:00
>>> >> Run = Level=Incremental pool=TestServer_MySQL_Inc
>>> >> Storage=TestServer_MySQL_Inc daily at 23:00
>>> >> }
>>> >>
>>> >> I feel that there must be another, cleaner, way to define this
>>> kind
>>> >> of
>>> >> backup schedule, but I can't seem to be able to find one from
>>> the
>>> >> manual.
>>> >>
>>> >
>>> > You could make the default level Incremental and the default Pool
>>> > TestServer_MySQL_Inc in your Job and cut all overrides but the
>>> full
>>> > however I would leave this alone. Your schedule is fine.
>>> >
>>> > John
>>>
>>> Hello,
>>>
>>> As far as I see, you only have 2 pools, one for each type.
>>> Why don't you use hourly keyword to schedule incrementals backups ?
>>>
>>> HTH.
>>> Jérôme Blion.
>>>
>>>
>> ------------------------------------------------------------------------------
>>> Virtualization & Cloud Management Using Capacity Planning
>>> Cloud computing makes use of virtualization - but cloud computing
>>> also focuses on allowing computing to be delivered as a service.
>>> http://www.accelacomm.com/jaw/sfnl/114/51521223/ [2]
>>> _______________________________________________
>>> Bacula-users mailing list
>>> Bacula-users@lists.sourceforge.net [3]
>>> https://lists.sourceforge.net/lists/listinfo/bacula-users [4]
>>
>> Jérôme and John, thank you for your replies.
>>
>> Jérôme, yes that's right. For this type of job and this schedule, I
>> am dealing with two pools. I am aware of the hourly keyword. Whilst
>> this keyword appears to be just what I need, my concern with using it
>> is that at 00:00, I would get a full backup initiated by my schedule,
>> but also an incremental backup at 00:00 too, due to the hourly
>> keyword, would I not?
>>
>> Kind regards,
>>
>> Joe
>
> Several points which could help you:
> - Incremental hourly at 0:17 ==> just plan the incremental few minutes before
> the full starts.
> - in the script to run, just return 0 if the full backup is already runnning.
> - The schedule won't start if another instance is running. Perhaps you could
> create 2 schedules...
>
> HTH.
> Jérôme Blion.
Thanks for your suggestions, but I'm not sure I understand them fully, I'm
afraid. However, I think I can deduce that there's no tidy way of achieving
this.
I was hoping there would be some ability to specify a range for the hourly
keyword, however it seems there's not.
Still, I can't complain :-)
If anyone has any other suggestions, please let me know.
Thanks again,
Joe
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
