IMPORTANT: Migration to the new database and outages

  • This topic is empty.
Viewing 15 posts - 1 through 15 (of 21 total)
  • Author
    Posts
  • #396427
    Farottone
    Keymaster

      As you probably all know by now, we are migrating to the new database, and this will cause some prolonged outages. The move, which is very delicate and complex, will require 5 steps:

       

      1. Shutting down the current database and C3U authors access

      During this phase, authors will not be able to upload new content and will not be able to access the C3U Dashboard and related pages. Players will not be able to access the database but they will be able to download content from the current links if hosted on C3U. Obviously any content hosted outside C3U will not be affected.

       

      2. Migrate all content to the new infrastructure

      We need to move all data currently hosted on the old infrastructure to the new one, converting all data to the new format. Everything from step 1 still applies. We can’t allow access again until we have verified that all data has been properly imported.

       

      3. Open up the new DB in read-only format

      Once migration is done, the new DB will be accessible to anyone but only to browse, not to add any content. During this phase we need authors to do a thorough check of their content. Everything from step 1 except database browsing still applies.

       

      4. Move C3U Dashboard to the new framework

      Before we can once again allow uploads we need to move C3U to the new framework. Everything from step 1 except database browsing still applies.

       

      5. Go back to full access

      Once everything works as expected we can allow once again uploading, C3U access, etc.

       

      Step 1 will begin in 1 to 7 days, meaning it can start from today up to next Saturday. We can’t say how many days of restricted access we’re gonna have: the more we get help identifying issues in step 3, the sooner we can open access.

       

      After all of this is done, the new DB will still have some limitations in terms of options and functions that we will remove during the following weeks.

       

      Thank you for your patience and see you all on the other side of the DB!

      #500699
      BornGamerRob
      Participant

        #500704

        Hope that this goes smoothly for you, sounds like quite a feat!

        #500707
        imac007
        Participant

          Hope all goes well….

           

          Will this mean the return of the wii version links(from the legacy database) that seem to have disappeared?

          #500714
          Sideshow
          Participant

            Thanks for the announcement of the database going down. That database contains some of the most fun you can have in music video games today. Best of luck on the migration.

            #500725
            MrPrezident
            Moderator

              Fingers crossed <img decoding=” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif” /> Best of luck on the big migration

              Keeping the content Canadian since 2017!

              SomeOldGuys: https://db.c3universe.com/songs/all/__user/someoldguys
              MrPrezident: https://db.c3universe.com/songs/all/__user/MrPrezident

              #500726
              AJFOne23
              Participant

                thank you for thinking of metal month and getting this done before hand <img decoding=” src=”/wp-content/uploads/invision_emoticons/default_SA_biggrin.gif” /> :rock:

                #500737
                T3HM3T4L
                Participant

                  My local roadworks aren’t even this properly outlined. :v:

                  #500752
                  Anonymous

                    I hope things get better as soon as possible.

                    #500754
                    Bansheeflyer
                    Moderator

                      I know I’ve said this a lot but I think it’s very important to reiterate. Thank you very much for all this work that you’ve put into the new DB. Between your regular job and home life I can’t imagine the amount of time and resources you’ve been managing to make it all work. I know this has taken a lot of effort and I cannot express how much I appreciate all you’ve done to not only keep supporting C3, but to continue upgrading and improving an already great resource for customs.

                       

                      Again thank you for all your work and for keeping customs alive!

                       

                      Also thanks to all of those who have helped test the new DB. The time you guys have taken to make sure the bugs are ironed out is also much appreciated.

                      #500758
                      ghostbyob
                      Participant

                        The dedication and the passion to bring a better place to work and share is awesome, you’re one of the best admin that I’ve met.
                        Thank you a lot for all you do for us!

                        #500773
                        Farottone
                        Keymaster

                          Thank you all for your support, I really appreciate it. An update will be up soon.

                          #502873
                          Farottone
                          Keymaster

                            IMPORTANT ANNOUNCEMENT

                             

                            So, a long time has passed and no new DB is available: what’s happened?

                            First of all, I make it a point to always deliver when I commit so I’m very frustrated that this has not happened yet. It’s entirely on me and I feel really bad I didn’t deliver. With that said, back to “what’s happened?”…

                            What happened is that after laying out the path to switch over to the new DB I realized a number of things needed more attention simply to detach the whole system from the old DB to port it to the new DB. I also realized that there was no going back: once we are off to the new DB we can’t switch back. All of the above, combined with the fact that the new system is 10 times more complex and all integrated than the current one, made me realize that from the moment we switch to the new DB to the moment when everything is set up and working perfectly I have to essentially be on call for any issue. If I can’t address an issue and fix it quickly, people can’t upload new songs or, even worse, songs are uploaded with issues that we carry over for all songs until I realize something is wrong.

                            All of this has happened while I had to devote even more time to work and I had to choose:
                            1) leave the current DB for the new one which is cooler, more complete, etc. but jeopardize daily/weekly releases and possibly block new releases for a while if anything goes wrong
                            2) keep the current DB and not risk anything

                            As you already know I had to choose option 2 for now. So what now? The next window is realistically at the end of Leg 2 and I’ll try to free some time in case of emergencies then. I’ll do my best, I just need to put work first though because this is a critical moment for me and I can’t lose focus there.

                            So, finally, I’m very sorry I couldn’t deliver on the promise I made: I always deliver if I commit so I’m very frustrated, also because of the time other people spent helping me out. However I couldn’t foresee both problems that intervened and if I could I wouldn’t even have started development. Come May we’ll readdress this and hopefully things are better than they are now…

                            Thank you for your patience

                            #502874
                            BornGamerRob
                            Participant

                              I get the personal letdown feeling since I’m the same way, but honestly, you made the right choice and this can wait. You continue to do a ton of work when most would have abandoned it. So as far as I’m concerned, nothing to apologize for (but you’ll still feel the need out of integrity 😊). I still look forward to the new changes WHENEVER they come. Thanks again for your work.

                              #502876
                              Atruejedi
                              Participant

                                I get the personal letdown feeling since I’m the same way, but honestly, you made the right choice and this can wait. You continue to do a ton of work when most would have abandoned it. So as far as I’m concerned, nothing to apologize for (but you’ll still feel the need out of integrity ). I still look forward to the new changes WHENEVER they come. Thanks again for your work.

                                 

                                This. The current database is the cake we all know and rely on to get our fix of the sweet songs and tasty tunes we crave. A new database is just icing. Yeah, I’ll gorge myself on the whole container and develop adult-onset diabetes when it arrives, but I can wait. If you’re gonna do something, do it right. Let that bitty bake s’more.

                              Viewing 15 posts - 1 through 15 (of 21 total)
                              • You must be logged in to reply to this topic.
                              Back to top button