1. Hello!

    First of all, welcome to MapleLegends! You are currently viewing the forums as a guest, so you can only view the first post of every topic. We highly recommend registering so you can be part of our community.

    By registering to our forums you can introduce yourself and make your first friends, talk in the shoutbox, contribute, and much more!

    This process only takes a few minutes and you can always decide to lurk even after!

    - MapleLegends Administration-
  2. Experiencing disconnecting after inserting your login info? Make sure you are on the latest MapleLegends version. The current latest version is found by clicking here.
    Dismiss Notice

Completed Scheduled Database Maintenance - September 16, 2022

Discussion in 'Maintenances' started by Kimmy, Sep 15, 2022.

  1. Kimmy
    Online

    Kimmy Administrator Staff Member Administrator Game Moderator

    10,885
    10,840
    551
    Sep 9, 2014
    The Netherlands
    11:44 AM
    Moderator Post
    [​IMG]

    Hello Maplers,

    We will be performing Scheduled database Maintenance on Friday September 16, 2022. It will last approximately until it's done. Upon completion, the game will be brought back online and service will be restored. Once restored, you can log in and play!

    Time:
    11:00 AM server time
    (1:00 PM CEST)

    What will be unavailable:
    • All MapleLegends game servers and channels
    • Merchants will be closed
    • In-game name change requests using @changeign are automatically processed
    Changes and Updates:
    • Database Maintenance*
    * MapleLegends is doing database maintenance to clean up junk data that have plagued our system since 2014. We don't know how long it'll take, but hopefully it'll go fine.

    Sincerely,

    -MapleLegends Staff & Administration-
     
    • Great Work Great Work x 7
    • Like Like x 1
  2. OP
    OP
    Kimmy
    Online

    Kimmy Administrator Staff Member Administrator Game Moderator

    10,885
    10,840
    551
    Sep 9, 2014
    The Netherlands
    11:44 AM
    Moderator Post
    Server is in maintenance.
     
    • Informative Informative x 1
  3. Beaver
    Offline

    Beaver Mano

    13
    14
    10
    Jun 26, 2022
    Planet Earth
    2:44 AM
    BeaverFever
    Hero
    151
    Eternals
    thank you kimmy and staff
     
  4. sark2
    Offline

    sark2 Snail

    1
    0
    0
    Sep 16, 2022
    12:44 PM
    Cleric
    38
    You think that Its gonna be today? :(
     
  5. OP
    OP
    Kimmy
    Online

    Kimmy Administrator Staff Member Administrator Game Moderator

    10,885
    10,840
    551
    Sep 9, 2014
    The Netherlands
    11:44 AM
    Moderator Post
    Updates that were posted on our Discord:


    As well as

     
    • Like Like x 2
    • Great Work Great Work x 1
    • Friendly Friendly x 1
  6. Exotican
    Offline

    Exotican Snail

    1
    2
    6
    Sep 16, 2022
    Male
    11:44 AM
    ExoZin
    Assassin
    36
    Eternals
    I know its proberly needed to make this kind of clean up
    Im just very unhappy by doing it on a friday.
    I fell Im not the only one.

    Best Regrads a fan of Maple legends
     
    • Like Like x 2
    • Disagree Disagree x 1
  7. Talius
    Offline

    Talius Red Snail

    5
    0
    5
    Aug 17, 2022
    Male
    12:44 PM
    Beginner
  8. OP
    OP
    Kimmy
    Online

    Kimmy Administrator Staff Member Administrator Game Moderator

    10,885
    10,840
    551
    Sep 9, 2014
    The Netherlands
    11:44 AM
    Moderator Post
    You mention for the very same reason why we do these on weekends: This is a hobby and we have a job outside of this unfortunately.
     
    • Like Like x 2
    • Agree Agree x 2
    • Friendly Friendly x 1
  9. OmbReanrd
    Offline

    OmbReanrd Mushmom

    57
    96
    70
    Nov 11, 2020
    Qu├ębec
    5:44 AM
    Fara
    Paladin
    198
    oddly enough friday is the least active day for the content i do
     
  10. DylanPickle
    Offline

    DylanPickle Snail

    1
    0
    0
    Sep 5, 2022
    Male
    2:44 AM
    DylPickle
    Priest
    71
    GangGang
    any idea when it will be back up? i feel like its been down all day . missing it already haha
     
  11. OP
    OP
    Kimmy
    Online

    Kimmy Administrator Staff Member Administrator Game Moderator

    10,885
    10,840
    551
    Sep 9, 2014
    The Netherlands
    11:44 AM
    Moderator Post
    "All" done. I will post here below what I will announce on our Discord too.
     
    • Great Work Great Work x 2
  12. OP
    OP
    Kimmy
    Online

    Kimmy Administrator Staff Member Administrator Game Moderator

    10,885
    10,840
    551
    Sep 9, 2014
    The Netherlands
    11:44 AM
    Moderator Post
    Like mentioned this is pasted from Discord


    Ugh, okay it seems we are okay enough to point we have zero complaints for past 30~ minutes.

    First for the bit of information that you all care about:

    The server have been back online

    The event have been extended and will now end Sunday, September 25th, 23:59:59 servertime

    Now for the bit of information that some of you care about:

    This database cleanup maintenance is the most stressful I have felt in a really long time.

    1) While we did many checks to make sure ONLY garbage data gets deleted, it's still a very nervous wracking situation due to how freckle and old our database is
    2) During the night our website crashed. This wasn't just a normal website crash, the whole database locked up
    3) In the morning we tried for 2 hours recover the frozen database, were forced to reboot the server
    4) The database was constantly crashing upon trying to recover because it didn't like how it was killed. This was peak stress
    5) After a lot of messing around it came back up, and everything (progress wise) was intact.
    6) We were back to "we hope this cleanup have no false positives" < we are here now

    So here's the good news: We have cleaned 90~gb of DB garbage overnight

    So here's the bad news: There's still 300gb~ or so garbage data left

    Now those experienced are probably asking themselves: What the fuck is all that garbage then? The only answer I can give to that is this: Peak OdinMS (base server emulator) trash that build up for past 7 years

    So here's the deal if things remain fine: We probably will do a similar maintenance next month or so, and slowly but surely we will clean up all this god awful stuff. Even though 90GB seems very minimal from the total, this still helps a lot. Also, we know kind of why the DB did freeze, and will make sure it doesn't occur again. Furthermore, when we have cleaned this completely we will start doing this way more frequent so this is no longer need at all.

    Eitherway, I really need to rest. Happy Mapling.
     
    • Great Work Great Work x 6
    • Friendly Friendly x 2
  13. ooShawnyoo
    Offline

    ooShawnyoo Timer

    109
    73
    130
    Sep 17, 2021
    Male
    Montreal
    5:44 AM
    Frenzied
    I'll keep you and the team in my thoughts, Kimmy.

    You did good, and you deserve to rest.

    You have all of us to give you comfort and support should you ever feel stressed or overwhelmed. The server appreciates everything that you do.

    Thank you Staff! OnionNervous
     
  14. Krythan
    Offline

    Krythan Pac Pinky

    179
    56
    186
    Sep 2, 2022
    5:44 AM
    Krythan
    Bishop
    156
    Sleepywood
    Thank you Kimmy and team!

    I really appreciate the details and insight you shared into the problem during, and after the maintenance! It's very interested to get some insight into the work that's done behind the scenes, and the technical challenges involved. I can only imagine it's a wild technical problem working with such a legacy codebase. I'm sorry it was so stressful!
     

Share This Page