Percona XtraBackup vs. Tivoli Storage Manager

Well suited to databases < 10TB. For larger than this, I would go with snapshots.

Tivoli does well running file-level backups, but Exchange is clunky and restores are really hard. With no SharePoint agent, if you use SharePoint you will need another product like AvePoint DocAve. The web-based GUI console is MUCH improved over earlier versions, but you will still need to be a command-line guru to make Tivoli do everything, and local (node) config files still rule. This product was originally ported from Unix and retains may of its 'nix roots.

Incentivized

• Non-blocking backup : Backup process will not put any lock on the database.
• Fast recovery : As it's a file level backup so it's quite fast in both backup and recovery.
• Consistent backup : Xtrabackup always ensures consistent backup.
• Easy to configure and Use.
• Integration with clouds

• The concept of "forever incremental" is very appealing to my understanding of how backups should happen.
• The backups are tuned for fast restores and they sure are fast.
• The media management is very good.

Incentivized

• The only feature that could use some improvement is partial backup restores. For example, I have a multi-tenant database at the schema level running on a single Percona Server instance. As a tenant grows too large for the share instance or becomes a noisy neighbour we need to move a the tenants schema to its own instance with minimal downtime, meaning that we would run the new instance as a replica with replication filters until failover. In terms of doing a consistent backup, there may be challenges and it is currently possible with XtraBackup, but it would be great if the process was simplified and ensured to be consistent.

• performance degradation in server database backups after upgrades

Incentivized

Not required, company closed. TSM is not used in my current role at my current job.

Incentivized

Takes a bit of getting used to when you first set it up.

Incentivized

If you pay for support it is great, otherwise you have to google.

Incentivized

The few times we've called for support we eventually got an answer, but it's IBM and a very big company and getting to a support agent is hard.

Incentivized

We have evaluated Mysqldump and MySQL Enterprise backup. Mysqldump is not a scalable solution. MEB is a paid and closed source. As we are truly open-source, we were looking for an open-source solution that was reliable and scalable. Xtrbackup has all the required features to fulfill our requirements.

can manage backup and archive data across disk arrays, tape libraries or optical storage and can automatically move data

Incentivized

• Secure, reliable, fast and consistent backups. Open source with zero cost.
• We satisfy our regulatory requirements.

• Simple, care free backups, especially if you do not use tapes and do not have to manage those.
• Very fast restores as the libraries have everything available online.
• Ease of locating the necessary data to restore

Incentivized