Home › Forum › Software › db backup – be aware

Log In Register Lost Password
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • February 9, 2015 at 12:21 am #1307
    uRADMonitor
    Keymaster

    Most likely when the cron called mysqldump backup script runs, some of the new entries are lost.

    My plan was to archieve the old data periodically and keep a smaller DB on the run. This would have helped the backup process as well, yet some time would still have been used.

    I will look on the alternatives you’ve indicated.

    Thanks!

    February 9, 2015 at 8:33 pm #1314
    vinz
    Member

    that’s it; what I wanted to say:
    You must not use mysqldump for big production databases.

    One way would be, to master-slave replicate the DB and dump the copy:
    https://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

    Other way, the one I’d investigate in, would be XtraBackup.

    Btw. Radu, could you install vim, screen and htop on the dev-server? This would enlighten my commandline-feeling.

  • Author
    Posts
Log In Register Lost Password
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.