gh-ost

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.

What's Changed

• Attempt INSTANT DDL first for MySQL 8.0 by @morgo in https://github.com/github/gh-ost/pull/1201
  • disabled by default; enable with the flag --attempt-instant-ddl
• Add rocksdb as transactional engine by @wangzihuacool in https://github.com/github/gh-ost/pull/1190
  • RocksDB support is experimental. Enable with --storage-engine=rocksdb.
• Allow zero in dates by @timvaillancourt in https://github.com/github/gh-ost/pull/1161
  • enable with the flag --allow-zero-in-date
• Set binlogsyncer max reconnect attempts by @shaohk in https://github.com/github/gh-ost/pull/1279
  • set with the flag --binlogsyncer-max-reconnect-attempts
• Set a transaction isolation level for MySQL connections by @timvaillancourt in https://github.com/github/gh-ost/pull/1156
  • gh-ost will always use REPEATABLE_READ for InnoDB and READ_COMMITED for RocksDB
• Print status to migrationContext logger by @SocalNick in https://github.com/github/gh-ost/pull/1194
• Fix: parse binlog timestamp in UTC by @meiji163 in https://github.com/github/gh-ost/pull/1322
• Fix: Convert column value in binlog events to bytes instead of utf8 encoded unicode by @wangzihuacool in https://github.com/github/gh-ost/pull/1158
• Fix: because lock is not release, drop cutover sentry table is hanged by @lmtwga in https://github.com/github/gh-ost/pull/1180
• Default to go1.17.11 by @timvaillancourt in https://github.com/github/gh-ost/pull/1136
• Improve applier .ReadMigrationRangeValues() func accuracy by @timvaillancourt in https://github.com/github/gh-ost/pull/1164
• Add basic tests by @timvaillancourt https://github.com/github/gh-ost/pull/1165, https://github.com/github/gh-ost/pull/1166, https://github.com/github/gh-ost/pull/1168, https://github.com/github/gh-ost/pull/1179
• Upgrade go standard library for security patches by @meiji163 in https://github.com/github/gh-ost/pull/1332

Deprecation Notice

gh-ost officially supports MySQL 5.7 and newer.

• Remove MySQL 5.5 version (end-of-life Dec 2018) by @timvaillancourt in https://github.com/github/gh-ost/pull/1097
• Remove MySQL 5.6 version (end-of-life Feb 2021) by @dm-2 in https://github.com/github/gh-ost/pull/1101

Thanks to all contributors!

$ sha256sum *
0058c44e1a3ddba6fb6ac0b3132de5b266d57fdd059b756730d562307ffada6d  gh-ost
49827a7d2ff62db8af6011268cbbfb6f80ce0b0b5c160f07617a1fabeea98eaa  gh-ost-1.1.6-1.x86_64.rpm
3cb37b26e9f7836c5437d3464d93afe0611c410e7a0ef2bd258232cb02a0685c  gh-ost_1.1.6_amd64.deb
c23e2f94ee6a96bb663eb2668c198b71b4a254a6aebef0d823c4637e84dd66d9  gh-ost-binary-linux-amd64-20231103125330.tar.gz
cc6fb1d3db9114a5e293b8851a61d773a45e90e4e4d06c302af35c028505fe07  gh-ost-binary-linux-arm64-20231103125330.tar.gz
22d33836d02599fd2d22a766bc717d19e66f9873651c860711eef3a367bb65f7  gh-ost-binary-osx-amd64-20231103125330.tar.gz
98dfd509c837493ee5e17d528f09d8f018c96f6d4477515394e981e409d4e0c9  gh-ost-binary-osx-arm64-20231103125330.tar.gz

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:

• Cancel any row count queries before attempting to cut over, #846, thanks @ajm188
• Add context/timeout to HTTP throttle check, #1131, thanks @timvaillancourt
  • Throttler will now throttle migration on HTTP timeouts to throttler source. This may cause a change in behaviour in rare cases (more throttling)
  • New command line flags:
    1. --throttle-http-interval-millis - Number of milliseconds to wait between HTTP throttle checks (default 100)
    2. --throttle-http-timeout-millis - Number of milliseconds to use as an HTTP throttle check timeout (default 1000)
  • HTTP throttler calls now use gh-ost/VERSION-HERE as a User-Agent header
• Use switch statements for readability, simplify .NewGoMySQLReader(), #1135, thanks @timvaillancourt
• Ensure mysql rows responses are closed, #1132, thanks @timvaillancourt
• compound pk tests, #387, thanks @shlomi-noach
• Fix integer divide by zero panic in migrator, #1140, thanks @timvaillancourt for the PR and @ethankhall for reporting
• fix: lost data in mysql two-phase commit, #1141, thanks @shaohk
• Add golangci-lint CI action, fix gosimple, govet + unused lint errors, #1127, thanks @timvaillancourt
• Check RowsAffected when applying DML events to get more accurate statistics, #844, thanks @ajm188

Deprecation Notice:

• --replication-lag-query command line flag will be deprecated in gh-ost release 1.1.7

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.

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:

• Add flag to customize the interval which the onStatus hook is called, #1083, thanks @tknodell-recurly
• Add docs for hooks-status-interval, #1090
• Reduce the minimal chunk size from 100 to 10, #1087, thanks @arthurschreiber

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.

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:

• Security vulnerability: Improper Input Validation of -database Parameter, GHSA-rrp4-2xx3-mv29, thanks @dwisiswant0
• doc/triggerless-design.md: typo, #1011, thanks @eddroid
• Document the flag critical-load-hibernate-seconds, improve grammar of flags documentation, #1066, thanks @EagleEyeJohn
• Update hook environment variable docs, #1076
• Update build script to generate releases, #1078
• Remove CGO dependency in go-mysql in Gh-ost v1.1.3, #1079

Thank 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:

• Copy auto increment, #911, thanks @shlomi-noach
• Cut-over should wait for heartbeat lag to be low enough to succeed, #921, thanks @ccoffey
• All MySQL DBs limited to max 3 concurrent/idle connections, #931, thanks @shlomi-noach
• Report GH_OST_ETA_SECONDS ETA as part of migration context, #936, thanks @shlomi-noach
• Remove build_id files from rpm, #954, thanks @yakirgb
• Fix bug with -exact-rowcount on MySQL 8.0.2+, #962, thanks @Fanduzi
• Support enum to varchar, #963, thanks @shlomi-noach
• Set the ServerName for TLS configuration, #988, thanks @dbussink
• Use Golang 1.16 and temporarily disable go modules in builds, #966
• Use matrix build for replica test CI, #968

Thank 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:

• Use sync.Once to avoid dropping cutover sentry table twice, #755, thanks @MOON-CLJ
• Parsing IPV6 addresses, #640, thanks @shlomi-noach
• Support Azure Database for MySQL, #807, thanks @elemount
• Use Golang 1.15 and remove Debian Jessie (end-of-life) tarball build, #906
• Improved connection type logging, #515, thanks @akshaychhajed
• Fix: Data loss on tables with binary primary key, #915, thanks @cenkore
• Add applier and inspector interactive commands to socket/TCP server, #951

Thank 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:

• Support a complete ALTER TABLE statement in --alter, #865 / #878, thanks @shlomi-noach
• Support --mysql-timeout flag, #824, thanks @shlomi-noach
• Add a check to rows.Err after processing all rows, #835, thanks @ajm188
• Update go-sql-driver to latest, #823, thanks @shlomi-noach
• Update build to Golang 1.14, #861 / #876, thanks @shlomi-noach
• Add error checking for an err variable that was left unchecked, #810, thanks @yaserazfar
• Implement a logging interface, #789 / #864, thanks @abeyum and @jfudally
• Throttle on HTTP error to throttling API, #833, thanks @jfudally
• Additional testing:
  • Add latin1 tests with TEXT columns, #291 / #455, thanks @shlomi-noach
  • Add BINARY / VARBINARY tests, #655, thanks @shlomi-noach
  • Add NULL-able INT tests, #692, thanks @shlomi-noach

Thank 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
• add --skip-strict-mode option, #712, thank @babinomec
• Improve SSL support #716, thanks @RafeKettler
• context, status and hooks: add progressPct and CurrentLag, #788
• Always use NO_AUTO_VALUE_ON_ZERO #723
• tests: test on MySQL 8.0
• tests: Bump default-retries to 3 #754 , thanks @zmoazeni
• Support and require go1.12
• doc updates/fixes, thanks @mohitm15, Tobias Johansson, @jchambers

$ 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

• Update to latest go-mysql library, which solved multiple issues
• Fix inspector column types #661, thanks @esnunes
• inspect: remove redundant join conditions #699, thanks @twotwotwo
• maintainer email address in .deb package
• added: --hooks-hint-owner, --hooks-hint-token #703
• Initial SSL Connection Support #705, thanks @brandonbodnar-wk
• Fixed DECIMAL datatype #684 (the trigger for updating go-mysql)
• more... thank you to all contributors!

$ 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

• Fix to copyRowsFunc hanging issue. Thank you @wfxiang08 #611
• Support for GCP (Google Cloud Platform) #634
• Populate the hooks environment with dry run status. Thank you @jacobbednarz #641
• Integration test updates
• Minor documentation updates

Checksums:

$ 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

Changes since 1.0.45: https://github.com/github/gh-ost/compare/v1.0.45...v1.0.46

• Support for GENERATED columns, #595, based on work by @dveeden
• Support for zero timestamps on MySQL 5.5 #539
• Sanity: enforcing binlog_row_image=FULL
• Avoid prepared statements for changelog table #592 @ggunson
• Community contributions, thanks @SchumacherFM, @atsushi-ishibashi,
• Release: rpm and deb packages

Checksums:

$ sha256sum *
9b0741d1b27aab613cdad12c2bfdd70d6879b116b6d41cef3b58eb21d4f14e62  gh-ost-1.0.46-1.x86_64.rpm
4222af72f19eadfb6ca7335791c8cc9f628f14c751bc324508cf976fc6dd9feb  gh-ost-binary-linux-20180527215024.tar.gz
4f069500b7d3a9f1396fc615acd4913fb12783d8e8494aa5656c9355e6b5d8d3  gh-ost-binary-osx-20180527215024.tar.gz
b6b452c17b44da537f92f29514ab5fdd4dbe795f671c8dd08f5962f31e7ba2ec  gh-ost_1.0.46_amd64.deb

Changes since previous release, 10.0.44: https://github.com/github/gh-ost/compare/v1.0.44...v1.0.45

Notable:

• Support for Aliyun RDS, contribution by @zhangxiaojian, #541
• Support gbk Encoding , contribution by @ceshihao, #533
• Support exponential backoff for cutover attempts, contribution by @kurtzur, #563
• Fix to long JSON values
• CI to run migration tests (previously executed manually outside CI flow), #546, blog post
• Tests for GEOMETRY and POINT data types
• Avoid printing password in output log

Thank you to all contributors!

$ sha256sum *
c0319eee757e544eb2be298ba115c3a6e6296d3c5ae44929d64009f3f86a62d4  gh-ost-binary-linux-20180417090238.tar.gz
68fe507863a323e690a9899395314f52925cc173b38272dd91deb29cb5a1005b  gh-ost-binary-osx-20180417090238.tar.gz

Changes since 1.0.42: https://github.com/github/gh-ost/compare/v1.0.42...v1.0.44

Notable:

• --postpone-cut-over-flag-file implies touching indicated file
• support for PK column UPDATE (fixes #519)
• Implement teardown (#479 ), now gh-ost can be embedded as a library -- thanks @nikhilmat !
• Allow gh-ost to modify the server using extra port (#491 ) -- thanks @zmoazeni !
• Doc updates -- thanks @druud !
• Remove plaintext password from log
• Building via go1.9

$ sha256 *
583eb9fe9055b422521a7a60083860248bf5a52226dceb561cb60d8520bfecc0  gh-ost-binary-linux-20180211093207.tar.gz
6940fde2720179f4b3c4c74b906e746060b18a0a1e3229dcf818cd944a57dfd7  gh-ost-binary-osx-20180211093207.tar.gz

Changes since 1.0.40: https://github.com/github/gh-ost/compare/v1.0.40...v1.0.42

Notable:

• Support for 5.7 JSON data type
• Write optimization: client side prepares statements, reduce network traffic overhead, https://github.com/github/gh-ost/pull/459
• Read optimization: avoid generating temporary tables in read query, https://github.com/github/gh-ost/pull/471 thanks @ggunson
• Using autocommit=1, fixes https://github.com/github/gh-ost/issues/480, thanks @renecannao
• Added --force-table-names controlling, see https://github.com/github/gh-ost/pull/457, thanks @arthurnn
• Validating password length (capped at 32, see https://github.com/github/gh-ost/pull/489)
• Stricter data type validation pre-migration
• more...

Thank you kindly to all contributors!

$ md5sum *
07617a0058396336d0d0686253ae602d  gh-ost-binary-linux-20170914095800.tar.gz
673574c92bf18921625758a05e0bed98  gh-ost-binary-osx-20170914095800.tar.gz

$ sha1sum *
444589e9417653a8636838cb6ecbe7fb908e7609  gh-ost-binary-linux-20170914095800.tar.gz
9a79e741ea28e1f55d7cf49b9813f151d4b52362  gh-ost-binary-osx-20170914095800.tar.gz

$ sha256sum *
297b14ed1efe9b894e27e63f7aff36ceded7334c174f5a8602af9e74beb2f512  gh-ost-binary-linux-20170914095800.tar.gz
0fd2497b21305dbd420f94d61703a33a70fcf2b0b54bbfb55e178691d061ff2d  gh-ost-binary-osx-20170914095800.tar.gz

Changes since 1.0.36: https://github.com/github/gh-ost/compare/v1.0.36...v1.0.40

Notable:

• Fix to data integrity issue: corruption in timestamp(6) and datetime(6) microsecond values when smaller than 0.1sec, https://github.com/github/gh-ost/pull/452
• Fix to data integrity issue: kill on the master connection could cause a premature cut-over without all the rows being copied, https://github.com/github/gh-ost/pull/445
• Fix to data integrity issue: support for alter table .. change column X where X is a different letter case than original column, https://github.com/github/gh-ost/pull/447
• supporting tables that reach up to and including max length (64 characters), https://github.com/github/gh-ost/pull/451
• Hibernate on critical load: when critical-load-hibernate-seconds > 0, then the behavior of critical-load changes. Instead of panicking and bailing out with error, gh-ost enters hibernation. https://github.com/github/gh-ost/pull/424
• dml-batch-size is dynamic, supported up to 1000
• http-throttle outputs clearer throttle messahes
• http-throttle is freno aware and outputs clearer throttle messahes
• fix to critical-load hibernation check
• support for drop + add a column of same name (gh-ost will recognize the before/after columns to be unrelated)
• RDS documentation, thanks @jacobbednarz
• improved documentation, thanks @jessbreckenridge
• more...

md5sum
55079a0ea0f72bfccf32658f4c6de894  gh-ost-binary-linux-1.0.40-20170721063804.tar.gz
715309fcd4cd85f974b4ac648f849fa3  gh-ost-binary-osx-1.0.40-20170721063804.tar.gz

sha1sum
b19b8af996cef57d117a961cdf2c27865e9c5ff6  gh-ost-binary-linux-1.0.40-20170721063804.tar.gz
d8b3d862e815319ba62c6f55502cdd670f0b4028  gh-ost-binary-osx-1.0.40-20170721063804.tar.gz

changes since 1.0.35: https://github.com/github/gh-ost/compare/v1.0.35...v1.0.36

Notable:

• supporting --throttle-http=<url>: routinely check given URL, throttle when response code is not 200.
• fixed "close sync with err: sync is been closing..." message

gh-ost now supports and uses TravisCI. The community will now have visibility into CI tests on both external and internal PRs.

changes since 1.0.34: https://github.com/github/gh-ost/compare/v1.0.34...v1.0.35

notable:

• updated go-mysql library
• supporting --timestamp-old-table
• mitigating cut-over/write race condition
• fixed mediumint unsigned problem
• added various tests
• proper documentation for shared key and unique keys requirements -- thanks @ggunson
• interactive command support question mark (?) as argument, in which case this is a Get operation, gh-ost prints out current value
• fix to throttle-control-replicas dynamic setting; showing number of throttle control replicas in status
• added "common questions" doc page
• cut-over failure on test-on-replica kicks replication running again before reattempt
• collecting and presenting MySQL versions of applier and inspector
• migration only starting after first replication lag metric collected
• more...

changes since 1.0.32: https://github.com/github/gh-ost/compare/v1.0.32...v1.0.34

notable:

• Batched writes for applying binlog events onto ghost table: solving https://github.com/github/gh-ost/issues/348, this increases write capacity for gh-ost without introducing delays or stalls. See https://github.com/github/gh-ost/issues/352
• Only using internal heartbeat mechanism. --replication-lag-query is now deprecated and unused. gh-ost has its own subsecond resolution replication lag measurement which it uses both on the connected server as well as on the control-replicas. See https://github.com/github/gh-ost/pull/347
• support for --master-user and --master-password, for when master and replicas have different credentials.
• Add possibility to set server-id as command line flag - contribution by @cypiszzz, see https://github.com/github/gh-ost/pull/349
• --check-flag is a flag with which one can check if other flags are supported. Used for scripting and testing in lieu of evolving and changing versions. See https://github.com/github/gh-ost/pull/351

changes since 1.0.30: https://github.com/github/gh-ost/compare/v1.0.30...v1.0.32

notable:

• support for --ask-pass: interactive password input
• fixed PRIMARY KEY/UNIQUE KEY check

Many additions since 1.0.28. The ultimate breakdown is https://github.com/github/gh-ost/compare/v1.0.28...v1.0.30

Notable:

• Fixed cut-over stall: when cut-over happened to start executing even as lag or otherwise a throttling condition also emerged, a race condition would make the cut-over stall until throttling reason went away. The fix is that cut-over does not wait, and at worst, rolls back.
• fix to cut-over retries -- it didn't throttle properly in between and did not cleanup properly in between.
• cut-over timeout on "unknown" stalls. An example to "unknown" was the throttling problem described above. I don't know what other unknowns there are, but cut-over is now generically resilient to them.
• support for --skip-foreign-key-checks - can save inspection time, when one is certain no FKs actually exist
• Made column-rename detection heuristic more robust (it could wrongly infer a rename by some unfortunate comment or column-name)
• Reading and reporting replication lag before waiting on initial replication event -- this adds visibility in seemingly-hanging operations where the replica is lagging in the first place
• changelog table uses same engine as original table
• on startup, verifying replication works all all the way up to the master.