FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.0 has been released

FromDual has the pleasure to announce the release of the new version 2.3.0 of its popular Backup and Recovery Manager for MariaDB and MySQL (brman).

The new FromDual Backup and Recovery Manager can be downloaded from here. The FromDual Repositories were updated. How to install and use the Backup and Recovery Manager is described in FromDual Backup and Recovery Manager (brman) installation guide.

In the inconceivable case that you find a bug in the FromDual Backup and Recovery Manager please report it to the FromDual Bugtracker or just send us an email.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

Upgrade from 2.x to 2.3.0

shell> cd ${HOME}/product
shell> tar xf /download/brman-2.3.0.tar.gz
shell> rm -f brman
shell> ln -s brman-2.3.0 brman

Changes in FromDual Backup and Recovery Manager 2.3.0

This release is a new major release. The most important new feature is the partial physical restore. We have tried to maintain backward-compatibility with the 1.2, 2.0, 2.1 and 2.2 release series. But you should test the new release seriously!

You can verify your current FromDual Backup Manager version with the following command:

shell> fromdual_bman --version
shell> bman --version
shell> rman --version

General

• Packaging: Release el9 added and debian format increase from 9 to 10 because of debian12.
• Documentation prepared for Asciidoctor.
• Distribtion dependent things fixed.
• Build script improved.
• Typos fixed.
• All print replaced by standard PHP echo commands.
• Redhat replace by Red Hat and CentOS by Rocky Linux.
• Copyright year updated to 2024.
• Library myEnv updated (getDistribution, lsb_release removed).

FromDual Backup Manager (bman)

• Bug in sftp transfer for archiving files fixed.
• Also create subdirectories only once if necessary in physical backup.
• Archive location directory is only created once in physical backup. This avoids errors and makes the backup slightly faster.
• In function createArchiveDestinationDirectory php-ssh2 calls where replaced by the more stable scp/sftp calls.
• Bug in archive destination directory creation fixed and example improved.
• Library LXClib added for testing.
• Number of lines in dump parsing increased because of changes in MySQL 8.0.
• Binlog backup debug output made nicer.
• Retention time increased from 800 days to 1200 days (more than 3 years), tests added for this, newer DB versions added to tests.
• Advices apt-get and yum replace by apt and dnf.
• Error was not returned correctly when bman aborts because of MyISAM tables. Fixed.
• Syntax error fixed.
• flock on fpmmm file added.
• BINLOG MONITOR privilege check added for MariaDB 10.11.
• Code clean-up.
• Example enhanced.
• Output made more clear for trouble shooting (doCleanup).

FromDual Recovery Manager (rman)

• Various bugs fixed found during automated testing.
• Some minor fixes about timing and repeatable testing, warnings and messages improved.
• mariadb_backup_binlog_info case (MariaDB 11.4) added for physical full backup.
• Code refactored and case when backup is compressed caught.
• Function doPhysicalRestore renamed to doFullPhysicalRestore.
• Split restore functions in their own files.
• sql_log_bin is used for schema restore on partial physical restore.
• New example for partial physical restore added.
• New method for partial physical restore implemented.
• Partial physical schema restore added.

Subscriptions for commercial use of FromDual Backup and Recovery Manager you can get from from us.