The Most Popular MySQL 5.7 Features


Three events into the new year and I have been getting a lot of feedback from you all on MySQL 5.7. So far there are some changes in 5.7 that are very popular.

The change in username name length from sixteen to thirty two characters seems to be universally loved. Yea!!!

The new JSON data type has caught a lot of attention. A few of you think that data should be normalized as Codd intended and find that simple shoving a document into a column is an no-no. But the vast majority love this new feature. Many ISPs are going to have to upgrade to get to 5.7 to meet demand for this new data type.

Generated columns seem to be a hot spot for several of you. Usually you do not see a lot of business logic in MySQL databases compared to, say, an Oracle database. And if there is some sort of business logic then it is implemented with a trigger. I have had some intense discussions with some folks who are going to be doing very interesting things with generated columns.

The least popular? Not being able to run 5.7 in a half gig, low cost rented environment. (How did I ever get by with 384k words in a Dec-10 or 640k with DOS??) The secure by default is causing come problems with folks who have spent decades without a forced root password and automatic expiration of password is being tackled by MySQL Engineering as it is currently seen as too drastic by some customers.

So thank you folks who came out to SkiPHP, San Diego PHP, and SCaLE in the past few weeks. Please let me know you feelings on MySQL 5.7 at FOSDEM, SunshinePHP, and RMOUG training days!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s