Applies to: Windows Hosting (Plesk)

Windows Hosting (Plesk) Help

MySQL version change on Windows Hosting

Warning: Always back up your databases before making any changes to them.

At GoDaddy, we're committed to providing a secure, high-performance, and innovative hosting experience. To help you stay ahead of the curve and take advantage of the latest database improvements, we are excited to announce an upgrade from MySQL 5.7 to MySQL 8. This upgrade offers enhanced security, improved performance, and new features that empower your applications with modern database capabilities.

What's changing?

We're upgrading our MySQL environment from version 5.7 to MySQL 8. This upgrade is a seamless enhancement to provide state-of-the-art functionality and reliability. If your projects run on MySQL 5.7, please know that your databases will soon need to transition to MySQL 8 for continued smooth operations.

Key benefits of MySQL 8:

  • Modern Security Enhancements: MySQL 8 includes several security improvements, such as better default authentication, improved encryption, and enhanced auditing features that help protect your data better.
  • Performance Improvements: Expect faster query execution, more efficient caching, and smoother performance through optimized indexing and improved query processing.
  • Advanced Features: Enjoy new functionalities like window functions, common table expressions (CTE), and JSON enhancements that simplify complex data operations and improve developer productivity.
  • Scalability and Reliability: Designed for modern applications, MySQL 8 supports better scalability and high availability, ensuring your applications grow with your business needs.

What should I know?

While the upgrade brings many advantages, it’s essential to be informed about some potential challenges you may encounter:

  • Compatibility Adjustments: Certain SQL syntax and functionalities have been updated or deprecated. This might require adjustments to your existing queries or applications.
  • Migration Testing: It is crucial to perform thorough testing in a development or staging environment before moving your production databases to ensure that all functionalities work as expected.
  • Backup Necessity: Always create a comprehensive backup of your databases before initiating the upgrade. This precaution will help safeguard against unforeseen issues during the transition.

How do I prepare for the upgrade?

  1. Identify Affected Databases: Review your hosted applications to determine which applications and databases are still running on MySQL 5.7.
  2. Review Application Compatibility: Analyze your application's database interactions and SQL queries to identify any compatibility issues arising from the change.
  3. Backup Your Data: Ensure that you have up-to-date backups for all your databases. This is a critical step to prevent data loss during the upgrade process.
Warning: Although upgrades are designed to enhance your systems, neglecting proper testing and backup procedures could lead to unforeseen disruptions. If you're unfamiliar with this process, please consult a professional developer.

More info

Disclaimer: Our GoDaddy support team can assist with your hosting needs. However, they cannot modify your application code or handle code-based migration tasks. For further guidance, please consult with a professional developer.

Share this article