IBM Storage Protect vs. Percona XtraBackup

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

Xtrabackup has many excellent features that are supposed to be in any backup solution. It's well suited for all MySQL deployments but it's not appropriate for any other database. If you are using any MySQL flavor (MySQL, MariaDB, Percona Server for MySQL), it's your only and perfect solution for backup and disaster recovery.

• 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

• The ability to stream backups (using netcat or socat) to a target destination has many uses, for example, 1)We do not need to store a backup locally on the database server 2) We can stream backups into object storage using GCSFUSE.
• The hot-backup functionality is probably the most important function. We are able to take backups of our primary instances with minimal impact on the database instance.
• XtraBackup has many parameters that can be tuned, allowing us to increase performance or reduce by using the parallel thread parameter for example.
• Partial backups.
• The ease of use when doing restores. Simplified, fast and accurate.

• 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

• Remote execution: Xtrabackup doesn't support remote backup. The backup process has to run locally and have to store data locally.
• LifeCycle management: Xtrabackup doesn't support backup lifecycle management. Users have to manage it themself.
• Stability for large databases.

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

Incentivized

It is suitable for a huge part of our organisation, supports many operating systems (including Windows, Linux and IBM AIX), supports many databases - also for online backups (like Oracle, Db2 and SAP HANA), has an Operational Center for control, command-line and GUI for backup/restore. It just works well, once setup correctly.

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

Great support, detailed online documentation, and examples in many scenarios. Bugs can be logged and are tracked. Great community support has been built-up due to Percona XtraBackup being a great product. Frequent releases ensure bug fixes are committed as soon as possible. Over and above this, the development team stays up to date with the latest releases of MySQL and ensures it is 100% reliable.

We have been using TSM (former ADSM), rebranded Spectrum Protect and now rebranded Storage Protect a long time already. The product served us well. Last time we compared it to competitors we found they all had something lacking. And switching backup suites is no small task if there is data you need to keep 5, 7 or 10 years anyway. Commvault gets close, but doesn't match all features.

Incentivized

Percona XtraBackup saves us time and money. Besides the performance and reliability, the support and documentation are top-notch. It's not just about the cost savings, but about the functionality and the minimal impact that XtraBackup has on the database server during a backup window. Percona XtraBackup has been integrated into Percona XtraDB Cluster which makes adding nodes easy and fast.

• It can be used as a disaster recovery solution when you have the right configuration (either replication or tape copies in a safe location). This way it can be a lifesaver for any company.
• It can bring back the information you need if you are hit by ransomeware.
• It is also needed if you are accounting for user error, sometimes people delete the files they need by accident and without a backup solution they are out of luck

Incentivized

• It is free and the best backup tool that I know of. Using this for free means we save on having to purchase other backup software.
• As a DBA it is the standard backup tool that is used everywhere I have been.

Incentivized