[Maintenance + Patch Discussion] 8-7-2012 [COMPLETE]

1…1011131516…41

Comments

  • diadrus1
    diadrus1 Posts: 0 Arc User
    edited August 2012
    Labells - Dreamweaver wrote: »
    b:cry nuuuu australia wants to play

    Woohoo go Aus, im from Aus too 8D
  • Ocelote - Lost City
    Ocelote - Lost City Posts: 66 Arc User
    edited August 2012
    well i hope Lost City Server is untouched XD since is where i play
  • _CRIToris_ - Harshlands
    _CRIToris_ - Harshlands Posts: 6 Arc User
    edited August 2012
    Akasha_Lust - Heavens Tear wrote: »
    +1 o.o

    agreed +2
    Harshlands server--smasherpwns(100 barb)

    Harshlands Server--CRIToris(100 sin)

    Archosaur Server--DeadByBeauty(96 Wizard)

    Lost City Server--ImRenowned(100 wizard)
  • SSBrolly - Heavens Tear
    SSBrolly - Heavens Tear Posts: 93 Arc User
    edited August 2012
    _CRIToris_ - Harshlands wrote: »
    Disadvantages of sharding

    Sharding a database table before it has been optimized locally causes premature complexity. Sharding should be used only when all other options for optimization are inadequate. The introduced complexity of database sharding causes the following potential problems:

    Increased complexity of SQL - Increased bugs because the developers have to write more complicated SQL to handle sharding logic.
    Sharding introduces complexity - The sharding software that partitions, balances, coordinates, and ensures integrity can fail.
    Single point of failure - Corruption of one shard due to network/hardware/systems problems causes failure of the entire table.
    Failover servers more complex - Failover servers must themselves have copies of the fleets of database shards.
    Backups more complex - Database backups of the individual shards must coordinated with the backups of the other shards.
    Operational complexity added - Adding/removing indexes, adding/deleting columns, modifying the schema become much more difficult.

    See also
    ^^^ LMAO that sounds like what happens to PWI :p
  • Jinxers - Dreamweaver
    Jinxers - Dreamweaver Posts: 199 Arc User
    edited August 2012
    While we're sitting here doing nothing...

    That's cool.
    [SIGPIC][/SIGPIC]
  • __ian__ - Heavens Tear
    __ian__ - Heavens Tear Posts: 162 Arc User
    edited August 2012
    Euthymius - Heavens Tear wrote: »
    GMs accidentally the server
    We clearly need a 2x week as compensation.

    Hi im __ian__ and i approve of this message. What the hell elts am i gonna do at 2.22am without PW b:laugh
    [SIGPIC][/SIGPIC]
    Complete your first quest. b:bye
    Feb 24, 2009
  • Oliiander - Lost City
    Oliiander - Lost City Posts: 393 Arc User
    edited August 2012
    Rerum - Sanctuary wrote: »
    Server Shard:

    http://en.wikipedia.org/wiki/Shard_(database_architecture))

    Depending on the problem (not specified) can be a major headache or may even require full rollback, I say we all go to sleep. b:chuckle

    Thank you. I was dying to know, but too lazy to go shove it in googleb:shutup
    My squishiness is (Usually) unrivaled.
    [SIGPIC][/SIGPIC]
    Finally decided to give Olii her own banner.b:chuckle
  • Bogdan - Lothranis
    Bogdan - Lothranis Posts: 34 Arc User
    edited August 2012
    how manytime til server starts b:surrenderb:cute
  • BurnWhenIWiz - Heavens Tear
    BurnWhenIWiz - Heavens Tear Posts: 289 Arc User
    edited August 2012
    Wikipedia wrote:
    Sharding a database table before it has been optimized locally causes premature complexity.

    What if they just think of baseball?
  • DemiPariah - Sanctuary
    DemiPariah - Sanctuary Posts: 14 Arc User
    edited August 2012
    im pretty sure they are smart to back up the partition with our chars on it so that we dont lose out and they dont have an angry mob b:angry like now grrrrrrrrb:angryb:angryb:angryb:angry
  • MyMate - Dreamweaver
    MyMate - Dreamweaver Posts: 558 Arc User
    edited August 2012
    Euthymius - Heavens Tear wrote: »
    GMs accidentally the server
    We clearly need a 2x week as compensation.

    There really is a pony for everything @_@
    "In the beginning, it was claimed that all in Perfect World were equal. But now it seems that some are more equal than others..." ~ Lost City Recluse
  • DaKaan - Harshlands
    DaKaan - Harshlands Posts: 127 Arc User
    edited August 2012
    how about sleep, like normal people do?
    Ghanima 101 wiz, DaKaaN 101 BM, Ra\/en 96 Seeker
    Quit this game for another one called real life b:shocked
  • YourbellaC - Harshlands
    YourbellaC - Harshlands Posts: 17 Arc User
    edited August 2012
    Jinxers - Dreamweaver wrote: »
    I go to get coffee and come back to server shard crisis. D:

    Wtf is a server shard? /Goes to google too

    Googled

    b:surrender i got a headache need a coffee too now b:sad
  • TenshiHakase - Dreamweaver
    TenshiHakase - Dreamweaver Posts: 101 Arc User
    edited August 2012
    mymate - Dreamweaver wrote: »
    there Really Is A Pony For Everything @_@

    Dead To The Ponies!
    no.
  • DemiPariah - Sanctuary
    DemiPariah - Sanctuary Posts: 14 Arc User
    edited August 2012
    DaKaan - Harshlands wrote: »
    how about sleep, like normal people do?

    sleeep what is this thing sleep?
  • DaKaan - Harshlands
    DaKaan - Harshlands Posts: 127 Arc User
    edited August 2012
    DemiPariah - Sanctuary wrote: »
    im pretty sure they are smart to back up the partition with our chars on it so that we dont lose out and they dont have an angry mob b:angry like now grrrrrrrrb:angryb:angryb:angryb:angry

    huh? wait, you seriously think they're smart?

    they can't even fix a bug and you think something like this will be easy for them?
    Ghanima 101 wiz, DaKaaN 101 BM, Ra\/en 96 Seeker
    Quit this game for another one called real life b:shocked
  • crystalpink
    crystalpink Posts: 0 Arc User
    edited August 2012
    __ian__ - Heavens Tear wrote: »
    Hi im __ian__ and i approve of this message. What the hell elts am i gonna do at 2.22am without PW b:laugh
    Eat a piece of cupcake to stay awake like what I am doing rite now b:chuckle
    (\__/)
    (O.o )
    ( > < )
    This is Bunny. Copy Bunny and this attached message into your signature to help him on his quest for world domination.
    Server: Abyss
    IGNs: Valentina (Magus), Amanita (Heretic), Avicenia (Slayer), Mirabillis (Champion), Solange (Berserker)
    Xfire username: crystalpink
  • condo2009
    condo2009 Posts: 406 Arc User
    edited August 2012
    you'd think they would test the patches BEFORE and not after. happens everytime..... 5 hr maint like always
  • Garudi - Dreamweaver
    Garudi - Dreamweaver Posts: 20 Arc User
    edited August 2012
    This turned into a huge +1 thread. Oh well...
    [SIGPIC][/SIGPIC]
    Garudi 9x psychic | Mightena 8x veno | Ordelia 8x cleric | Sinikka 8x seeker | LunarWolf 7x mystic | Naluana 6x assassin |
    random LC/HT/DW toons
    Yes, I love making alts. b:chuckle
  • XLuvBiscuitx - Sanctuary
    XLuvBiscuitx - Sanctuary Posts: 12 Arc User
    edited August 2012
    _CRIToris_ - Harshlands wrote: »
    agreed +2

    +3b:avoid
  • Oliiander - Lost City
    Oliiander - Lost City Posts: 393 Arc User
    edited August 2012
    DemiPariah - Sanctuary wrote: »
    sleeep what is this thing sleep?

    Can't remember. Been a while since my last bout of exposure to it.
    My squishiness is (Usually) unrivaled.
    [SIGPIC][/SIGPIC]
    Finally decided to give Olii her own banner.b:chuckle
  • _blood_rain - Sanctuary
    _blood_rain - Sanctuary Posts: 2,532 Arc User
    edited August 2012
    Jinxers - Dreamweaver wrote: »
    While we're sitting here doing nothing...

    That's cool.

    Russians always have the coolest pw art contests, I look at our current user-created loading screen contest winner, and it makes me want to cry.
  • DaKaan - Harshlands
    DaKaan - Harshlands Posts: 127 Arc User
    edited August 2012
    DemiPariah - Sanctuary wrote: »
    sleeep what is this thing sleep?

    its like meditating, only in RL.. you should try it..
    Ghanima 101 wiz, DaKaaN 101 BM, Ra\/en 96 Seeker
    Quit this game for another one called real life b:shocked
  • Jinxers - Dreamweaver
    Jinxers - Dreamweaver Posts: 199 Arc User
    edited August 2012
    Sleeping is for... people who sleep. b:scorn

    AKA not me.
    [SIGPIC][/SIGPIC]
  • _CRIToris_ - Harshlands
    _CRIToris_ - Harshlands Posts: 6 Arc User
    edited August 2012
    just sleep as a final post im reposting this for people who are confused

    Disadvantages of sharding

    Sharding a database table before it has been optimized locally causes premature complexity. Sharding should be used only when all other options for optimization are inadequate. The introduced complexity of database sharding causes the following potential problems:

    Increased complexity of SQL - Increased bugs because the developers have to write more complicated SQL to handle sharding logic.
    Sharding introduces complexity - The sharding software that partitions, balances, coordinates, and ensures integrity can fail.
    Single point of failure - Corruption of one shard due to network/hardware/systems problems causes failure of the entire table.
    Failover servers more complex - Failover servers must themselves have copies of the fleets of database shards.
    Backups more complex - Database backups of the individual shards must coordinated with the backups of the other shards.
    Operational complexity added - Adding/removing indexes, adding/deleting columns, modifying the schema become much more difficult.

    See also
    Harshlands server--smasherpwns(100 barb)

    Harshlands Server--CRIToris(100 sin)

    Archosaur Server--DeadByBeauty(96 Wizard)

    Lost City Server--ImRenowned(100 wizard)
  • Kerona - Sanctuary
    Kerona - Sanctuary Posts: 1,771 Arc User
    edited August 2012
    sharding 40 up, 14 down
    Splitting a database into several pieces, usually to improve the speed and reliability of your application.

    Sharding strictly speaking is a synonym for "horizontal partitioning" or dividing up a database table by its rows.

    In common use, sharding refers to having some data for an app on one database server, and other data in another. Often this is done by having specific tables hosted on specific servers, with a function determining which server contains the information being requested.

    Sharding is frequently discussed with regard to large web based applications, but is not limited to any particular industry.

    As a practical example, a WordPress MultiSite installation hosting several hundred thousand blogs could have the tables for sites 1-100,000 running on one database server 100,001-200,000 on another or 200,001+ on a third. An alternative sharding implementation could be to have the 50 busiest blogs' tables split between the first two servers all remaining blog data on the third server. Likewise, data could be partitioned based upon the geographic location of the web servers delivering each blog.
    When our site became so popular it kept overwhelming our database servers, we looked into sharding the database between five different data centers.

    Oh. I see.
    [SIGPIC][/SIGPIC]
  • X_kitten_x - Dreamweaver
    X_kitten_x - Dreamweaver Posts: 9 Arc User
    edited August 2012
    DemiPariah - Sanctuary wrote: »
    im pretty sure they are smart to back up the partition with our chars on it so that we dont lose out and they dont have an angry mob b:angry like now grrrrrrrrb:angryb:angry

    Nah...they wouldn't **** things up so royally that it would cause them to have to do a rollba...b:shocked
  • OontzOontz - Dreamweaver
    OontzOontz - Dreamweaver Posts: 782 Arc User
    edited August 2012
    It's probably the 3 eastern servers. They crash a lot, enough crashes later and they finally broke.
    [SIGPIC][/SIGPIC]
  • hypereccentrik
    hypereccentrik Posts: 529 Arc User
    edited August 2012
    I like chicken.
  • Bogdan - Lothranis
    Bogdan - Lothranis Posts: 34 Arc User
    edited August 2012
    PWI – Return of the Perfect Questmaster! wass good to inform you how many quests you need for next redard

Categories