Catching up on MySQL


#1

Hello everyone. I have been away from the LAMP scene for a couple of years and am trying to get caught up.

I had a website in local develop on my old Mac about 2 years ago, and am now trying to figure out how to get that online.

My website was developed using MySQL 5.5.38 and the latest version of MAMP has MySQL 5.7.23

Since I was away, I hear that Oracle took over MySQL and that made a lot of people jump ship because they fear it will no longer be open-source?

I also heard there is some new open-source database called mariaDB?

Finally, Oracle has put out (or will put out) MySQL 8.0 soon?

I guess my main question is… Can I safely run MySQL 5.7.x in production on my webserver and have a solid and secure database in place?

Thanks!


#2

Oracle aquired Mysql 8 years ago which led to the fork MariaDB. You can still pretty much just point your app to a MariaDB server instead of a Mysql server. There are a couple of things that may be different but in my experience hitting one of those are rather extreme edge cases and not something you will have problems with in your average app.

Latest 5.x MySQL version is 5.7.24, doesn’t seem to be any security issues between .23 and .24. Version 8.x was released in April so as always it’s recommended to upgrade. You can rather easily try your app with a 8.x server and see.


#3

What changes occurred between MySQL 5.5 and 5.7?

I assume I should at least update to MySQL 5.7


#4

Changes in MySQL 5.6.43 (Not yet released, General Availability)

Changes in MySQL 5.6.42 (2018-10-22, General Availability)

Changes in MySQL 5.6.41 (2018-07-27, General Availability)

Changes in MySQL 5.6.40 (2018-04-19, General Availability)

Changes in MySQL 5.6.39 (2018-01-15, General Availability)

Changes in MySQL 5.6.38 (2017-10-16, General Availability)

Changes in MySQL 5.6.37 (2017-07-17, General Availability)

Changes in MySQL 5.6.36 (2017-04-10, General Availability)

Changes in MySQL 5.6.35 (2016-12-12, General Availability)

Changes in MySQL 5.6.34 (2016-10-12, General Availability)

Changes in MySQL 5.6.33 (2016-09-06, General Availability)

Changes in MySQL 5.6.32 (2016-07-29, General Availability)

Changes in MySQL 5.6.31 (2016-06-02, General Availability)

Changes in MySQL 5.6.30 (2016-04-11, General Availability)

Changes in MySQL 5.6.29 (2016-02-05, General Availability)

Changes in MySQL 5.6.28 (2015-12-07, General Availability)

Changes in MySQL 5.6.27 (2015-09-30, General Availability)

Changes in MySQL 5.6.26 (2015-07-24, General Availability)

Changes in MySQL 5.6.25 (2015-05-29, General Availability)

Changes in MySQL 5.6.24 (2015-04-06, General Availability)

Changes in MySQL 5.6.23 (2015-02-02, General Availability)

Changes in MySQL 5.6.22 (2014-12-01, General Availability)

Changes in MySQL 5.6.21 (2014-09-23, General Availability)

Changes in MySQL 5.6.20 (2014-07-31, General Availability)

Changes in MySQL 5.6.19 (2014-05-30, General Availability)

Changes in MySQL 5.6.18 (2014-04-11, General Availability)

Changes in MySQL 5.6.17 (2014-03-27, General Availability)

Changes in MySQL 5.6.16 (2014-01-31, General Availability)

Changes in MySQL 5.6.15 (2013-12-03, General Availability)

Changes in MySQL 5.6.14 (2013-09-20, General Availability)

Changes in MySQL 5.6.13 (2013-07-31, General Availability)

Changes in MySQL 5.6.12 (2013-06-03, General Availability)

Changes in MySQL 5.6.11 (2013-04-18, General Availability)

Changes in MySQL 5.6.10 (2013-02-05, General Availability)

Changes in MySQL 5.6.9 (2012-12-11, Release Candidate)

Changes in MySQL 5.6.8 (2012-11-07, Release Candidate)

Changes in MySQL 5.6.7 (2012-09-29, Release Candidate)

Changes in MySQL 5.6.6 (2012-08-07, Milestone 9)

Changes in MySQL 5.6.5 (2012-04-10, Milestone 8)

Changes in MySQL 5.6.4 (2011-12-20, Milestone 7)

Changes in MySQL 5.6.3 (2011-10-03, Milestone 6)

Changes in MySQL 5.6.2 (2011-04-11, Developer Milestone)

Changes in MySQL 5.6.1 (Not released, Milestone 5)

Changes in MySQL 5.6.0 (Not released, Milestone 4)

Changes in MySQL 5.7.25 (Not yet released, General Availability)

Changes in MySQL 5.7.24 (2018-10-22, General Availability)

Changes in MySQL 5.7.23 (2018-07-27, General Availability)

Changes in MySQL 5.7.22 (2018-04-19, General Availability)

Changes in MySQL 5.7.21 (2018-01-15, General Availability)

Changes in MySQL 5.7.20 (2017-10-16, General Availability)

Changes in MySQL 5.7.19 (2017-07-17, General Availability)

Changes in MySQL 5.7.18 (2017-04-10, General Availability)

Changes in MySQL 5.7.17 (2016-12-12, General Availability)

Changes in MySQL 5.7.16 (2016-10-12, General Availability)

Changes in MySQL 5.7.15 (2016-09-06, General Availability)

Changes in MySQL 5.7.14 (2016-07-29, General Availability)

Changes in MySQL 5.7.13 (2016-06-02, General Availability)

Changes in MySQL 5.7.12 (2016-04-11, General Availability)

Changes in MySQL 5.7.11 (2016-02-05, General Availability)

Changes in MySQL 5.7.10 (2015-12-07, General Availability)

Changes in MySQL 5.7.9 (2015-10-21, General Availability)

Changes in MySQL 5.7.8 (2015-08-03, Release Candidate)

Changes in MySQL 5.7.7 (2015-04-08, Release Candidate)

Changes in MySQL 5.7.6 (2015-03-09, Milestone 16)

Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)

Changes in MySQL 5.7.4 (2014-03-31, Milestone 14)

Changes in MySQL 5.7.3 (2013-12-03, Milestone 13)

Changes in MySQL 5.7.2 (2013-09-21, Milestone 12)

Changes in MySQL 5.7.1 (2013-04-23, Milestone 11)

Changes in MySQL 5.7.0 (Not released, Milestone 10)


#5

Wow! Ask a question get a LARGE answer! :wink:

Any obvious changes from 5.5 to 5.7? (I believe my current database is pretty “plain vanilla”.)