Firebird Support Service

Monitoring of Firebird database and automation of backups

The qualified IBSurgeon DBAs will setup Firebird backups, tune configuration, and install monitoring tools (license is included in the subscription). They will permanently monitor important Firebird parameters to prevent failures and outages.
All kinds of backups (full, incremental, cloud/FTP backup, VM level backup, and their combination) are supported.
In case of any problems with Firebird database or its backups, with the server environment, or errors in the database log, the monitoring tool will send appropriate alerts.
Proactive monitoring allows the fixing of all issues before they become critical.

Remote desktop and instant messenger support

In a case of a serious problem, our engineers will connect to the server through a remote desktop (TeamViewer, SSH, RDP, etc), or communicate through instant messenger (Skype, etc) and resolve any Firebird problem with configuration, maintenance, or recovery.

Our DBAs also perform all necessary maintenance operations: backup (normally it is automated, but sometimes it requires manual operations), restore, sweep automation and its control, a monthly analysis of database statistics and applying updates for Firebird and IBSurgeon software. Backups, restores, and monthly analysis is made according to a database maintenance plan, developed in collaboration with the customer, and approved by both customer and IBSurgeon.

 

Failover Firebird solution

HQbird Enterprise toolset is included in the support subscription: it is the reliable and easy way to set up a failover solution for Firebird, based on the native asynchronous replication. The failover solution does not require changes in the database structure (no triggers, etc), the only requirement is the primary or unique key for replicated tables.
With HQbird Enterprise it is possible to set up a mirror (warm standby) of the production database, on the one or several replica servers, with close to real-time synchronization, in the local network or in the distributed environment.

Such a mirror can protect from the following problems:

1. Hardware failures. In the case of hardware failure on the main server which led to database corruption, it is possible to switch to the second server or restore a database from standby without losses of data.
2. Ransomware or another virus attack – the mirror of the database is stored on the backup server, or at IBSurgeon premises ( free option)
3. Human factor/maladministration. Even if the main database or server will be intentionally destroyed, there will be a reliable offsite copy.