I have backups located on distributed file system (MooseFS) so the way as automysqlbackup works now means:
1 - create db dump file
- uplaod by net to various servers
2 - compress this file to bz2
- download from dfs
- upload again compressed version
- delete uncompressed file
That means large overload of transfers used to make single backup
I modified automysqlbackup source that it use stdin of bzip2
first - disable build in compression (COMP=none)
then modify function dbdump () so now it looks like this:
I have backups located on distributed file system (MooseFS) so the way as automysqlbackup works now means:
1 - create db dump file
- uplaod by net to various servers
2 - compress this file to bz2
- download from dfs
- upload again compressed version
- delete uncompressed file
That means large overload of transfers used to make single backup
I modified automysqlbackup source that it use stdin of bzip2
first - disable build in compression (COMP=none)
then modify function dbdump () so now it looks like this:
Additionally i added nice commands to make it better work in background not disturbing other processes.
Hope it helps to someone and in future versions it will be included in standard script.
Anyway, great work.