Skip to content

# gh-ost 1.0.42 released: JSON support, optimizations

MySQL gh-ost Open Source September 14, 2017September 15, 2017

gh-ost 1.0.42 is released and available for download.

### JSON

MySQL 5.7’s `JSON` data type is now supported.

There is a soft-limitation, that your `JSON` may not be part of your `PRIMARY KEY`. Currently this isn’t even supported by MySQL anyhow.

### Performance

Two noteworthy changes are:

- Client side prepared statements reduce network traffic and round trips to the server.
- Range query iteration avoids creating temporary tables and filesorting.

We’re not running benchmarks at this time to observe performance gains.

### 5.7

More tests validating `5.7` compatibility (at this time GitHub runs MySQL `5.7` in production).

### Ongoing

Many other changes included.

We are grateful for all community feedback in form of open Issues, Pull Requests and questions!

`gh-ost` is authored by GitHub. It is free and open source and is available under the MIT license.

### Speaking

In two weeks time, Jonah Berquist will present gh-ost: Triggerless, Painless, Trusted Online Schema Migrations at Percona Live, Dublin.

Tom Krouper and myself will present MySQL Infrastructure Testing Automation at GitHub, where, among other things, we describe how we test `gh-ost` in production.

- Twitter
- LinkedIn
- WhatsApp
- Email
- Facebook
- Print

###
4
Leave a Reply

3 Comment threads
1 Thread replies
0 Followers
Most reacted comment
Hottest comment thread
2 Comment authors
Recent comment authors

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe
Notify of
Guest
Gillian Gunson

“Range query iteration avoids creating temporary tables” and *filesorting* on them. You could probably sell it better by mentioning the avoiding filesort 😉

Guest
Shlomi Noach

Edited, thanks!

Log Buffer #522: A Carnival of the Vanities for DBAs – Cloud Data Architect

[…] 1.0.42 released: JSON support, […]

This Week in Data with Colin Charles #6: Open Source Summit and Percona Live Europe - Percona Database Performance Blog

[…] gh-ost 1.0.42 released: JSON support, optimizations – in addition to the release, the little hint that GitHub itself is powered by MySQL 5.7 in production is great news […]

wpDiscuz
Send to Email Address Your Name Your Email Address Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.