Preparing for MySQL 8.0 Upgrade: Essential Steps for WP Engine Sites

Play video
This article is a summary of a YouTube video "WP Engine Webinar: Preparing for MySQL 8.0" by WP Engine
TLDR WP Engine sites will be upgraded to MySQL 8.0 and users should prepare by updating plugins and themes, testing site functionality, and reaching out to support for assistance.

Key insights

  • ⏰
    There will be dedicated time at the end of the webinar for question and answer sessions, allowing participants to ask their queries and get them addressed.
  • 💻
    Upgrading to MySQL 8.0 ensures security and stability for WP Engine customer sites, as it is the most stable version with all known bugs addressed.
  • 💼
    Testing key functionality areas like the checkout process and specific site content is crucial for businesses when upgrading to MySQL 8.0.
  • 🕒
    WP Engine will handle the upgrade process for MySQL 8.0, saving users time and effort.
  • 📧
    Being able to test key site functionality before the upgrade can help address concerns and ensure a smooth transition.
  • 💡
    WP Engine recommends using Local to replicate the environment on your machine for testing specific site functionality before upgrading MySQL versions.
  • 📚
    WP Engine conducts thorough compatibility testing to ensure that key functionalities like the WP Admin page and homepage come up after the upgrade.
  • 💡
    The recommended workflow for testing MySQL 8.0 is to set up a local environment using user-friendly software like Local.

Q&A

  • What is the purpose of the webinar?

    — The webinar is about preparing for the upgrade to MySQL 8.0 and discusses the testing process in Local.

  • How can I update my plugins and themes?

    — Ensure that your plugins and themes are up-to-date before the upgrade window to avoid potential issues and incompatibilities.

  • Who will handle the upgrade to MySQL 8.0?

    — WP Engine will handle the upgrade to MySQL 8.0 for users and verify that sites are functioning properly afterwards.

  • What is Local and how can I use it?

    — Local is a WordPress development tool that allows users to easily spin up and test sites on their own machine, regardless of whether they are hosted on WP Engine or not.

  • How can I troubleshoot errors after the upgrade?

    — To troubleshoot errors after upgrading the database and changing the PHP version, turn on Xdebug for detailed logs and check the logs folder in the site folder for any errors.

Timestamped Summary

  • 📹
    00:00
    The webinar is about preparing for MySQL 8.0, with the panel introducing themselves and discussing the upcoming upgrade and testing process in Local.
  • 📅
    02:46
    WP Engine sites will be upgraded to MySQL 8.0, the most stable and secure version, so make sure plugins and themes are up-to-date, test key site functionality, and reach out to support for assistance.
  • 📝
    08:15
    Local is a WordPress development tool that allows users to easily test sites on their own machine, and it is recommended for testing compatibility with MySQL.
  • 📝
    11:10
    WP Engine allows users to easily set up and test their site using Local, which automatically sets up a PHP server, MySQL 8, and Engine X, and allows for selective file inclusion when pulling from the website, making it convenient for testing and troubleshooting.
  • 📧
    17:25
    Users will receive upgrade emails 2 weeks before the upgrade window, and they should test site functionality and contact support for any compatibility questions; WP Engine offers assistance and a reference code for technical support, but users must use Local to test and download their site as WP Engine does not currently offer MySQL version upgrades.
  • 📅
    23:24
    WP Engine offers assistance and resources for a smooth transition to MySQL 8.0, recommending testing in a local environment and addressing issues with outdated plugins, while providing flexibility in choosing upgrade windows and options for importing large sites.
  • 📝
    28:08
    Running Local and Docker simultaneously may cause conflicts, so it's recommended to only run one at a time; upgrading to MySQL 8.0 may result in downtime depending on database size, typically within a 6-hour window; WP Engine portal allows testing compatibility, and a solution is being developed for testing on production servers.
  • 📝
    31:56
    WP Engine will install the latest version of MySQL available, separate from PHP upgrades, and it is recommended to update plugins and themes and test them individually; contact support for assistance with errors and test key site functionality in WordPress.
Play video
This article is a summary of a YouTube video "WP Engine Webinar: Preparing for MySQL 8.0" by WP Engine
4.7 (5 votes)
Report the article Report the article
Thanks for feedback Thank you for the feedback

We’ve got the additional info