When: Jan 31, Feb 1st, 2nd, & 3rd, 2006
Duration: Less than 10 minutes per domain
Software Upgrade: MySQL Upgrade From MySQL v.3.23.56 to v.4.0.25
Hardware Upgrade: Server Upgrade from MYSQL03 to MYSQL01
FutureQuest has upgraded both the MySQL version and the server hardware on the recently rebuilt MYSQL01 Server. All MySQL Databases currently residing on the MYSQL03 Server will now be moved to the newly upgraded MYSQL01 Server. This move will result in the MySQL Services, that are provided to databases currently residing on the MYSQL03 server, being upgraded from MySQL v.3.23.56 to MySQL v. 4.0.25
The move for each domain should not take more than 10 minutes to complete. However, it is important to note that while the databases are being moved, the MySQL services for that domain will not be available.
The server your MySQL Databases are located on can be found by visiting the MySQL Manager within your CNC. The temporary hostname listed begins with the Server Name (MySQL01 or MySQL02 etc). An email notice is also being sent to all Technical and Alert/Primary contacts for each package that currently has databases on the MYSQL03 Server. If you have databases on MYSQL03 and do not receive the email by morning, you may wish to contact us to find out why.
The recommend hostname can be found in the CNC's MySQL Manager. It usually looks like: MySQL.example.com where example.com is replaced with your own domain name. If your scripts use the recommended hostname to connect to the MySQL Server, and FutureQuest manages the DNS for your domain, then the move should not have any adverse affects.
You should use the recommended hostname at all times wherever possible. However, if your scripts are not using the recommended hostname, e.g. they use the Server IP Address or the Server Name instead, then you should update them NOW to prevent failures after the move.
If there is a reason you are unable to use the recommended hostname, such as the DNS not yet being modified, you will need to make note of the following changes and implement them within your scripts after the move has been completed.
Current MYSQL03 Server Info:
After the move it should be changed to:
NEW MYSQL01 Server Info:
IP......: IP: 126.96.36.199
If you manage your own DNS and you are using the recommended hostname to connect to MySQL you will need to update the DNS entry to reflect the IP address for MySQL01. You may also send an email to the service desk requesting a specific date and time frame to be assigned to your account's MySQL move to be completed.
Again, for most this move should not require any changes on your part. However, if you do not use the recommended hostname or you manage your own DNS, then you should pay special attention to the changes explained above and within the email that is being sent out concerning this upgrade.