As I'm sure many of you noticed R3V was down for around 9 hours last night. As I'm sure many of you have ALSO noticed is that R3V's forum performance has been going downhill somewhat drastically over the past 6 months.
Last night I spent 11 hours prepping and installing our two additional servers to help spread the load of this site. For 6+ years R3V has been ran on a single Xeon Supermicro 1U Server without much issue, however users searching the forum, uploading attachments, etc started taking its toll on the servers internal hard disk array. For Instance when one person searched the forum, the server would start backing up on site load requests because it had to wait for the hard drives to become available again (SATA is slow kids!)
New to the stable is a dedicated Dual Operton/SCSI MySQL Database server, which has one goal in life, handle the database.
Additionally is another Web Frontend server. These servers are designed to handle the actual webpage load requests, and serve out the PHP that this site is designed upon. The old R3V Server has become a Web Frontend Server (as the database moved)
In my testing I can already see a huge jump in site performance, and just browsing around, logging in, etc I can see a massive jump in performance.
Here are a few pictures I snapped with my cellphone while this was going down. The R3VLimited Facebook Fan Page provided me some entertainment, but not as much as the forum itself.
Prepping the new web frontend server on the left, copying the existing database to the new Debian/MySQL server on the right
The database server copying away and running a full DB integrity check before I turn the site back on
Watching progress bars / paint dry / water boil was much of my entertainment for the evening.
Remaining time was stuck at 4 min for a very long time. In the end it took over 3 hours to restore the database to the new server and verify integrity.
Everything bolted into the rack and serving the site you enjoy everyday.
Enjoy everyone! If anything seems off shoot me a PM or post in the Suggestions forum and I'll take a look!
Last night I spent 11 hours prepping and installing our two additional servers to help spread the load of this site. For 6+ years R3V has been ran on a single Xeon Supermicro 1U Server without much issue, however users searching the forum, uploading attachments, etc started taking its toll on the servers internal hard disk array. For Instance when one person searched the forum, the server would start backing up on site load requests because it had to wait for the hard drives to become available again (SATA is slow kids!)
New to the stable is a dedicated Dual Operton/SCSI MySQL Database server, which has one goal in life, handle the database.
Additionally is another Web Frontend server. These servers are designed to handle the actual webpage load requests, and serve out the PHP that this site is designed upon. The old R3V Server has become a Web Frontend Server (as the database moved)
In my testing I can already see a huge jump in site performance, and just browsing around, logging in, etc I can see a massive jump in performance.
Here are a few pictures I snapped with my cellphone while this was going down. The R3VLimited Facebook Fan Page provided me some entertainment, but not as much as the forum itself.
Prepping the new web frontend server on the left, copying the existing database to the new Debian/MySQL server on the right
The database server copying away and running a full DB integrity check before I turn the site back on
Watching progress bars / paint dry / water boil was much of my entertainment for the evening.
Remaining time was stuck at 4 min for a very long time. In the end it took over 3 hours to restore the database to the new server and verify integrity.
Everything bolted into the rack and serving the site you enjoy everyday.
Enjoy everyone! If anything seems off shoot me a PM or post in the Suggestions forum and I'll take a look!
Comment