A few weeks ago we started the upgrade to MySQL 8 on our servers. This was the result of a long process of monitoring and testing the compatibility of this version with our customers’ sites, until we concluded that MySQL 8 is highly compatible with the main applications hosted on our platform.
MySQL is a core software in our stack, used by most of our customers to power their databases. Its optimal functioning has a great impact on the overall performance and availability of the website. That is why the SiteGround team dedicates a lot of resources to optimize and customize our MySQL, always aiming for better performance. To achieve this, we have introduced various customizations over the years such as our unique MySQL configuration and we carefully plan and test any new MySQL version upgrade, ensuring that the benefits outweigh the potential harms such an upgrade may bring. We are now confident that MySQL 8 is widely compatible and our customers can safely benefit from the improved database performance, scalability and coding optimizations that come with it.
What is the plan for MySQL upgrade?
First, we would like to announce that all new sites created on our shared servers and all newly created cloud accounts now ship with MySQL 8 by default.
Secondly, we are currently in the process of Croatia Email Database migrating our existing shared sites to MySQL 8. Once our shared servers are upgraded, we will begin upgrading our Cloud instances as well. This process will continue over the next few months. Our plan is to have all of our customers migrated to MySQL 8 by the end of June this year.
To make the transition as easy and seamless as possible, we will send you an email at least a week in advance to let you know the exact dates we will be upgrading your website to MySQL 8. The upgrade process is performed late at night when traffic to the server is minimal. There may be a brief interruption in service while the software is being upgraded. No action is required on your part in relation to the migration.
What’s new in MySQL 8?
MySQL 8 introduces a variety of new features and enhancements to old features, all aimed at improving overall performance and scalability, as well as the developer experience. Here are some of the most notable.
Better performance and scalability
MySQL 8 offers better performance and scalability. Benchmark tests show better results in both performance and scalability for MySQL 8 compared to MySQL 5.7. The tests show that MySQL 8 handles read/write operations much better and the number of transactions processed is much higher.
Additionally, tests show that MySQL 8 utilizes the Buy Email Database List hardware much better than 5.7. Here are some of the improvements that make this possible:
Scalability of read write workloads MySQL 8 shows better performance under heavy read/write loads and observes more than 2x better performance under heavy loads compared to MySQL 5.7.
Better performance with high conflict loads
Performance for high-contention workloads has been significantly improve in MySQL 8. A high-contention workload occurs when multiple transactions are waiting for a lock on the same row in a table, causing queues of waiting transactions.
In MySQL 8, these bursts are handle much Bulk Database better in terms of transactions per second and latency. This leads to better hardware utilization (efficiency), as the system needs fewer spare resources and can therefore operate at a higher average load.
Native partitioning/InnoDB pool enhancement
MySQL 8 supports native partitioning for the InnoDB engine. This allows you to split large tables into smaller partitions. This can improve query performance and reduce storage requirements, especially for large tables. The new version of MySQL also introduces improvements to the InnoDB pool. The pool is responsible for caching data and reducing I/O operations.
