Re: [Bacula-users] New Infrastructure Implementation

2008-01-07 Thread Alan Brown
On Fri, 4 Jan 2008, Dan Langille wrote: > I propose this new paragaraph at the top of the page: > > ### > Yes, Bacula supports your tape drive. Bacula does not directly access > hardware. If the tape drive is accessible from your operating system, > then it should just work with Bacula. If you

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread R.I. Pienaar
hey, > - - shut down MySQL > - - initialize LVM snapshot > - - bring up MySQL again > - - back up from the snapshot > - - release snapshot when backup is complete no need to shut the db down, just issue: --- echo "About to lock tables" time (echo "FLUSH TABLES WITH READ LOCK "|mysql) ec

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Dan Langille
Diego Roccia wrote: > On Fri, 2008-01-04 at 16:38 +0100, Michel Meyers wrote: > >>> - Does somebody know something about Bacula support for Dell Tape >>> Libraries? Will I be able to use all the features of my hardware? I >>> didn't find it in Bacula supported libraries page. >> That's because Bac

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Michel Meyers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Diego Roccia wrote: > On Fri, 2008-01-04 at 16:38 +0100, Michel Meyers wrote: > >>> - Does somebody know something about Bacula support for Dell Tape >>> Libraries? Will I be able to use all the features of my hardware? I >>> didn't find it in Bacula

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread R.I. Pienaar
Hello, On 1/4/08, Frank Sweetser <[EMAIL PROTECTED]> wrote: > One thing you should really be aware of, then, is that the practice of > splitting each table out into a set of files is only applicable with MyISAM > tables. Any InnoDB tables will all be stored in the InnoDB table space, which > may

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Frank Sweetser
Diego Roccia wrote: > 4/5 times a week, coders call my db administrator saying "ops, I > dropped/ruined/ate the table X, now I need it as it was yesterday". > So I need to give DB Admin a tool to quickly restore a single table > (read "files") as it was x days ago (with 1 problem is not applicable

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Diego Roccia
On Fri, 2008-01-04 at 17:21 +, R.I. Pienaar wrote: > > > - or use zmanda + LVM to back up your data with bacula pulling the > > > backups from your DB servers to your tape > > It seems cool, but reading from the zmanda site it seems that it support > > tape drives. why do I need bacula, too?

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread R.I. Pienaar
hello, > > You should investigate: > > > > - using LVM to store your databases on > Are you talking about using LVM snapshot feature? It's a little > difficult because we need to modify filesystem on production servers yeah, that gives you the shortest downtime with the quickest restore option f

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Diego Roccia
On Fri, 2008-01-04 at 15:53 +, R.I. Pienaar wrote: > On 1/4/08, Michel Meyers <[EMAIL PROTECTED]> wrote: > > > - I will need to stop mysql slave before and restart it after backup. I > > > read the documentation but something is still not clear for me. Can I > > > execute a "script on client b

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Diego Roccia
On Fri, 2008-01-04 at 10:42 -0500, Frank Sweetser wrote: [...] > Check out the > Client Run Before Job > > and > > Client Run After Job > > directives in the manual. > > http://bacula.org/rel-manual/Configuring_Director.html ok, thanks. I'll check it. Regards Diego --

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Diego Roccia
On Fri, 2008-01-04 at 16:38 +0100, Michel Meyers wrote: > > - Does somebody know something about Bacula support for Dell Tape > > Libraries? Will I be able to use all the features of my hardware? I > > didn't find it in Bacula supported libraries page. > > That's because Bacula doesn't directly n

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread R.I. Pienaar
On 1/4/08, Michel Meyers <[EMAIL PROTECTED]> wrote: > > - I will need to stop mysql slave before and restart it after backup. I > > read the documentation but something is still not clear for me. Can I > > execute a "script on client before" and a "script on client after" and > > start the backup o

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Frank Sweetser
Diego Roccia wrote: > Hi all, > For my company we need to implement bacula as backup software. In a > previous thread I've explained the infrastructure, and now I have more > information on the hardware we are going to implement. > > +--+ +--+ > | MySQL| |

Re: [Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Michel Meyers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Diego Roccia wrote: > Hi all, > For my company we need to implement bacula as backup software. In a > previous thread I've explained the infrastructure, and now I have more > information on the hardware we are going to implement. > [...] > > My que

[Bacula-users] New Infrastructure Implementation

2008-01-04 Thread Diego Roccia
Hi all, For my company we need to implement bacula as backup software. In a previous thread I've explained the infrastructure, and now I have more information on the hardware we are going to implement. +--+ +--+ | MySQL| |MySQL | | Master | |