Hi,
I seem to run into trouble when I try to backup my mysql database
servers and the dump takes longer then 2 hours. I dont have a lot of
large databases, but a couple with some large tables. This is the case
on every single backup attempt i've had. (For the job status/run
report please see the end of the email).
Seems that because mysqldump doesnt output anything while dumping
those tables, that it just times out. I wrote the mysql_backup.sh
wrapper script to mysqldump
Note that I do have:
Heartbeat Interval = 300 # 5 min
set in the director (both in director and storage directives), file
and storage daemons.
Is there something that I'm missing? Should I consider doing the dumps
on cron a 3-4 hours before beginning the backup with bacula? Are there
any other suggestions out there?
Thanks for the help!
Regards,
Renato
Ah, and here is a sample output/report from bacula I get on email:
17-May 23:05 backupsrv-dir JobId 12726: No prior Full backup Job record found.
17-May 23:05 backupsrv-dir JobId 12726: No prior or suitable Full
backup found in catalog. Doing FULL backup.
18-May 09:07 backupsrv-dir JobId 12726: Start Backup JobId 12726,
Job=dbserver-mysql.2010-05-17_23.05.02_42
18-May 09:07 backupsrv-dir JobId 12726: Using Device "MySTORAGE"
18-May 09:07 dbserver-fd JobId 12726: shell command: run
ClientBeforeJob "/usr/local/sbin/mysql_backup.sh"
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob:
20100518.090720>> Will flush binary log when dumping data
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob:
20100518.090720>> Removing files older then +1 days:
(...)
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob:
20100518.090720>> Backing up: cdr_db
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: mysql
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob:
20100518.090759>> mysqldump struct of cdr_db
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: -- Connecting
to localhost...
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving
table structure for table buc_buckets...
18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: -- Skipping
dump data for table 'buc_buckets', --no-data was used
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving
table structure for table calls...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Skipping
dump data for table 'calls', --no-data was used
(...)
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: --
Disconnecting from localhost...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob:
20100518.090822>> mysqldump data of cdr_db
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Connecting
to localhost...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving
table structure for table buc_buckets...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Sending
SELECT query...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving rows...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving
table structure for table calls...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Sending
SELECT query...
18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving rows...
18-May 11:08 backupsrv-dir JobId 12726: Fatal error: Socket error on
RunBeforeNow command: ERR=Connection reset by peer
18-May 11:08 backupsrv-dir JobId 12726: Fatal error: Client
"dbserver-fd" RunScript failed.
18-May 11:08 backupsrv-dir JobId 12726: Fatal error: Network error
with FD during Backup: ERR=Connection reset by peer
18-May 11:08 backupsrv-dir JobId 12726: Fatal error: No Job status
returned from FD.
18-May 11:08 backupsrv-dir JobId 12726: Error: Bacula backupsrv-dir
3.0.3 (18Oct09): 18-May-2010 11:08:38
Build OS: x86_64-redhat-linux-gnu redhat Enterprise release
JobId: 12726
Job: dbserver-mysql.2010-05-17_23.05.02_42
Backup Level: Full (upgraded from Incremental)
Client: "dbserver-fd" 3.0.2 (18Jul09)
x86_64-redhat-linux-gnu,redhat,Enterprise release
FileSet: "MySQLDumpFiles" 2010-02-09 21:23:58
Pool: "MySQL-Full" (From Job FullPool override)
Catalog: "MyCatalog" (From Client resource)
Storage: "MySTORAGE" (From Job resource)
Scheduled time: 17-May-2010 23:05:02
Start time: 18-May-2010 09:07:20
End time: 18-May-2010 11:08:38
Elapsed time: 2 hours 1 min 18 secs
Priority: 40
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0 (0 B)
SD Bytes Written: 0 (0 B)
Rate: 0.0 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: no
Volume name(s):
Volume Session Id: 656
Volume Session Time: 1273435024
Last Volume Bytes: 465,870,484 (465.8 MB)
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: Error
SD termination status: Error
Termination: *** Backup Error ***
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|