News
Apr
8
cPanel - MySQL upgrade Sunday April 15, 2018
Posted by Barry Tarbet on 08 April 2018 01:54 PM

News Update;


All users currently on our cPanel servers - The MySQL will be updated from 5.6 to 5.7 next Sunday  15, 2018 - 

 

Features Added in MySQL 5.7

https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html#mysql-nutshell-additions


Please pay special attention to "SQL mode changes. Strict SQL mode for transactional storage engines (STRICT_TRANS_TABLES) is now enabled by default"

One of the major changes in MySQL 5.7 is the data integrity has been improved to be more in line with what veteran developers and DBAs expect. Previously, MySQL would adjust incorrect values to the closest possible correct value, where under the new defaults (strict mode) it will instead return an error instead of a warning. 

Meaning - when adding data, the tables are more strict, when data is being added to table, the data must match exactly as table is defined.

If you are using a recent version of Wordpress, Drupal, or Magento the good news is that you do not need to do anything.
These applications are already aware of MySQL's sql_mode feature and upon connecting to MySQL will set the options they are
compatible with. 

Those who are using custom php scripts, might have some problems with the update and should read further. 

 

Suggestions on How to Transition
If you are using a recent version of Wordpress, Drupal, or Magento the good news is that you do not need to do anything. These applications are already aware of MySQL's sql_mode feature and upon connecting to MySQL will set the options that they are compatible with.

If you are currently building a new application, then it may be a good idea to change the configuration of your existing MySQL 5.6 databases to behave with the sql_mode settings that are shipped in MySQL 5.7.

see https://www.digitalocean.com/community/tutorials/how-to-prepare-for-your-mysql-5-7-upgrade

  

Features Deprecated in MySQL 5.7
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html#mysql-nutshell-deprecations

Features Removed in MySQL 5.7
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html#mysql-nutshell-removals

 


If you have any questions, please don't hesitate to contact OccHosting Support and generate a support ticket by going to https://www.OccSupport.com


Thank you for your continual Support.


Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).