Oracle Database and SQL: 10 Backup Solution Questions to Ask

Have you opted for a third-party backup solution to save your MySQL data? Do you find yourself overly concerned about your data? Are you certain that you have been receiving a dependable backup that is easy to recover, and is suitable for your business as well as your application? Does it have any effect on critical processes when it operates?

As you may have surmised, this post is all about the questions to which you must have the answers, especially if you are entrusting someone else with the protection of your Oracle database and SQL data. 

10 Major Backup-Related Questions to Ask Providers

Given below are ten important questions related to backup solutions you need to answer before you consider Oracle SQL performance tuning and optimization .

Question 1: Is it necessary to shut down MySQL for the backup? If it isn't, does the running server get affected in any manner, such as in terms of I / O load, cache, blocking, etc.?

Question 2: Are you aware of the technique used for the Oracle database and SQL backup? For instance, is it a filesystem copy, mysqldump, or something similar to it?

Question 3: Is the backup system aware of the fact that merely copying InnoDB files doesn't mean its backup has been created?

Question 4: Is attention paid to certain aspects of MySQL, such as flush tables, lock tables, and those with reading lock? Each of these interferes with processing.

Question 5: How else is MySQL impacted by the backup solution? Is any type of flush command used at all? For instance, some systems perform a Reset Master, which instantly interrupts replication.

Question 6: How is the system able to ensure point-in-time data recovery?

Question 7: Is the system successful in guaranteeing continuity with different logs like binary and InnoDB logs? What about replication?

Question 8: Does the system enable you to arrange new MySQL replication slaves? If yes, how?

Question 9: Does the system check whether the backup can be restored or not? For example, does it run InnoDB recovery prior to a declaration of success?

Question 10: Do you have a certified professional standing behind the backup system, ready to provide support and ensure you receive recoverable backups on a regular basis? Where does their 'guarantee' stand legally? Where does the backup solution stand from an insurance perspective?

Why Ask These Questions for Oracle Database and SQL

These are just some of the things that must be known when choosing a backup solution. However, answering these questions is extremely important for MySQL because many customers have faced infuriating encounters with vendors providing backup products using some sort of agent for MySQL.

The reason behind their frustration is a lack of substantial details regarding the procedures behind the backup implementation. In fact, even basic questions related to dumps or file copies are left unanswered most of the time, which leaves customers annoyed, especially while they are in search of a SQL query optimization tool .

Sometimes, the client is asked to register and download a whitepaper with insufficient explanation, in the form of a single bullet point to mention “Compatible with MySQL Databases”. Callers are even left unattended after they are “transferred to a salesperson that covers their region.”

Even the term “proprietary” is mentioned by some of these solution providers as if it's a good thing. In actuality, a proprietary means to keep their clients' data is unacceptable, since MySQL backups are complicated and hard to maintain correctly. This is because the nature of a data recovery system is highly dependent on the application as well as the technology, and unless the professional behind the phone is aware of each and every task associated with the process, they are not really in a position to answer the customers' questions regarding the effectiveness of their solution.

So, the above list will prove a useful method to assess your backup provider's adequacy for enterprise-ready backup applications. As the client, if you cannot receive a satisfactory answer to each of these questions, it's a backup solution that you likely cannot evaluate thoroughly.