This weekend was a long one. We installed a new database server and copied all the data from the old server to the new one.
Then of course, we had to sync all the new data that collected on the old server while we were setting up the new server.
It was a time consuming process but we didn't have even one minute of down time over the weekend. The switch over was seamless.
The old server is becoming our backup server with instant data replication. This way, we no longer need to shut the site down for a couple hours each week to perform data backups. We can also run some of the more processor intense extract processes using the backup server instead of the live main server.
All these changes should mean more up time, faster response time and fewer issues long term.