Backup Database, which tool to use, alternatives, security and data access?

Asked

Viewed 70 times

0

I don’t know if this is the right place to ask this question, if not I apologize and I exclude the question...

  • Where I work we have a system that works with 2 types of database, Firebird 2.0 or Mysql, due to the Firebird database being on the client side, sometimes the backup that we generate (and is on the same client machine) is lost for reasons that we cannot prevent, example: there have been cases where the customer had the computer stolen, hard drive burning, and those things which we have no control.
  • 1st solution attempt: Removable disk storing the backup.

This would prevent data from being lost due to hard drive problems, but it would do no good if the client removed the disk, besides giving error in the way when automatic backup was activated.

  • 2nd solution attempt: Megasync and similar.

This attempt worked properly for some time, until we realized that when there was any internet failure, power outage or problems at the time the backup was being synchronized, the file was useless or a large amount of data was lost.

After going through this I was forced to look for another solution, I arrived at 3 options and wanted to know if any of you have used them or have any idea how to control the situation.

The options are:

Being the first two with specific database tools... If anyone can help I’m grateful

database backup cloud storage
  • 1

    Ideally you publish your question on https://dba.stackexchange.com

  • 1

    Your best guarantee would be that the bank would not be on the same machine as the customer. Anyway, following the way it is, you’d better implement a synchronism routine that reads Firebird from time to time and perform synchronism transactions for your mysql.

  • @Andremesquita the problem is that I don’t know when the client in question is messing with the bank, and if the backup occurs try to be overwritten while performing the synchronization, it corrupts and generates some "weird" files in the Megasync folder, so I was thinking of a tool that would "manage" this data before uploading to a remote server

  • I suggest you modify your question by defining well what the problem is, leave 3 options of programs and this doubt as what would be best will make your question be closed as "based on opinions"

2 answers

2

Guy before the file. FDB or . Firebird’s GDB does not need to be on the client side that is already wrong, if it is local network the server that should keep the file and it can be mapped by the clients, if the server is accessed by the net if it makes the settings in the firewall, NAT etc...

Both Mysql and Firebird backup and generate a file, this file must be copied to somewhere other than the server’s own HD, ai if you will use DAT, PENDRIVE, CLOUD, external hard drive etc. is at your own risk, each one has its advantages and disadvantages, and if that is your question ( which is the best ) the question will probably not be answered certain and yes a lot of opinions.

  • Yes, but there are cases where the client has only one machine, not allowing the installation of a server, in the clients we have and have more than one machine we use a server on a local network, but we can not always make the client "open his hand" to acquire a new machine

  • the solution to your problem remains the same, backup has to be copied out of the machine that this database, regardless of the technology that will use to do it, this backup if not out of the machine is "copy" not backup

1

I suggest we find a solution that fits in your pocket using what’s best next to you. Backups may be huge due to their mass of data from some working time, but this is already about searching for the best alternative to make smaller backups without wasting time "transmitting" unnecessary data.

Browser other questions tagged database backup cloud storage

You are not signed in. Login or sign up in order to post.