Not the answer you need?
Register and ask your own question!

Does Innobackup requires binlog to be active?

MeirimMeirim EntrantInactive User Role Beginner
Hi,

I've an instance with huge file loads and processing afterwards. I've disabled bin logging.

The main and only question is:
Is my backup+prepare ok without bin logging? Does innobackup requires bin logging?

Thank you,

Best Regards,
J. Meirim

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi Meirim;

    Xtrabackup / innobackupex do not require that you have binlogs enabled, however without it you will not have the binlog position to easily setup replication slaves or do point in time recovery. But if all you need is a simple backup of your data that can be restored as-is, then you do not need binlogs enabled. =)

    -Scott
  • MeirimMeirim Entrant Inactive User Role Beginner
    Scott,

    Thank you for your input!

    Regards,
    J. Meirim
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.