MySQL Forums
Forum List  »  Replication

Re: Re-sync slave without lock master
Posted by: Shawn Green
Date: July 14, 2018 01:51PM

Hello Stefano,

If *all* of your user tables (those not located in a system database) are using the InnoDB storage engine, then the option --single-transaction could do that for you.

The system databases are: mysql, information_schema, performance_schema, and sys.

Even if all of your "user" tables are InnoDB, if you are changing any binlogged non-InnoDB tables while you are in the middle of your backup (such as creating or adjusting any user accounts which needs to change at least one MyISAM table in the `mysql` database) then you must take locks in order to make your backup transactionally consistent with one single location in the Binary Log.

Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN

Become certified in MySQL! Visit https://www.mysql.com/certification/ for details.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Re-sync slave without lock master
654
July 14, 2018 01:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.