On its official website, SiteGround announced that it has managed to upgrade over three million databases. Updating its servers to the new MySQL version 8.
An update that technically may not be noteworthy but is actually a very particular way of managing this aspect. Usually, database updates to the various versions of MySQL happen automatically. But then it is up to those who actually manage the websites to try to be compatible with the new features.
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 could also take inspiration from.
How SiteGround Made the Upgrade of the Century
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.
Currently, all Middle East countries are developing economically. Especially Qatar, Kuwait, Saudi Arabia, these countries are now famous and developed. So many businessmen are now doing business in these countries. Therefore, to increase business middle middle east mobile number list east mobile number list in these countries, it is necessary to have phone number data of these countries. Brother Cell Phone List is a large database provider company. We have been selling phone number data of all countries with reputation. The data provided by us is verified. You can purchase the data from us if you want.
siteground sites databases updated
MySQL 8, SiteGround has completed the supreme update – sos-wp.it
Then the experts manually checked that benefits of online marketing services for businesses 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 bh lists 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.
Everything was done in a precise manner and this minimized the disruptions that could have occurred if the update had been launched without any preparation work. The numbers that SiteGround reports are therefore to be celebrated. We want to focus on a single number: 63 . The number of total days that were used for the migration of all databases.
An example to be applied elsewhere too
What is striking in the report made on the official SiteGround website is that the phases of the path that led to the update have been detailed. And it is on one phase in particular that we want to emphasize. The preparation and analysis phase.
When performing upgrades
you should always try to have a clear picture, even if only theoretically, of what might not work anymore. And then you need to perform targeted tests to quickly identify anomalies and correct them.
This should be the path you should follow
When you decide to update your WordPress site . Even for example, the new version of a plugin , the installation of a different theme, the movement of resources can generate situations in which the website no longer works properly. To avoid wasting time later what you need to do is prepare.
Preparation, when managing a website, is never a waste of time. Because it prevents you from having to work in emergency situations. In some circumstances you can work independently. And the WordPress platform allows it.
However, if you think the updates you need to make are important. Then it would be best to ask for support from specialized personnel . Regardless, always remember to perform a backup before any major upheaval of your online presence.
