This Wednesday we’ll be upgrading the storage for the database servers in the New York data center. During this window we hope to have less than a minute of downtime during the failover sometime mid-day and the same again when failing back.
Currently we have 6x 200GB drives for data in our Dell R710 servers (Intel 710 200GB drives, plus 2 others for the OS). These servers are NY-SQL03 and 04. They will be getting upgraded to 4x Intel S3700 800GB drives a piece, in a RAID10. This leaves room for 2 more later if space is needed before the next SSD generation.
Those 12 left-over Intel 710s will be joining the already present 13 drives in each of NY-SQL01/02 (Dell R720s), which each have a 12x 200GB RAID10 + hot spare. Currently this leaves room for 11 more drives in each server. After the upgrade they’ll have a 18x 200GB RAID10 + hot spare for primary data.
We’ll upgrade 04, move drives and upgrade 02, then fail over to those replicas. After that, we’ll repeat the procedure on 03 and 01, failing back to them likely later in the day. While we’re powering them down (quite rare now), we’ll be installing 10GB NICs in each server, but won’t be activating them quite yet.