In a year 2020 some versions of the SQL databases will cease to be supported. Bellow you can find more information that will help you prepare for this update and help you secure compatibility of your website with a new version.
Date of update
| Database version | Date of update | New version |
|---|---|---|
| MySQL 5.0 | from 24.8.2020 | MySQL 5.7 |
| MySQL 5.1 | from 22.9.2020 | MySQL 5.7 |
| MariaDB 5.5 | Q4 2020 | MariaDB 10.3 |
| PostgreSQL 9 | Q4 2020 | PostgreSQL 10 |
Update will be done automatically and current login details to the database will remain. Change in the application/website thus won’t be necessary.
Manual update
If you prefer more control, manual update of your database is available already. (link to Migration/update of MySQL databases article).
Manual migration will transfer your database to a different server – login credentials will change. Therefore it is necessary to update them in your application/website with a new hostname, port, database name, database user and password.
- Connecting WordPress to a different database
- Connecting Drupal to a different database
- Connecting Joomla to a different database
- Connecting PrestaShop to a different database
Web compatibility and changes
If you are using modern content management system like WordPress you website should work without issues with new SQL versions. All most popular CMS are fully compatible with these databases – you just need to use newest versions along with newest versions of plugins and themes.
- https://wordpress.org/about/requirements/
- https://www.drupal.org/node/3044215/requirements
- https://devdocs.prestashop.com/1.7/basics/installation/system-requirements/
- https://docs.opencart.com/requirements/
Official documentation of changes
If you are using tailored website/application, you may find useful official documentation and change description between versions.