Giter VIP home page Giter VIP logo

Comments (2)

MarkLeith avatar MarkLeith commented on May 19, 2024

I think this is a bug anyway, all "admin statements" should have binary logging disabled when GTID is enabled on a replica...

from gh-ost.

shlomi-noach avatar shlomi-noach commented on May 19, 2024

I'm good to set a --sql-log-bin=false command line option.
One problem I see right now is the writes to _tbl_ghc -- the changelog table. In particular, the indication that the sync is complete (during cut-over phase) is done by updating a row on the changelog table, then picking that statement in the binary log. That's what promises us our async operation is truly complete and all other events have been processed.

And so there's at least one single update that needs to be made on the replica, which kinda ruins everything, correct?

For the specific use case of --test-on-replica we can work around this ; however such will not be the case for --migrate-on-replica, I suspect.

from gh-ost.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.