Invoke a custom script in the web UI - Githubissues

Shopify / ghostferry

The swiss army knife of live data migrations

https://shopify.github.io/ghostferry

MIT License

748 stars 70 forks source link

Invoke a custom script in the web UI #213

Closed shuhaowu closed 3 years ago

shuhaowu commented 4 years ago

With this PR we can run a custom script with the push of a button within the web ui as follows:

Screenshot_2020-10-05 Ghostferry 127 0 0 1 29291 - 127 0 0 1 29292

Some problems with this PR:

The control server is kind of unmaintained and needs to be refactored. I don't think this design was done in like a day when I originally wrote the code and didn't change since.
We cannot stream stdout nor stderr. This is a problem for long running scripts.
We cannot kill the script easily.

Use cases:

For example, we could run mysqldump while Ghostferry is in cutover for small tables not supported by Ghostferry (such as those without an ordered, numeric unique column).

shuhaowu commented 4 years ago

This is not quite ready for review... Need some additional work to make it usable...