What is the best way to do a database backup online

3

There is a client of mine that has two machines, one of which is the server where all the data in the database is stored, and the other is the box.

However, there is the customer's concern that something happens to the server that the data is saved somewhere on the internet. So I saw C # (which is made the application of the box) generate a ".sql" file every night with the backup of all the data from the database. And I send this ".sql" via FTP to a server of mine.

My big question is if the method I'm using is good, why do we notice that the more time passes, the larger the ".sql" file gets and the longer it takes to send the file to the FTP server. I would like to know if the method used is good and feasible or if there is something better.

    
asked by anonymous 06.02.2014 / 15:57

1 answer

4

The problem is bandwidth / file size.

I do not know if mysql can do backup differentially. If it were an MS SQL or Oracle I would do a differential backup per day and a full per week (probably, but that depends on each scenario). Anyway you are only asking for the media (save in the cloud, disk, tape, internet, etc) and it will not have much difference between one and another besides those upload / download times etc.

I'd say your method is good for small bases and lots of bandwidth. But you should also check the time it takes to restore this database by downloading from your ftp server.

Remember that backup is only one of the requirements to allow a system restore. Make sure you have a contingency plan for these occurrences and how long it will take (and if it will actually mitigate the situation).

Returning to the x of the question. Check the possibility of differential backups or if there is another server available to be the storage of these files. When working on an "accidental" DBA we had a tape for each day of the week and we took out several differential backups and a full one every day while the other six tapes were in a safe.     

06.02.2014 / 16:32