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

0

Good afternoon guys, I do not know if this is the right place to ask this question, if not apologize and delete the question, but there it goes ...

  • Where I work we have a system that works with 2 types of database, firebird 2.0 or MySQL, because the firebird database stays on the client side, sometimes the backup we generate (and stays on the same client machine) reasons that we can not prevent, example: there have been cases that the client had the computer stolen, HD burning, and those things which we have no control.
  • 1st attempt of solution: Removable disk storing backup.

This prevented data from being lost due to problems in the HD, but it was no use if the client removed the disk as well as giving the path error when automatic backup was enabled.

  • 2nd attempt at solution: MegaSync and similar.

This attempt worked correctly for some time, until we realized that when there was a crash on the internet, power outages or problems at the time the backup was being synchronized, the file was useless or a large amount of data was lost. / p>

After going through this, I was forced to look for another solution, I came up with 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 2 with database-specific tools ... If anyone can help, I am grateful.

    
asked by anonymous 12.09.2018 / 19:53

2 answers

2

First of all, the firebird .fdb or .gdb file does not have to be on the client side. This is already wrong, if it is the local network, the server that should keep the file and it can be mapped by the clients, if the server for access via the net if the settings are made in the firewall, NAT etc ...

Both MySql and Firebird back up and generate a file, this file must be copied to a place other than the server's own HD, or if you are going to use DAT, PENDRIVE, CLOUD, external HD etc. it is at your own risk, each has its advantages and disadvantages, and if that is your question (which is the best ) the question will probably not be answered right and yes a lot of opinions.

    
12.09.2018 / 20:56
1

I suggest finding a solution that fits in your pocket using what's best for you. Backups may be gigantic due to their data mass of some working time, but this is already about finding the best alternative for making smaller backups without wasting time "transmitting" unnecessary data.

    
12.09.2018 / 21:01