Comments (3)
arthurnn
commented on May 26, 2024
it's that triggers just don't run on the replica.
Why? I thought we could have the ghost table in a replica and have the trigger from the main table applying changes to the ghost just fine.
from gh-ost.
shlomi-noach
commented on May 26, 2024
@arthurnn Thank you for pointing this out! You are correct -- on Statement Based Replication, where the statement actually gets to be replayed on the replicas, and triggers do in fact work there.
This is not the case with Row Based Replication, where triggers on replicas do not get invoked because there are no "statements" per se with RBR.
Today, we do indeed Statement Based Replication, and in light of that the above does not apply. Updating within text.
from gh-ost.
shlomi-noach
commented on May 26, 2024
This works as expected. closing.
from gh-ost.
Related Issues (20)
- cc @eorpina @ffink
- 1.1.6 binary is dynamically linked HOT 1
- CHECK constraints being renamed to MySQL defaults
- amogus
- Add git commit hash to version info
- `RELEASE_VERSION` file is stale
- 786
- Feature request: add ability to profile gh-ost
- This dependency update will be handled internally by our engineering team.
- a question about the usage of gh-ost when migrated
- Is there a reason why the norm is to use screenshots of the rendered markdown instead of displaying the formatted/rendered markdown on docs.github.com (since the docs themselves are written in markdown)? Besides cases where a red box has to be drawn to show where to click of course.
- Lock wait timeout exceeded during cutover HOT 2
- "--attempt-instant-ddl" flag causing some issues with hooks and is incompatible with --execute flag HOT 1
- When the binlog file is larger than 4G, data loss occurs HOT 2
- Incorrect max retries in streamer
- Status message is not properly formatted and contains MISSING on STDERR HOT 1
- # Set the sshd service to be started automatically
- 👋 Hey there spelunker. It looks like you've modified some files that we can't accept as contributions:
- support create-table flag for simplified gh-ost migration
- [TASK] Confirm if your service is required for Proxima
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gh-ost.