cp.blacknight.com control panel maintenance

Message

Summary: Some people may have noticed that cp.blacknight.com has been getting slower and slower over the past 2 months. This is despite us spending a lot of money on new hardware just for this application. Tonight  / Tomorrow (Oct 13th @ 3am) morning we're going to be working on the back end database to reduce it's size, ensure all indexes are in place and vacuum the tables.

Update 08:10 13/10/10: This work is completed and was 100% successful. The database is now a 10th of it's original size which is much more manageable.

When: Tonight / Tomorrow morning from 2am Irish time on October 13th until 6am October 13th. The work will occur inside this window.

Details: This UI is split into two distinct different applications each with their own dedicated hardware.

1) CP which runs a java application which provides the cp interface via apache/mod_jk
2) CORE node which runs the back end for the control panel and handles provisioning and all the magic that makes the cp tick.

On the core node we've noticed a number of tables in the DB have grown to unmanageable sizes. For example 1 table that people use everyday is now 24GB in size!, there's 100s of tables in the database.

Tonight starting at 3am Irish time Parallels engineers are going to perform this maintenance, they've estimated around 30 minutes but we suspect it may take upto 2 hours due to the sheer size of the database in question.

Services affected: cp.blacknight.com - no customer services, web services, email etc will be affected by this. You simply won't be able to login and perform any actions in your account until this maintenance window has been concluded.