For Postgres the Bacula wiki has a nice description that uses the archive
log mode & bpipe. I think that gets along online well.
For MySQL I've also read that some people use dedicated slaves for the
backups.
Imho that's a nice method if you have "more than a little" of data to safe
and no downtim
What do you mean by "online"?
In some environments, this is a synonym for "hot", so I interpret your
question as whether Bacula has any particular specialized interface into
any of these db engines that allows it to copy data in a consistent state.
The answer is "no". What I think most of are do
On Thu, Jan 17, 2013 at 08:52:32AM -0500, Phil Stracchino wrote:
> On 01/17/13 08:33, Uwe Schuerkamp wrote:
> > Could we expect to see better db performance by moving to innodb or
> > one of MariaDB's fancy new backends? I'm especially interested in
> > improving volume recycle times which can be q
On 01/17/13 08:33, Uwe Schuerkamp wrote:
> Could we expect to see better db performance by moving to innodb or
> one of MariaDB's fancy new backends? I'm especially interested in
> improving volume recycle times which can be quite long with our setup
> (200GB file table). the DELETE from File where
On Thu, Jan 17, 2013 at 08:20:48AM -0500, Phil Stracchino wrote:
> One last footnote: *SOLELY* setting MySQL read-only does NOT guarantee
> a consistent backup. You must FLUSH TABLES, and even then you're still
> not 100% safe on InnoDB.
>
Agreed, I forgot that important step in my previous ema
On 01/17/13 04:55, Uwe Schuerkamp wrote:
> On Thu, Jan 17, 2013 at 10:40:26AM +0100, Sven Gehr wrote:
>> Hi@all,
>>
>> is it possible to backu databases e.g. mysql, pgsql (on other hosts)
>> with bacula online?
>
>
> Yes and no. If there are no jobs running you can set the db to read
> only, but
Zitat von Sven Gehr :
> Hi@all,
>
> is it possible to backu databases e.g. mysql, pgsql (on other hosts)
> with bacula online?
There are many different possibilities:
- Use the dump utility of the DB to get a consistent dump to backup
maybe with a ClientRunBeforeJob
- Use the DB provided pos
On Thu, Jan 17, 2013 at 10:40:26AM +0100, Sven Gehr wrote:
> Hi@all,
>
> is it possible to backu databases e.g. mysql, pgsql (on other hosts)
> with bacula online?
>
> --
> Viele Grüsse
>
> Sven Gehr
>
Yes and no. If there are no jobs running you can set the db to read
only, but bacula will
