Likelihood to Recommend Well suited to databases < 10TB. For larger than this, I would go with snapshots.
Douglas Doo Principle Database Architect [MySQL|RDS|Aurora|PXC|MongoDB|Oracle|CloudSQL|Clickhouse]
Read full review AppAssure works well for quick access to point in time backups of Windows machines without having to do a complete restore. The virtual standby function is useful as a disaster recovery or high availability solution. Recent upgrades to the product and rebranding to Rapid Recovery look promising. If your Linux machines are mission [critical] make sure your administrators test restores so they can perform them in a timely manner should the need arise.
Read full review Pros 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 Anil Yadav Senior Engineering Manager (Site Reliability Engineering)
Read full review Continuous backup with deduplication and compression The P to V function of the software is create. To be able to back up physical machines and create a hot spare on a virtual environment was a great selling point. Can back up physical and virtual (ESX or Hyper-V). Read full review Cons 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. Douglas Doo Principle Database Architect [MySQL|RDS|Aurora|PXC|MongoDB|Oracle|CloudSQL|Clickhouse]
Read full review Support for newer operating systems (Windows, Linux, VMware) is slow to be added. Usually takes 3-6 months from the new version being released for it to be supported. There is no way to automate the testing of the virtual standby which a lot of comparable products are able to do. The software has a backup type called "base image" which is essentially taking a full backup after an unexpected shutdown of the server. If your servers crash and they are very large, this may impact your storage requirements significantly. They do now have synthetic full backups which alleviate this issue a bit but they are not perfect either. Read full review Usability Takes a bit of getting used to when you first set it up.
Read full review Support Rating If you pay for support it is great, otherwise you have to google.
Read full review In the very few instances we've needed support they have been quick, friendly, knowledgeable, and dedicated to servicing our needs. That has only improved since AppAssure was bought out by Quest.
Read full review Implementation Rating Our initial installation really was not optimum. With the help from Dell Profession Services we were able to get our implementation sized correctly and better understand how to get better deduplication results
Read full review Alternatives Considered 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.
Anil Yadav Senior Engineering Manager (Site Reliability Engineering)
Read full review I've been using Rapid Recovery for the last 6 years and before that we had used Backup Exec, but it was a different implementation as we were still running backups to LTO3 tapes using the full/incremental backup schemes. So Rapid Recovery (AppAssure at the time) was a big change for us, backing up to disk instead with base images and changes. I would assume Backup Exec can do this as well, but haven't used it since switching.
NovaBACKUP was a lower cost solution that seemed geared towards smaller and simpler configurations
Read full review Return on Investment Secure, reliable, fast and consistent backups. Open source with zero cost. We satisfy our regulatory requirements. Douglas Doo Principle Database Architect [MySQL|RDS|Aurora|PXC|MongoDB|Oracle|CloudSQL|Clickhouse]
Read full review AppAssure paid for itself in the first year of usage. A user deleted a major file in our SharePoint sub-site, we used the DocRetriever for SharePoint Console and were able to go back to a particular incremental date and retrieved that file. One of our file shares crashed and we were able to put the physical server on a virtual standby which saved us hours of imaging and restoring of data. This allowed employees to efficiently continue their daily work without much downtime. The offsite replication alone has put an ease on the company in case of any disaster. When Hurricane Sandy hit, we didn't have a solution in place which put us on pins and needles to say the least. But with AppAssure we will be able to have some comfort that all of our mission critical data is being offloaded onto our other sites. Read full review ScreenShots Percona XtraBackup Screenshots