[Bacula-users] Compiling problems on AIX 5.2
I have tried to compile bacula 1.36.3 (22 April 2005) on AIX 5.3.0.0 with mysql (server, client, devel) installed from the AIX rpm's. Using the following command: ./configure \ --enable-smartalloc \ --sbindir=/opt/bacula/bin \ --sysconfdir=/opt/bacula/bin \ --with-pid-dir=/opt/bacula/bin/working \ --with-subsys-dir=/opt/bacula/bin/working \ --with-working-dir=/opt/bacula/working \ --with-mysql and I got the follwing output: - (...) Doing make of dependencies make: *** No rule to make target `depend'. Stop. Configuration on Thu Sep 1 15:40:24 DFT 2005: Host: powerpc-ibm-aix5.3.0.0 -- aix 3 Bacula version: 1.36.3 (22 April 2005) Source code location: . Install binaries: /opt/bacula/bin Install config files: /opt/bacula/bin Scripts directory: /opt/bacula/bin Working directory: /opt/bacula/working PID directory: /opt/bacula/bin/working Subsys directory: /opt/bacula/bin/working C Compiler: gcc 3.3.2 C++ Compiler: g++ 3.3.2 Compiler flags: -g -O2 -Wall Linker flags:-O Libraries: -lpthread Statically Linked Tools:no Statically Linked FD: no Statically Linked SD: no Statically Linked DIR: no Statically Linked CONS: no Database type: MySQL Database lib: -L/usr/lib/mysql -lmysqlclient_r -lz Job Output Email: [EMAIL PROTECTED] Traceback Email:[EMAIL PROTECTED] SMTP Host Address: localhost Director Port: 9101 File daemon Port: 9102 Storage daemon Port:9103 Director User: Director Group: Storage Daemon User: Storage DaemonGroup: File Daemon User: File Daemon Group: SQL binaries Directory /usr/bin Large file support: no Bacula conio support: yes -lcurses readline support: no TCP Wrappers support: no ZLIB support: yes enable-smartalloc: yes enable-gnome: no enable-wx-console: no enable-tray-monitor: client-only:no ACL support:no - Then I tried doing 'make' but that failed. I have had bacula running on a linux server very succesfully for years. Now that we switched over to (new) IBM servers I hope to continue using bacula on AIX. I am an AIX newbe, so any hint is very welcome! Tia Daniel PS: I already searched the archives for hints, but found nothing useful on AIX 5.2 -- Daniël Kropveld Medial Automatisering tel: 023 890 8688 gsm: 0644 - 112344 [EMAIL PROTECTED] [EMAIL PROTECTED] --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] right solution for backup MySQL databases
Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :) --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] right solution for backup MySQL databases
Dmitry S. Vlasov wrote: Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :) mysqldump? Indeed, Bacula will use mysqldump to backup it's catalog database if you are using MySQL for that purpose. You can even use the make_catalog_backup script as a template. Rowdy --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] right solution for backup MySQL databases
Hello, Dmitry S. Vlasov wrote: Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :) There are different options, and which one is best for you depends on your needs. - You could use a run before script that stops the databse and a run after script to start it again. This makes database access unpossible during backup, obviously, and when using the same database server for your backup that's not really an option. - You could use a snapshop, but this doesn't guarantee a consistent state of the database before backup, it only lowers the risk of the database changing during backup and thus creating an inconsistent backup. - Use mysqldump to dump the database(s) to a file or sucket you then store. The options --lock-tables and --single-transaction could be useful - mysqlhotcopy could also be used. - Using any of the above, you could inform your applications that the database is to be modified and they have to keep their fingers off it. Arno --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- IT-Service Lehmann[EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
Hello, On Fri, 2 Sep 2005, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. You can't. i dont want to dump the mysql-dbs before the backup, because this would take days... Make a MysQL slave server and do a fulldump each month (or week) and then backup all binlogs every day. --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] right solution for backup MySQL databases
Arno Lehmann wrote: Hello, Dmitry S. Vlasov wrote: Hello! Can anyone tell me right solution for backup MySQL databases (MyISAM and InnoDB) without slave server ( i mean without any replication) and without stopping service? How I feel, backup binary files on-the-fly is realy bad idea :) There are different options, and which one is best for you depends on your needs. - You could use a run before script that stops the databse and a run after script to start it again. This makes database access unpossible during backup, obviously, and when using the same database server for your backup that's not really an option. In one situation I can stop/start mysqld before/after job... I add folowing in my job: Client Run Before Job = /usr/local/etc/rc.d/mysql-server.sh stop Client Run After Job = /usr/local/etc/rc.d/mysql-server.sh start and see: 244 Increme pluto.2005-09-02_15.11.32 has terminated for a long time then I run /usr/local/etc/rc.d/mysql-server.sh stop on the remote host - and in the same time jod finish. next I insert exit 0; in /usr/local/etc/rc.d/mysql-server.sh for both stop and start but still have 'frozen' job :( Do you have any idea ? - You could use a snapshop, but this doesn't guarantee a consistent state of the database before backup, it only lowers the risk of the database changing during backup and thus creating an inconsistent backup. - Use mysqldump to dump the database(s) to a file or sucket you then store. The options --lock-tables and --single-transaction could be useful - mysqlhotcopy could also be used. - Using any of the above, you could inform your applications that the database is to be modified and they have to keep their fingers off it. Arno --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
Hi, Jonas Björklund wrote: Hello, On Fri, 2 Sep 2005, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. You can't. what do you mean, that i cannot ? I can copy the files perfectly on linux and i cant perfectly restore them. the question is what the risk it... Greetings, Philipp --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Backup Mysql Database Files
Hi, if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. i dont want to dump the mysql-dbs before the backup, because this would take days... so, do i risk corrupted mysql-dbs or do i just risk to miss a query ? best regards, Philipp --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
Dan Langille wrote: On 2 Sep 2005 at 14:16, Philipp Steinkrueger wrote: Dan Langille wrote: On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. i dont want to dump the mysql-dbs before the backup, because this would take days... How large is your database? well, actually its more than one database. its a lamp system running dozens of databases. dumping them all would really eat up a lot of time... How much time? I ask because it sounds like you are assuming and have not actually tried it. My usual stance is: What is more important to you? a fast backup or a reliable backup? you are right, i have not actually tried it with this database server, but i have experience with other projects running on even faster servers. the server i need to backup now is always under heavy load and dumping would take a long time. even if it would be sitting around lazy it would take time to write several GB (around 6 at the moment) of data to disk... greetings, philipp --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
On 2 Sep 2005 at 14:16, Philipp Steinkrueger wrote: Dan Langille wrote: On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. i dont want to dump the mysql-dbs before the backup, because this would take days... How large is your database? well, actually its more than one database. its a lamp system running dozens of databases. dumping them all would really eat up a lot of time... How much time? I ask because it sounds like you are assuming and have not actually tried it. My usual stance is: What is more important to you? a fast backup or a reliable backup? -- Dan Langille : http://www.langille.org/ BSDCan - The Technical BSD Conference - http://www.bsdcan.org/ --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
On 9/2/05, Philipp Steinkrueger [EMAIL PROTECTED] wrote: Hi, if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. stop tha database and then copy all database files or schedule mysqldump --all-databases to run daily (or as often as you want...) The dump is very fast and will not require downtime. Reagrds, Umberto i dont want to dump the mysql-dbs before the backup, because this would take days... so, do i risk corrupted mysql-dbs or do i just risk to miss a query ? best regards, Philipp --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. I believe most databases are not safe to backup in this manner. i dont want to dump the mysql-dbs before the backup, because this would take days... If you're using LVM, you might (a) stop mysql, (b) create a LVM snapshot, and (c) restart mysql. The (b) step is fast since it does not make a full copy of the original, it just stores reverse differences, so after (c) you can happily have bacula read off the snapshot, which you'll delete when done. Note that the above is not a scheme I've actually tried, but I've had it on my to do queue for a while and from what I've read it ought to work. A wilder idea involves dumping to a FIFO, which Bacula can be instructed to read from when doing backups, although I do not have yet worked out how restore would happen in this case. Hope this helps, Davide Bolcioni -- Paranoia is a survival asset. --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Alternative PDF version of Bacula manual with section numbering
I have volunteered to edit the Bacula documentation. One of the first things I am doing is adding chapter and section numbering to the PDF versions of the manuals. These changes will not be committed to CVS before the second half of September and will probably not make it to the documentation on the Bacula web site until some time after that. People may find the new version of the manual easier to navigate, so I have put my latest PDF version (with section numbering, formatted for A4 paper) up on my web site, at: http://refcards.com/bacula/ In terms of content it is identical to the version on www.bacula.org -- its just the formatting that is different. Feedback is welcome. Enjoy! Andrew -- Andrew Ford, DirectorPauntley Prints / Ford Mason Ltd [EMAIL PROTECTED] South Wing Compton House pauntley-prints.co.uk Compton Green, Redmarley Tel: +44 1531 829900 ford-mason.co.uk Gloucester GL19 3JB Fax: +44 1531 829901 refcards.com cronolog.org Great Britain Mobile: +44 7785 258278 --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Compiling problems on AIX 5.2
On Fri, 2 Sep 2005 08:33:33 +0200 (CEST), Daniel Kropveld [EMAIL PROTECTED] said: Daniel I have tried to compile bacula 1.36.3 (22 April 2005) on AIX 5.3.0.0 Daniel with mysql (server, client, devel) installed from the AIX rpm's. Daniel Using the following command: Daniel ./configure \ --enable-smartalloc \ --sbindir=/opt/bacula/bin \ --sysconfdir=/opt/bacula/bin \ --with-pid-dir=/opt/bacula/bin/working \ --with-subsys-dir=/opt/bacula/bin/working \ --with-working-dir=/opt/bacula/working \ --with-mysql Daniel and I got the follwing output: Daniel - Daniel (...) Daniel Doing make of dependencies Daniel make: *** No rule to make target `depend'. Stop. Were there any other signs of trouble before this? In particular, did it say 'creating Makefile'? I'm not sure if it will help, but are you using GNU make or AIX's make (try running make -v)? GNU make might work better with Bacula's Makefile. I think you do that by setting the environment variable MAKE to the path of GNU make. __Martin --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
RE: [Bacula-users] Backup Mysql Database Files
On 2 Sep 2005 at 15:22, Heigl Florian - Munich-MR - e wrote: How much time? I ask because it sounds like you are assuming and have not actually tried it. [ I think in general it's not bad to think about things impact before trying :) ] Worthwhile. But one must also act with facts. Try it. One might be surprised. I regularly backup large online databases by dumping the file to text. If someone says: it takes 72 hours to dump my database to disk, and that's too long, THEN we have something tangible to work with. -- Dan Langille : http://www.langille.org/ BSDCan - The Technical BSD Conference - http://www.bsdcan.org/ --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] schedule resource
Hi, Just a question about the schedule resource. If the Pool directive is not defined like in # This schedule does the catalog. It starts after the WeeklyCycle Schedule { Name = WeeklyCycleAfterBackup Run = Full sun-sat at 1:10 } ...does it mean that it uses the Default pool? Thanks, Maurizio --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
Dan Langille wrote: On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. i dont want to dump the mysql-dbs before the backup, because this would take days... How large is your database? well, actually its more than one database. its a lamp system running dozens of databases. dumping them all would really eat up a lot of time... so, do i risk corrupted mysql-dbs or do i just risk to miss a query ? I *always* suggest dumping the database and going from there. If this isn't an option, I suggest following up on the MySQL project with suggestions. allright, thanx, Philipp --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You only can copy the database files for mysql if table type is MyISAM. If you use innodb, only dump or using software InnoDB Hot Backup (it is not GPL). You can dump with lock database (is available only for queries in this time) for prevent not integrity corrupted. - -- Jeronimo Zucco LPIC-1 Linux Professional Institute Certified Núcleo de Processamento de Dados Universidade de Caxias do Sul May the Source be with you. - An unknown jedi programmer. http://jczucco.blogspot.com Philipp Steinkrueger wrote: Hi, Jonas Björklund wrote: Hello, On Fri, 2 Sep 2005, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. You can't. what do you mean, that i cannot ? I can copy the files perfectly on linux and i cant perfectly restore them. the question is what the risk it... Greetings, Philipp --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFDGEGhTCq0VJ4DIPwRAlAoAKDjgoQovmT2mONn4eEHWx78YJlJcgCdF80Z tKYR1Ytfc4yFuqYJNfXl+Po= =1aik -END PGP SIGNATURE- --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Mysql Database Files
On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote: if i want to backup a server running a mysql-db and i just backup all the mysql-db-files, do i risk to save a corrupted version? i read in the manual about the VSS problematic and save state in RDBMS on windows, but in my case, the mysql db runs on linux. i dont want to dump the mysql-dbs before the backup, because this would take days... How large is your database? so, do i risk corrupted mysql-dbs or do i just risk to miss a query ? I *always* suggest dumping the database and going from there. If this isn't an option, I suggest following up on the MySQL project with suggestions. -- Dan Langille : http://www.langille.org/ BSDCan - The Technical BSD Conference - http://www.bsdcan.org/ --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
RE: [Bacula-users] Backup Mysql Database Files
How much time? I ask because it sounds like you are assuming and have not actually tried it. [ I think in general it's not bad to think about things impact before trying :) ] My usual stance is: What is more important to you? a fast backup or a reliable backup? you are right, i have not actually tried it with this database server, but i have experience with other projects running on even faster servers. the server i need to backup now is always under heavy load and dumping would take a long time. even if it would be sitting around lazy it would take time to write several GB (around 6 at the moment) of data to disk... Could You possible create a solution like one of the following for reducing performance penalty during backup: - run mysqldump with extremely high nice value to a different disk spindle - stop mysql for a few seconds, create a filesystem snapshot, restart it and save the snapshot (this of course depends on the filesystem type You're using and if You want to add an additional script to Your backup procedure. florian --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Core dump with 1.36.3 on FreeBSD 5.4, Fatal Error because: Bacula interrupted by signal 10: BUS error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I noticed someone else had the same error a couple months ago. My test server's director died this morning mid-backup with the BUS error in the subject: Fatal Error because: Bacula interrupted by signal 10: BUS error It's running on a Pentium machine, backing up five clients. Everything else kept running fine, only the director died. It isn't 64-bit or non-Intel CPU. I'm not sure off the top of my head about the chipsets. Could this be due to RAM? The machine isn't particularly beefy, but has been running okay for a few weeks now. Josh -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.0 (FreeBSD) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDGHYfV/+PyAj2L+IRAqLbAJ9mkHxDrriNOSG0lL2wPMA6bJTCQQCglxC6 yH4neTvrxIq53oTyPD5i4z0= =EX/a -END PGP SIGNATURE- --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula performance
Hello all, I finally found a solution to speed up the performance dramatically: In the FileDaemon resource I set Maximum Network Buffer Size = 65536 (instead of the default 32k). Now I get ~3MB/sec, which is reasonable. Thanks for all assistance, Uwe Am 31.08.2005 um 18:28 schrieb Uwe Hees: Hello, Am 30.08.2005 um 18:15 schrieb Kern Sibbald: Perhaps you didn't read the ReleaseNotes where I indicate that SQLite3 in my tests was 4 to 10 times slower than SQLite 2. Try SQLite 2 or MySQL. I used sqlite3 mainly because it came preinstalled with MacOS 10.4. Meanwhile I have installed MySQL for other reasons and tried bacula with it. The result was a double in performance up to ~120kB/sec. While running the backup job I noticed that netstat reported 32768 entries in the send queue of the bacula-fd. I tried to backup to a remote sd (running under Linux on a 200Mhz/PPC603e, i.e. not a powerful box) and got ~520kB/sec. Am 30.08.2005 um 20:46 schrieb Arno Lehmann: Also, don't forget that notebook HDs (2.5) are usually a lot slower than than desktop or even server disks... and in backing up the same machine, you use the slow disk three times: reading, writing, database. The disk has a random read/write performance of about 10 MB/sec. Now, I don't have disk performance comparisons between an iBook and a more typical server setup, but I'd bet that the iBook is really slow in comparison... about 650 kB/s is what I get storing the (dumped) catalog database on my backupserver - the server is slower than your iBook, but still this is what the tape drive can handle - but this server only does the backups, the catalog is on another machine, and there are no other processes using lots of memory or bus throughput. In short: Try it with a setup which resembles your planned use of bacula, and with some consideration you will get good results. Backing up my (and my wife's) notebook to an external disk is exactly what I intend to do at home. There's no tape drive involved. As for the company, the backup tape drive is not yet purchased. Greetings, Uwe --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] schedule resource
On Fri, Sep 02, 2005, Maurizio Santini wrote: Hi, Just a question about the schedule resource. If the Pool directive is not defined like in # This schedule does the catalog. It starts after the WeeklyCycle Schedule { Name = WeeklyCycleAfterBackup Run = Full sun-sat at 1:10 } ...does it mean that it uses the Default pool? No, it uses the pool that is defined in the Job resource. If no pool is defined, you get an error. I just tried it. Actually, Pool is a required directive in the Job resource. There is no default. You have to specify one, even when you plan to override it in the Schedule resource. (mk) -- Matthias Kurz; Fuldastr. 3; D-28199 Bremen; VOICE +49 421 53 600 47 Im prämotorischen Cortex kann jeder ein Held sein. (bdw) --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] schedule resource
Maurizio Santini wrote: Hi, Just a question about the schedule resource. If the Pool directive is not defined like in # This schedule does the catalog. It starts after the WeeklyCycle Schedule { Name = WeeklyCycleAfterBackup Run = Full sun-sat at 1:10 } ...does it mean that it uses the Default pool? Yes, unless otherwise specified in the Job resource or a JobDefs resource. -- Phil Stracchino [EMAIL PROTECTED] Renaissance Man, Unix generalist, Perl hacker Mobile: 603-216-7037 Landline: 603-886-3518 --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users