IBM Storage Protect vs. Percona XtraBackup

IBM Storage Protect is well-suited for large heterogenous environments, with skilled IT staff on-hand. You need a person (or group of people) to monitor day-to-day operations, tweak schedules where needed and be mindful of things that might go wrong. It is also well-suited if you have other IBM products that integrate well with Storage Protect, like Storage Protect Plus or IBM Defender. It is less suited for small companies, with only one person responsible for IT. Employing Storage Protect would be overkill and use too much time of the administrator.

Incentivized

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

• Tight integration with Db2. As an IBM product, it works seamlessly with Db2. You can query what is stored in TSM via Db2 itself. You can also use DB scripts to maintain the items being stored there.
• Like most of its competitors, Tivoli handles deduplication well.
• Provides a GUI for browsing and maintaining items stored there. I rarely use this feature, due to the next item I will post:
• Command-line interface directly from my Db2 database servers.
• Both client and server-side deduplication, compression and encryption are available.
• If the requirements are zLinux and DB2 support then it's the most solid solution.
• Can be complex to implement, but once up and running, it is rock-solid and immensely scalable.
• Scalability is huge. Can be added onto easily.

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

• Deployment and configuration is not easy for an unexperienced IBM Spectrum Protect administrator
• Operations center uses a lot of data and needs a lot of storage for larger environments
• Have not seen a redbook about it in the past 10 years

• 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.

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

Incentivized

In the present, a backup solution is a must-have, but then companies start using a solution for virtual machines, another solution for bare-metal servers, and another solution for their ERP. By using Spectrum Protect you can have all of that in a single pane of glass. This way you can have a simple recovery plan for all your information assets.

Incentivized

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

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

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

Incentivized

IBM Spectrum Protect is related to the other IBM Spectrum products listed because it is part of the suite and is also the main backup product for backup and restoration of information. With Veeam it is related as they present competence in different lines of technology, often the integration of both tools can be the best solution for clients looking for a successful backup strategy.

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.

Not at the moment, but it can leverage the billing outcomes as per the scales.

Incentivized

• 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

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