Server upgrade (Read 3615 times)

    Update: The server upgrade is tentatively scheduled for Monday at 9 PM EST (2 AM GMT). It should take about 2 or 3 hours. During this time, you will not be able to access any page on RA. Original Message: Hi folks, Some of you have noticed that RA is having sporadic performance issues lately. Its user base has grown to the point where the server is working every second of every day. RA has been running on its own server for several years now. The ever increasing load has put a strain on the server, resulting in unresponsiveness during peak hours (or whenever the Google bot feels like visiting). My original plan was to upgrade the server within a year but decided to upgrade it now. The new server arrived yesterday. It is a more capable machine and should be able to handle the load for years to come. I will put it through its paces this week and I'm planning to make the swap some time next week. I am planning to do the upgrade after 9 PM to reduce the number of users being affected by this. Hopefully it won't turn into an all niter because I'm too old and pampered to relive my college days. During the upgrade, RA will not be available. I do not know how long the upgrade will take because the bulk of the work involves moving the database, which has gotten quite large. I will do several dry runs before the actual upgrade and will get a better estimate of how long the upgrade will take. I will keep you updated on the status and the actually date. As always, let me know if you have any questions or concerns. eric :-)
    omatty


      Best of luck and thanks for your tireless efforts! I am loving the log since moving here from coolrunning Smile
        rock on and thank you!!!!!!!!!!
          Im a computer guy and know about moving Databases.......TAKE YOUR TIME......we can wait.... Great Web site - I love it... JohnA

          Champions are made when no one is watching

          lpopesc2002


            Thanks for all your hard work, RA ROCKS, I have only used it for 3 weeks, and I can not live with out it. Lauren Big grin


            Needs more cowbell!

              Hmmm...I can't remember when I last donated to the cause. So I'm off to the homepage to click the little PayPal button and support my favorite home on the net. Smile

              I shoot pretty things! ~

              '14 Goals:

              • 6 duathlons (1 Olympic distance)

              • 130#s (and stay there, gotdammit!)

                So should we all go in and export our training data just to be safe? Big grin
                  So should we all go in and export our training data just to be safe? Big grin
                  No need to export your data. Here's what's involved: I plug in the new server, which will have all the software installed on it. I would shut down the web server to prevent anyone from adding new data to the database. After that, I will copy the data from the old server to the new one. The data on the old server will not be touched. After the database is moved over to the new server, I will bring up the web server and we'll be good to go. If something goes wrong during the copy, I will bring the old server back up and figure out the next step. John A: I'm going to try two different methods of moving the db. I'm hoping that copying of the datafiles over would be sufficient. The alternative method is to do a db dump and then an import, which is very time consuming. eric Smile
                  NYSrunner


                    This sounds like a good direction for RA to take. But because I'm not very good at this "tech" stuff. I have a few questions...if someone could answer them that could be very much apperecitated. 1. All of this will not effect any of the data/entries already in the database...correct? 2. For the time being all we have to do is right down or record our runs somewhere else...until it's working again..and then we can just go back and fill in the missing entries...correct? And thanks a lot eric for all your efforts into making RA an amazing site!!
                      Im not going to answer for Eric, but I have done a lot of database transfers and upgrades (one just a few days ago).. First he will have a copy of everything (as is) when he starts...if for some reason it bombs out on him, he can just go back to the current server and nothing changes - he will just have to try again later.... If it works (which he has about a 99% chance of immediate success) nothing will change again.......for you.....except that you will probably notice that the server and web site are working a little quicker... All the data and entries in your logs will look just like they look now. If you try to enter something on the day he is transferring the data you wont be able to - so just remember it or write it down on paper for the day and enter it when the system is up (it wont be that long).... What he is doing is normally a pretty easy process - it just can be time consuming setting there watching the data copy......I doubt seriously if anyone has anything to worrry about.......JohnA

                      Champions are made when no one is watching

                      JillyBeans


                      Jiggle, jiggle, jiggle.

                        Good luck, Eric! Thanks for all your hard work and time that you've put into the best place on the web. Jilly
                        "The journey of a thousand miles begins with one step."


                        Needs more cowbell!

                          I doubt seriously if anyone has anything to worrry about.......JohnA
                          Especially because it's Eric doing the server switch. This place is his baby and he actually cares about fellow runners...and isn't out to make a buck. Smile

                          I shoot pretty things! ~

                          '14 Goals:

                          • 6 duathlons (1 Olympic distance)

                          • 130#s (and stay there, gotdammit!)

                          KNIGHTY


                          KNIGHTY

                            keep the good work up


                            Gandalf the Grey

                              Especially because it's Eric doing the server switch. This place is his baby and he actually cares about fellow runners...and isn't out to make a buck. Smile
                              ... but new servers cost money.... Just saying. Paypal buttons help alleviate financial pain. Smile Neil Smile

                              Running ... just keep running!
                              Fancy a holiday running in the French Alps?