How SiteGround Made the Upgrade of the Century

Self-hosted database solution offering control and scalability.
Post Reply
shaown
Posts: 17
Joined: Tue Jan 07, 2025 4:41 am

How SiteGround Made the Upgrade of the Century

Post by shaown »

As the post on the official SiteGround website explains , the transition was taken care of in detail in order to avoid disruptions. A story that allows us to look at a way of interfacing with your customers that you greece phone number could also take inspiration from.

The account of what the experts at SiteGround did begins with the admission that the upgrade to MySQL was a decision made after weighing several options . And before moving on to their approach, they tell us about the two lines of action that are usually seen. On one side, there are the hosting companies that decide to just upgrade the new servers and then let the customers, i.e. the website owners, make the transfer.

On the other hand, there are those who activate new versions of MySQL without checking whether this will affect the performance of the server and therefore of the sites. However, updating is important for everyone. Having a version of MySQL that is too old is in fact a security risk. And this is where SiteGround's slightly different approach comes in.

An approach that started from an analysis of the incompatibilities when the sites were updated to MySQL 8. This was followed by a period of testing with some servers , which were put to the test with the most varied configurations in such a way as to have a whole range of possible errors that could be prevented when they occurred on the real sites.

The third step was then the automated update and correction based on the test results. The automated work, the blog post analysis continues, quickly removed the errors, saving hours and hours of manual work. But it is clear that not everything could be left to automation.

siteground sites databases updated
MySQL 8, SiteGround has completed the supreme update – sos-wp.it
Then the experts manually checked that all the sites were working . In total, just over 7500 sites were identified that had not appreciated the upgrade to the new version of MySQL and the problems in these cases were solved by the experts but for a very small number of websites.

For those sites whose configuration is not compatible with the update at all, two months have been given (at SiteGround's expense) to perform the necessary operations to be able to be updated and switch to the new databases.
Post Reply