MySQL maintenance window wednesday night
Par anarcat le samedi 28 février 2009, 14:01 - en - Lien permanent
Who is affected
All the sites hosted on our shared hosting servers.
What will happen
During the planned maintenance window, MySQL services will be slower than usual while the secondary server takes over the primary one. This will mainly affect websites, which will all see a slowdown, maybe even complete outages.
Why
The main objective of the intervention is to test the capacity of the main server when idle, without any traffic, to compare it against the new server we are in the process of configuring as a replacement.
We also wish to test the capacity of the secondary server and the abilities of the sysadmin team to be able to proceed quickly with such an intervention, without being pressed by an actual emergency.
How
To proceed with those tests, we will turn off the main server and redirect all traffic to the secondary server. Since that server is of lesser capacity, substantial performance hit will be observable on our main servers.
The details of the operation are available on this page:
https://wiki.koumbit.net/RapportsIntervention/2009-02-04
If the operation takes longer than expected, we will announce it on http://offline.koumbit.net/
I object!
If this operation is too problematic for you or your organisation, please let us know within 24h to see if we can take appropriate workarounds.
Commentaires
The maintenance took a bit longer than expected (15 minutes, finished at 00:47EST instead of 00:30) and caused a general service outage, the secondary database server not being strong enough to assume the load all by itself anymore.
A more complete analysis of the benchmarks will be performed tomorrow.