Comments (5)
-
Does not support
FOREIGN KEYS
of any kind (table must be neither "parent" nor "child")may support in the future
-
Active-active writable-writable master-master should not be supported(or provide a flag--allow-master-master
?) Need to further think over this onemaster-master is supported, but requires the user to add
--allow-master-master
.gh-ost
will not verify whether this is an active-active or an active-passive setup. An active-active setup may present some problems, that we haven't fully figured out yet. active-passive is good to go.
from gh-ost.
- with
go-mysql
client, table names turn tolower
case on reading RBR. This means potentially no support for tables with identical names but differing case. To clarify, you may not be able to alterMyTable
if you also haveMYtable
table.
from gh-ost.
-
When altering a table, some sort of
UNIQUE KEY
must be shared between the two tables.in the case where you have a table with a
unique key
but noprimary key
, and you wish to convert theuk
topk
, two migrations are required: one to addpk
, utilizing the existinguk
, another to drop theuk
. Maybe in the futuregh-ost
will support this as a single operation. -
Shared
UNIQUE KEY
must not include columns withNULL
values. That is: it is OK for columns to beNULLABLE
, but not OK if they actually containNULL
values.- For
PRIMARY KEY
s this is a non issue since by definition they may only include non-nullable columns
- For
from gh-ost.
-
Currently no support for renaming a columnThere is now.
from gh-ost.
This issue turns into a documentation page: requirements and limitations. Closing
from gh-ost.
Related Issues (20)
- "attempt-instant-ddl" should support lock_wait_timeout HOT 1
- max-lag-millis parameter description is misleading when running on master HOT 3
- When will the throttled state be triggered HOT 1
- Does gh-ost support distributed databases? HOT 2
- binlog syncer closes unexpectedly
- PR HOT 2
- Feature request: support setting the `wait_timeout` of `gh-ost` HOT 1
- cut-over locks not released when gh-ost pauses mid-cut-over
- Aliii HOT 1
- FATAL invalid sequence 8 != 1
- Cannot log in to mysql DB by ghost user
- collect table statistics before renaming table
- Clarification on `aurora_enable_repl_bin_log_filtering` in Aurora HOT 6
- RDS/Aurora Docs clarifications.
- skip delete events of changelog table in binlog listener
- [Suggestion] Apply simple validation to alter command
- ERROR Error 1146: Table '<db>._temp_no_ghc' doesn't exist HOT 2
- Add atomic cut over function that renames locked tables in the same session
- UCS2 to UTF8MB4 Encoding error
- Handling Slow Queries Without Indexes in gh-ost
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.