mysql features hot backups

  • mysqldump – most popular, but by default is locks tables, during process and apps can’t write something, you will see some 5XX errors on your website, but… if database less than free RAM and storage engine for all tables is INNODB you can mysqldump with –single-transaction option.
  • xtrabackup – free utility for physical backup, it should be installed on the same server.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>