GitHub's Online Schema-migration Tool for MySQL
Changes since 1.1.5: https://github.com/github/gh-ost/compare/v1.1.5...v1.1.6
gh-ost
v1.1.6 is based on the master
branch, which is now considered stable.
INSTANT DDL
first for MySQL 8.0 by @morgo in https://github.com/github/gh-ost/pull/1201
--attempt-instant-ddl
--storage-engine=rocksdb
.--allow-zero-in-date
--binlogsyncer-max-reconnect-attempts
gh-ost
will always use REPEATABLE_READ
for InnoDB and READ_COMMITED
for RocksDBgo1.17.11
by @timvaillancourt in https://github.com/github/gh-ost/pull/1136
.ReadMigrationRangeValues()
func accuracy by @timvaillancourt in https://github.com/github/gh-ost/pull/1164
gh-ost
officially supports MySQL 5.7 and newer.
Thanks to all contributors!
Edit Dec 7, 2023: Binaries updated to be statically linked
$ sha256sum *
0058c44e1a3ddba6fb6ac0b3132de5b266d57fdd059b756730d562307ffada6d gh-ost
5e389eeeaf3fded040e61f5be6f8ab282af866f33a94ba7d34fccf9e52a8ec44 gh-ost-1.1.6-1.x86_64.rpm
5d15547f207e72591fd3a55c9cbea275396880a65a290742287a1ac84d0f4977 gh-ost-binary-linux-amd64-20231207144046.tar.gz
12f9d91a77774e85073fdea6bfb26f457424bf65b12043cb330e288231aa3465 gh-ost-binary-linux-arm64-20231207144046.tar.gz
dbb4005dee04ae441ef5aba0c4d35052374ad852c87637f374b3990f36339cdb gh-ost-binary-osx-amd64-20231207144046.tar.gz
48fc179f7f91efb317c13c16bdc0d817bff0a4141b2732b40a7cbbe6ff211c20 gh-ost-binary-osx-arm64-20231207144046.tar.gz
f6ef9c83db73079c0c8395a85520b492551b9331c6063ce2f8996080aee51a3e gh-ost_1.1.6_amd64.deb
Changes since 1.1.4: https://github.com/github/gh-ost/compare/v1.1.4...v1.1.5
gh-ost
v1.1.5 is based on v1.1.4, plus commits cherry-picked from master
branch.
Notable:
--throttle-http-interval-millis
- Number of milliseconds to wait between HTTP throttle checks (default 100)
--throttle-http-timeout-millis
- Number of milliseconds to use as an HTTP throttle check timeout (default 1000)
gh-ost/VERSION-HERE
as a User-Agent
headerswitch
statements for readability, simplify .NewGoMySQLReader()
, #1135, thanks @timvaillancourtinteger divide by zero
panic in migrator, #1140, thanks @timvaillancourt for the PR and @ethankhall for reportinggolangci-lint
CI action, fix gosimple
, govet
+ unused
lint errors, #1127, thanks @timvaillancourtDeprecation Notice:
--replication-lag-query
command line flag will be deprecated in gh-ost
release 1.1.7This release is not based on the master
branch as it contains a known issue that is currently being investigated - please note that the master
branch of gh-ost
is not considered stable; only releases are considered production-ready.
Thank you to all contributors!
Updated 20th July 2022: RPM and deb packages have been updated to correctly include x86-64 binaries instead of arm64 binaries (thanks @Cartman75 for the issue report!)
$ sha256sum *
6a9dff3594b60a26422f7192ff7a79a85684b477d453431bedf025bc4023c389 gh-ost
236a1b9fb8fbb38bb6e27159377bd5af276ba09c3382724b5d88e9da6424dcbd gh-ost-1.1.5-1.x86_64.rpm
791ab7fe0e8fe9e754480f4decdba8380c87d5ce70648f8a549060d81f889116 gh-ost-binary-linux-amd64-20220707162303.tar.gz
48f53683e3c6bf52957ff985c8ccc2c09f8f2484b44da4346f659e019ef69be9 gh-ost-binary-linux-arm64-20220707162303.tar.gz
1b0d992d03eeba7aa919ca9b40019b92af319dcb3668e0a447db21b35016c5ee gh-ost-binary-osx-amd64-20220707162303.tar.gz
16fa1e09d2981e8a9312961337e41693a2e1396fe11abfd5b6a60781f3433795 gh-ost-binary-osx-arm64-20220707162303.tar.gz
2574da3ffe60f9a662366ca4f6a46edd90b8885acee8047ba0b11544561eb28d gh-ost_1.1.5_amd64.deb
Changes since 1.1.3: https://github.com/github/gh-ost/compare/v1.1.3...v1.1.4
gh-ost
v1.1.4 is based on v1.1.3, plus commits cherry-picked from master
branch.
Notable:
hooks-status-interval
, #1090100
to 10
, #1087, thanks @arthurschreiberThis release is not based on the master
branch as it contains a known issue that is currently being investigated - please note that the master
branch of gh-ost
is not considered stable; only releases are considered production-ready.
Thank you to all contributors!
Updated 25th Feb 2022: Binaries have been re-uploaded to fix an issue where RPMs were being generated with an OS for darwin
instead of linux
. (thanks @kedarvj for the report!)
Updated 11th Mar 2022: Added macOS arm64
binary to support M1 Macs (thanks @jecepeda for adding support in #1108!)
$ sha256sum *
da2b2a943aaf18fb849b52e19b0828c9878b180546d1adb31ad03b3cf7c50d53 gh-ost
d626f6ae582ca15c58a387c819c410788a78f64dd7ac7ec946df07f0bf66f7a0 gh-ost-1.1.4-1.x86_64.rpm
ccc055a9fa2ca080b99aeb58a6aacf557582c317b8f36ee13c551d87cd5eeb30 gh-ost-binary-linux-20220225143506.tar.gz
9feebe056914335d23127db10de8f20631e0df448b1382f30366a462ab5d5473 gh-ost-binary-osx-20220225143506.tar.gz
66619ad49fb7a2a13edfe08aee110a554f7174b44453451fee2e532661f1f254 gh-ost-binary-osx-arm64-20220311164158.tar.gz
1dead2c07b73a8730ec4b923433be143dcb4dc18719e2ad640962e389168a22d gh-ost_1.1.4_amd64.deb
Changes since 1.1.2: https://github.com/github/gh-ost/compare/v1.1.2...v1.1.3
gh-ost
v1.1.3 is comprised of v1.1.2 with a fix for security vulnerability GHSA-rrp4-2xx3-mv29, plus low-risk documentation updates cherry-picked from master
branch.
This release is not based on the master
branch as it contains a known issue that is currently being investigated - please note that the master
branch of gh-ost
is not considered stable; only releases are considered production-ready.
Notable:
-database
Parameter, GHSA-rrp4-2xx3-mv29, thanks @dwisiswant0go-mysql
in Gh-ost v1.1.3, #1079Thank you to all contributors!
Updated 8th Feb 2022: Binaries have been re-uploaded with the correct version number; previously they were incorrectly labelled as v1.1.2 instead of v1.1.3. (thanks @dharnett for notifying us!)
Updated 25th Feb 2022: Binaries have been re-uploaded to fix an issue where RPMs were being generated with an OS for darwin
instead of linux
. (thanks @kedarvj for the report!)
$ sha256sum *
10255fa8690001d7eb37f51c6d41aba0e55ee9ef4c2b949ca4c0604011b74d71 gh-ost
496ac03a36738e752ad98668a3bb97eca913039431fdff80732fbb4acfac8991 gh-ost-1.1.3-1.x86_64.rpm
c432e7d711268117bc8c13cebcf3e3cf3c986557a205cc041e0ea63937700ef5 gh-ost-binary-linux-20220225143057.tar.gz
e55b3c28c655eab28617a47eefa88fb6a508af506652bafdd226293968bebd8e gh-ost-binary-osx-20220225143057.tar.gz
116db1f8f5e4bff6a8903f057dad07e14ad36eea0f3b462a16342b6d3b447d1a gh-ost_1.1.3_amd64.deb
Changes since 1.1.1: https://github.com/github/gh-ost/compare/v1.1.1...v1.1.2
Notable:
GH_OST_ETA_SECONDS
ETA as part of migration context, #936, thanks @shlomi-noachbuild_id
files from rpm, #954, thanks @yakirgb-exact-rowcount
on MySQL 8.0.2+, #962, thanks @Fanduzienum
to varchar
, #963, thanks @shlomi-noachServerName
for TLS configuration, #988, thanks @dbussinkThank you to all contributors!
$ sha256sum *
342a7f4760d51dc05154dd1e6663f701bb024868a7f9b0804e8bf38afe67e0ff gh-ost
255dbaed5de7c20b1f11c82ed0275e0ecfaa8f8afa4f38fd36705cfac4b6207f gh-ost-1.1.2-1.x86_64.rpm
98ebff834bf930a198d3506cda0ee1a6a3ea67f09e9112ca8a2534ef4f74288c gh-ost-binary-linux-20210617134741.tar.gz
0b000805894ae5cc6b5ff0aacb67e4273328354f5e559a9ad39b1e7cc617b316 gh-ost-binary-osx-20210617155835.tar.gz
afaf95ea239b5e473080d0b58592e6449cfc48d936396a8540722c4772741893 gh-ost_1.1.2_amd64.deb
Changes since 1.1.0: https://github.com/github/gh-ost/compare/v1.1.0...v1.1.1
Notable:
sync.Once
to avoid dropping cutover sentry table twice, #755, thanks @MOON-CLJapplier
and inspector
interactive commands to socket/TCP server, #951Thank you to all contributors!
$ sha256sum *
8e802e8685d4b7d757ae47513b918d6de1d0402511cc3fadb2d961713beb6d89 gh-ost
6b49bbcf1a985d96fa98954d6aba5b2e8fa9f8b0ac9aee2c10bd47755f986254 gh-ost-1.1.1-1.x86_64.rpm
1188bb2d4539d25fc8a4b8a96cccb9b56a217124a9d4c8b9faab4534acd9258b gh-ost-binary-linux-20210503150942.tar.gz
1ef5585f926af0d93af53007b563c86a34d52bd4c05e1be5c6afaf8064199d3e gh-ost-binary-osx-20210503171035.tar.gz
02d39afd96e0b5d69baf6a7259871b664445eaa811ccb6c3928376793b56f997 gh-ost_1.1.1_amd64.deb
Changes since 1.0.49: https://github.com/github/gh-ost/compare/v1.0.49...v1.1.0
Notable:
ALTER TABLE
statement in --alter
, #865 / #878, thanks @shlomi-noach--mysql-timeout
flag, #824, thanks @shlomi-noachrows.Err
after processing all rows, #835, thanks @ajm188go-sql-driver
to latest, #823, thanks @shlomi-noachlatin1
tests with TEXT
columns, #291 / #455, thanks @shlomi-noachBINARY
/ VARBINARY
tests, #655, thanks @shlomi-noachNULL
-able INT
tests, #692, thanks @shlomi-noachThank you to all contributors!
$ sha256sum *
e6de44ed76cd7834d7dac5ee4a53459ce18e16fbb482e9ff5d898f7d83444632 gh-ost-1.1.0-1.x86_64.rpm
2c29184d5b7f1340999680c06ae6796639f195d00907214a9baddc9ca9391ca9 gh-ost-binary-linux-20200828140552.tar.gz
c1dc2716dd5b843b4ef11b3fa601885f079363ca5545799bdac7037fd132e723 gh-ost-binary-osx-20200828160625.tar.gz
6ca0c5f0a79e51035e380a00350a535e04381b29ac9bbb847acf31d3b8985390 gh-ost_1.1.0_amd64.deb
Changes since 1.0.48: https://github.com/github/gh-ost/compare/v1.0.48...v1.0.49
Notable:
--force-named-panic
(on panic command, force table name), named throttle
, named no-throttle
, #695--skip-strict-mode
option, #712, thank @babinomecprogressPct
and CurrentLag
, #788NO_AUTO_VALUE_ON_ZERO
#7238.0
go1.12
$ sha256sum *
628ad01f4b327ee81f01aee1e4e5d2a966ed681fa391d064424270dbd7b0b0b1 gh-ost-1.0.49-1.x86_64.rpm
a1d7f72e1119bb8a939204a56acbee09eb52c769183a4649e56d6b3b524cb774 gh-ost-binary-linux-20200209110835.tar.gz
667f8800654410749b1af6053f26109769992adb813eb9edaa154d537cc86ef3 gh-ost_1.0.49_amd64.deb
95b3ed74f70ffea9f11f4af06fb6e312f0a857bf4fd3c3ad2da31fc7b3359dd3 gh-ost-binary-osx-20200209114711.tar.gz
Changes since 1.0.47: https://github.com/github/gh-ost/compare/v1.0.47...v1.0.48
go-mysql
library, which solved multiple issuesdeb
package$ sha256sum *
cf1f0999c81f194472b9d3f154c21e0848bd1d61697ce1ca9123368b31d718b2 gh-ost-1.0.48-1.x86_64.rpm
8d0a518064c5803e1d5e8676031e5a5b5b180e67700d476e19eaf68e4a4a583a gh-ost-binary-linux-20190214020851.tar.gz
f57a1361315adba33b51ecd9bf8863722385dbcff741f0a4d467087aaded9bc4 gh-ost-binary-osx-20190214120940.tar.gz
67bf74f1af6f968a59a2725398ccb5167d97e9b0cd1ab00c867425bf86a0d124 gh-ost_1.0.48_amd64.deb
Changes since 1.0.46: https://github.com/github/gh-ost/compare/v1.0.46...v1.0.47
copyRowsFunc
hanging issue. Thank you @wfxiang08 #611Checksums:
$ sha256sum *
1e2659498d8f2b66cd911e52c8282f03fd2de08eb86d6d77aad0c7ec3e6ff9e0 gh-ost-1.0.47-1.x86_64.rpm
1b00a14d5b358efd210d5371d63d5c84f3ce35717fbb2c15a24b7248b2dede95 gh-ost-binary-linux-20181016015113.tar.gz
396964f58cb6a72818437cd1a2cf129523b339b6000dd6443f9399841e0d35d9 gh-ost-binary-osx-20181016015113.tar.gz
8e98c38d9d4129929a95850aecc50f010443626e5ff0ba7ef85c90f24444e199 gh-ost_1.0.47_amd64.deb