Jump to content
xisto Community
bx93

One suggestion about database backup

Recommended Posts

Suppose there are lots tables in your database instance, and there maybe lots data within them. Backup task may cost u many time.What I suggest here is to add one more table in the instance, which contains the current delta of every other tables. Structure of TblLogs:1) record id, to be the index of this table, maybe automatic increased.2) tableName, contains the name of every table3) delta can be a int type. increase every time when the certain table is modified (ignore of select operation).With such table, we are able to develop a application, which check if the delta of a table is increased, and only backup the table which really need to be updated.Current suggestion has not been tried yet. Hope someone could present better solution here.

Share this post


Link to post
Share on other sites

-Hi, as you said yourself - you have to design an application or rather (if using windows or linux) - a background process that constantly monitors any change in the databas and commit incremental backups. Instead of that I'd rather use MySQL or PGSQL locally and use their auto-incremental backup feature (the same process thats used to generate incremental binary logs for replication servers) - much easier and much faster - with virtually to user-end programming on your part.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.