Re: [Bacula-users] Backup MySQL databases

2011-10-29 Thread Konstantin Khomoutov
On Tue, 25 Oct 2011 17:46:43 -0400 Phil Stracchino wrote: > On 10/25/11 10:41, Konstantin Khomoutov wrote: > >> MySQLdump is a valid technique, and the simplest working technique. > >> You should not, as a rule, back up the MySQL data directory at > >> filesystem level. It is extremely unlikely

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Phil Stracchino
On 10/25/11 21:36, Dan Langille wrote: > > On Oct 25, 2011, at 5:13 AM, Dimitri Gourdon wrote: > >> Hi all, >> >> I have some servers with MySQL databases. I want to know what is the >> best way to backup these databases ? > >> For now, i think i will do mysqldump on each server to local disk a

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Dan Langille
On Oct 25, 2011, at 5:13 AM, Dimitri Gourdon wrote: > Hi all, > > I have some servers with MySQL databases. I want to know what is the > best way to backup these databases ? > For now, i think i will do mysqldump on each server to local disk and > after that, backup that files. Is there a bet

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Phil Stracchino
On 10/25/11 11:03, Jérôme Blion wrote: > With mylvmbackup, you can backup any type of engine which writes on > disk (don't expect to recover memory table...) as long as you flush > buffers to disk. Yup. The issue is that should you get something NOT completely flushed, InnoDB has built in error

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Phil Stracchino
On 10/25/11 10:41, Konstantin Khomoutov wrote: >> MySQLdump is a valid technique, and the simplest working technique. >> You should not, as a rule, back up the MySQL data directory at >> filesystem level. It is extremely unlikely to yield a consistent >> backup. If you're going to attempt this, i

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Jérôme Blion
Hello, On Tue, 25 Oct 2011 07:34:06 -0400, Phil Stracchino wrote: > > MySQLdump is a valid technique, and the simplest working technique. > You > should not, as a rule, back up the MySQL data directory at filesystem > level. It is extremely unlikely to yield a consistent backup. If > you're go

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Konstantin Khomoutov
On Tue, 25 Oct 2011 07:34:06 -0400 Phil Stracchino wrote: [...] > MySQLdump is a valid technique, and the simplest working technique. > You should not, as a rule, back up the MySQL data directory at > filesystem level. It is extremely unlikely to yield a consistent > backup. If you're going to

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Dimitri Gourdon
First, thanks to all for your quick answers. I have read about all your solutions. I think for me, the best way will be a shell script to do local mysqldump on each servers and backup these files after. This solution seems to be the easiest to deploy and maintain on tens of servers. The automy

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Matias Banchoff
¡Hi! you can make a dump of the entire database and then periodically (once per hour, once every two hours, etc) you can backup MySQL's binlogs. Regarding the dump file, it's much better if you dump each database in its own file instead of having only one big file with all the databas

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Phil Stracchino
On 10/25/11 05:13, Dimitri Gourdon wrote: > Hi all, > > I have some servers with MySQL databases. I want to know what is the > best way to backup these databases ? > > For now, i think i will do mysqldump on each server to local disk and > after that, backup that files. Is there a better way ?

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Jeremy Maes
On Tue, 25 Oct 2011 11:13:11 +0200 Dimitri Gourdon wrote: > I have some servers with MySQL databases. I want to know what is the > best way to backup these databases ? > > For now, i think i will do mysqldump on each server to local disk and > after that, backup that files. Is there a better way

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Konstantin Khomoutov
On Tue, 25 Oct 2011 12:03:37 +0200 Alexandre Chapellon wrote: >> I have some servers with MySQL databases. I want to know what is the >> best way to backup these databases ? >> >> For now, i think i will do mysqldump on each server to local disk >> and after that, backup that files. Is there a be

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Konstantin Khomoutov
On Tue, 25 Oct 2011 11:13:11 +0200 Dimitri Gourdon wrote: > I have some servers with MySQL databases. I want to know what is the > best way to backup these databases ? > > For now, i think i will do mysqldump on each server to local disk and > after that, backup that files. Is there a better w

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Pietro Bertera
Hi, 2011/10/25 Dimitri Gourdon : > I have some servers with MySQL databases. I want to know what is the > best way to backup these databases ? You can find useful information at: http://wiki.bacula.org/doku.php?id=application_specific_backups:mysql Regards, -- Bertera Pietro http://www.bertera

Re: [Bacula-users] Backup MySQL databases

2011-10-25 Thread Alexandre Chapellon
Le 25/10/2011 11:13, Dimitri Gourdon a écrit : > Hi all, > > I have some servers with MySQL databases. I want to know what is the > best way to backup these databases ? > > For now, i think i will do mysqldump on each server to local disk and > after that, backup that files. Is there a better way

[Bacula-users] Backup MySQL databases

2011-10-25 Thread Dimitri Gourdon
Hi all, I have some servers with MySQL databases. I want to know what is the best way to backup these databases ? For now, i think i will do mysqldump on each server to local disk and after that, backup that files. Is there a better way ? MySQL module for bacula, backup mysql files (.myd and .