#metabrainz

/

      • zas
        We have to think about those details before the switch, since we'll do it in steps
      • 2016-04-29 12007, 2016

      • zas
        Preparation will include updates to DNS (TTL reduction etc...) and to GMail (whitelist new IPs)
      • 2016-04-29 12035, 2016

      • ruaok
        can CAA move later?
      • 2016-04-29 12039, 2016

      • ruaok
        or does it have to move with MB?
      • 2016-04-29 12047, 2016

      • ruaok
        I'm afraid it has to move with MB.
      • 2016-04-29 12058, 2016

      • zas
        I think too, bitmap could tell more
      • 2016-04-29 12040, 2016

      • zas
        FTP should move too at the same time imho
      • 2016-04-29 12048, 2016

      • ruaok
        maybe start adding a preparation section?
      • 2016-04-29 12054, 2016

      • ruaok
        yeah, FTP is on the first to move list now.
      • 2016-04-29 12033, 2016

      • ruaok
        I guess anything that is running via musicbrainz.org without a subdomain must first be split or moved first.
      • 2016-04-29 12047, 2016

      • ruaok
        migrating postgres will be fun. :)
      • 2016-04-29 12056, 2016

      • ruaok
        the process as I understand it:
      • 2016-04-29 12019, 2016

      • ruaok
        1. turn on WAL replication with a generous amount of buffer space.
      • 2016-04-29 12024, 2016

      • ruaok
        2. dump the DB
      • 2016-04-29 12029, 2016

      • ruaok
        3. Copy across the atlantic.
      • 2016-04-29 12039, 2016

      • ruaok
        4. import into new postgres
      • 2016-04-29 12051, 2016

      • ruaok
        5. turn on replication, and hope that the WAL was big enough for the replicant to catch on.
      • 2016-04-29 12001, 2016

      • ruaok
        6. run new infrastructure in read-only mode and test.
      • 2016-04-29 12009, 2016

      • ruaok
        7. flip master from CA to EU
      • 2016-04-29 12047, 2016

      • ruaok
        In theory there should be almost no visible downtime for users. a few minutes of DNS uncertainty for sure.
      • 2016-04-29 12001, 2016

      • ruaok
        and then of course... search.
      • 2016-04-29 12005, 2016

      • ruaok starts crying
      • 2016-04-29 12040, 2016

      • zas
        Well, search servers can be installed fast (Chef), but they'll suck on new servers as they do on old ones ;)
      • 2016-04-29 12055, 2016

      • zas
        And i fear they can't handle much more requests ...
      • 2016-04-29 12045, 2016

      • reosarevok
        Well we have GSoC for that at least now...
      • 2016-04-29 12051, 2016

      • ruaok
        reosarevok: well, sorta.
      • 2016-04-29 12003, 2016

      • ruaok
        weeksio is waffling on that.
      • 2016-04-29 12041, 2016

      • ruaok
        he wants to basiacally do two internships over the summer.
      • 2016-04-29 12058, 2016

      • ruaok
        I fear that I may need to just do this myself just so it gets fucking done.
      • 2016-04-29 12019, 2016

      • ruaok
        but I was planning going to lots of festivals this summer. not sure how that would work.
      • 2016-04-29 12001, 2016

      • zas
        ruaok: about new servers, i think web servers don't need RAID at all, if one fails we take it out of rotation, NewHost fixes/replaces it, we take it back in rotation
      • 2016-04-29 12009, 2016

      • ruaok
        agreed/
      • 2016-04-29 12017, 2016

      • ruaok
        and we dont need to keep logs on them either.
      • 2016-04-29 12028, 2016

      • ruaok
        since log collection can and should happen on gateways.
      • 2016-04-29 12051, 2016

      • zas
        In fact, this can be an issue
      • 2016-04-29 12053, 2016

      • ruaok
        and I think we should ship logs to Google Cloud storage, since we have a budget for that.
      • 2016-04-29 12013, 2016

      • ruaok
        because of failover and such?
      • 2016-04-29 12028, 2016

      • zas
        And because of number of requests we may want to handle
      • 2016-04-29 12036, 2016

      • ruaok
        I think we need to investigate a log collection service.
      • 2016-04-29 12045, 2016

      • ruaok
        ship logs to a dedicated log collection server.
      • 2016-04-29 12001, 2016

      • ruaok
        and get them off the gateways asap.
      • 2016-04-29 12016, 2016

      • zas
        Currently 30 Mbps / 800 reqs -> if we x10 the bandwidth, it would be 8000 reqs
      • 2016-04-29 12058, 2016

      • zas
        So logging will be an issue in disk spaces and performance, this is something which is not that an issue for now
      • 2016-04-29 12004, 2016

      • ruaok
        I really want analysitics for all of our traffic.
      • 2016-04-29 12006, 2016

      • ruaok
        but that can come later.
      • 2016-04-29 12011, 2016

      • ruaok
        agreed.
      • 2016-04-29 12016, 2016

      • D4RK-PH0ENiX joined the channel
      • 2016-04-29 12050, 2016

      • ruaok
        !m chrisskye
      • 2016-04-29 12050, 2016

      • BrainzBot
        You're doing good work, chrisskye!
      • 2016-04-29 12004, 2016

      • KodeStar
        ruaok / zas OVH vs Hetzner, what are the most important considerations for you?
      • 2016-04-29 12045, 2016

      • ruaok
      • 2016-04-29 12047, 2016

      • KodeStar
        under 70 euro a month you are going to be limited to an average of 100mbps with hetzner as they have a transfer limit of 30TB
      • 2016-04-29 12018, 2016

      • ruaok
        we're looking at 10-20 servers a month. :)
      • 2016-04-29 12041, 2016

      • ruaok
        so figuring out how to network them, RAID support, service support and such things are key for us.
      • 2016-04-29 12003, 2016

      • ruaok
        and given that our current limit is 30mbs, going to 100mbs is a great improvement.
      • 2016-04-29 12034, 2016

      • ruaok
        but I think our installation is going to be big enough and us being a non profit that we'll have to have a detailed conversation with however our new provider will be.
      • 2016-04-29 12037, 2016

      • KodeStar
        well if you have multiple servers ovh has a vrack, and if you go with the hosting range they have 10gbps vrack options, so all your internal traffic could go over that
      • 2016-04-29 12010, 2016

      • KodeStar
      • 2016-04-29 12049, 2016

      • ruaok
        we'd need something like that, yes.
      • 2016-04-29 12044, 2016

      • ruaok
        our plan is a two step plan:
      • 2016-04-29 12054, 2016

      • ruaok
        1. Identify our needs in great detail.
      • 2016-04-29 12008, 2016

      • ruaok
        2. cost it out for hetnzer and OVH.
      • 2016-04-29 12033, 2016

      • ruaok
        3. Then ring them up and see what sort of conversation we can have if anyone is willing to give us a discount for being a non profit.
      • 2016-04-29 12041, 2016

      • KodeStar
        there are also considerations on whether you think ecc memory is important
      • 2016-04-29 12046, 2016

      • ruaok
        and as you may be able to tell, counting is not my strong suit. :)
      • 2016-04-29 12052, 2016

      • ruaok
        ecc memory is critical. :)
      • 2016-04-29 12059, 2016

      • ruaok
        that isn't even a question for us.
      • 2016-04-29 12024, 2016

      • ruaok
        I think we're also going to insist on hardware raid on the machines that need it.
      • 2016-04-29 12030, 2016

      • ruaok
        not everything does.
      • 2016-04-29 12040, 2016

      • KodeStar
        a lot of the hetzner servers dont have ecc
      • 2016-04-29 12007, 2016

      • chrisskye
        ruaok: I hope people won’t become scared to network with you...since as soon as they give out their contact name...they get messages from me...
      • 2016-04-29 12022, 2016

      • KodeStar
        how important is ddos protection to you?
      • 2016-04-29 12042, 2016

      • ruaok
        chrisskye: I already made them aware of that and they were open to it. so, lets not worry about it.
      • 2016-04-29 12058, 2016

      • KodeStar
        hetzner will null route your ip if you get ddos'ed, ovh have ddos protection included in their price
      • 2016-04-29 12003, 2016

      • ruaok
        if we pressed them for serious money even if they had no revenue, then that would be an issue.
      • 2016-04-29 12026, 2016

      • chrisskye
        I just shake the tree and see if any fruit will fall...
      • 2016-04-29 12035, 2016

      • ruaok
        luckily we've not had a traditional (D)DoS attack, so it is hard to say.
      • 2016-04-29 12053, 2016

      • KodeStar
        true
      • 2016-04-29 12053, 2016

      • ruaok
        I'm starting to get kinda miffed with hetzner since they seem to be a nickel and dime shop.
      • 2016-04-29 12000, 2016

      • zas
        but more our services will grow, more ddos attacks are likely to happen
      • 2016-04-29 12001, 2016

      • KodeStar
        another company to consider is online.net
      • 2016-04-29 12002, 2016

      • ruaok
        I want something more transparent and honest.
      • 2016-04-29 12053, 2016

      • Freso
        We should make a HostingBrainz to be able to compare hosts...
      • 2016-04-29 12054, 2016

      • KodeStar
        the only problem with online.net is business support starts to get expensive, but as you are a non profit they may do something for you
      • 2016-04-29 12000, 2016

      • Freso
        ServerBrainz
      • 2016-04-29 12001, 2016

      • ruaok
        KodeStar: thanks, I've added it the doc.
      • 2016-04-29 12019, 2016

      • KodeStar
        how many ips do you need?
      • 2016-04-29 12020, 2016

      • ruaok smacks Freso
      • 2016-04-29 12025, 2016

      • ruaok
        one
      • 2016-04-29 12030, 2016

      • ruaok
        actually no.
      • 2016-04-29 12031, 2016

      • ruaok
        three.
      • 2016-04-29 12049, 2016

      • ruaok
        depending on how bandwidth is charged, we may use more.
      • 2016-04-29 12020, 2016

      • ruaok
        if all of our traffic is routed via a gateway, but we get bandwidth on a per server basis, then we'll want our FTP to run over a different IP, thus a different bandwidth budget.
      • 2016-04-29 12020, 2016

      • zas
        We need to be able to add IPs on needs, but basically < 16 will be enough
      • 2016-04-29 12026, 2016

      • KodeStar
        then any will do, the only difference is ovh you pay a one off setup fee (around £3 iirc), online.net you pay a setup fee and monthly fee, I think it's the same with hetzner as well
      • 2016-04-29 12030, 2016

      • ruaok
        zas: good call.
      • 2016-04-29 12049, 2016

      • ruaok
        hetzner's setup is one month fee, which is pretty high.
      • 2016-04-29 12014, 2016

      • KodeStar
        ovh don't have bandwidth caps, nor online.net only hetzner, ovh guarantee 250mbps with burst up to 1gbps
      • 2016-04-29 12040, 2016

      • ruaok
        leaning more towards OVH by the minute. :)
      • 2016-04-29 12048, 2016

      • zas
        KodeStar: OVH also offer 500Mbps guarantee, depending on offers
      • 2016-04-29 12000, 2016

      • KodeStar
        zas, true, depends on which one you go to
      • 2016-04-29 12008, 2016

      • ruaok
        I don't think we have the demand to go past 250mbit.
      • 2016-04-29 12024, 2016

      • KodeStar
        I was basing it on the HOST-32H
      • 2016-04-29 12026, 2016

      • ruaok
        at least not initially.
      • 2016-04-29 12043, 2016

      • KodeStar
        ssd or hdd?
      • 2016-04-29 12054, 2016

      • zas
        It depends on machine role
      • 2016-04-29 12005, 2016

      • ruaok
        mostly hdd.
      • 2016-04-29 12006, 2016

      • ruaok
        some ssd.
      • 2016-04-29 12023, 2016

      • ruaok
        did we make a call on postgres on ssd vs hdd?
      • 2016-04-29 12030, 2016

      • zas
        Yes.
      • 2016-04-29 12036, 2016

      • ruaok
        ssd?
      • 2016-04-29 12038, 2016

      • KodeStar
        well for ssd if you don't need hardware raid this is hard to beat: https://www.online.net/en/dedicated-server/dedibo…
      • 2016-04-29 12006, 2016

      • zas
        postgres on ssd, stats on ssd, and prolly gateways too
      • 2016-04-29 12019, 2016

      • ruaok
        really gateways?
      • 2016-04-29 12021, 2016

      • KodeStar
        but ovh servers has different configurations
      • 2016-04-29 12038, 2016

      • KodeStar
      • 2016-04-29 12041, 2016

      • ruaok
        128GB for postgres servers, right?
      • 2016-04-29 12041, 2016

      • zas
        ruaok: Yes, if they log
      • 2016-04-29 12047, 2016

      • ruaok
        k
      • 2016-04-29 12019, 2016

      • KodeStar
        2 x2TB SATA + 2 x480GB SSD SOFT RAID = extra £14.28/mo
      • 2016-04-29 12040, 2016

      • KodeStar
        +40 for hardraid on that config
      • 2016-04-29 12022, 2016

      • KodeStar
        tbh though, it's the vrack that has me interested in those servers
      • 2016-04-29 12043, 2016

      • zas
        Yes, i agree vRack is very interesting
      • 2016-04-29 12050, 2016

      • ruaok
        vrack means that you don't have to have server physically in the same rack, but they are on a vlan?
      • 2016-04-29 12058, 2016

      • KodeStar
        10gbps internal traffic leaves your public traffic open for what it should be used for
      • 2016-04-29 12006, 2016

      • zas
        Yes, they can even be in different datacenters
      • 2016-04-29 12007, 2016

      • KodeStar
        ruaok: yes
      • 2016-04-29 12009, 2016

      • ruaok
        because rack renting is an added cost at hetzner
      • 2016-04-29 12019, 2016

      • ruaok
        oh, sexy.
      • 2016-04-29 12039, 2016

      • zas
        This is a big plus towards OVH imho
      • 2016-04-29 12005, 2016

      • KodeStar
        you can also get load balancing ips from ovh, though you might want to handle that yourself
      • 2016-04-29 12037, 2016

      • KodeStar
      • 2016-04-29 12002, 2016

      • ruaok
        1GB vrack or 10GB vrack?
      • 2016-04-29 12016, 2016

      • ruaok
        yeah, we've been working hard on doing that ourselves.
      • 2016-04-29 12025, 2016

      • zas
        10Gb comes with 3Gb guarantee
      • 2016-04-29 12048, 2016

      • KodeStar
        the D-1520's have 1gbps, the d-1540's have 10gbps, and infrastructure is all 1gbps I think
      • 2016-04-29 12057, 2016

      • ruaok
        do we have an idea what our usage is now, internally?
      • 2016-04-29 12052, 2016

      • ruaok
        can you mix vrack 1gb and vrack 10gb servers?
      • 2016-04-29 12021, 2016

      • KodeStar
        I beleive so
      • 2016-04-29 12024, 2016

      • ruaok
        because the 10gb servers have many more cores.
      • 2016-04-29 12042, 2016

      • zas
      • 2016-04-29 12047, 2016

      • KodeStar
        yeah 8cores 16 threads
      • 2016-04-29 12011, 2016

      • zas
        Have a look at the bottom of the page, where OVH says guarantee is not always guaranteed ...
      • 2016-04-29 12016, 2016

      • reosarevok
      • 2016-04-29 12027, 2016

      • reosarevok
        "For example, Krafft said, descriptions of items in Cornell University Library’s Hip Hop Collection, such as annotated LP recordings from hip-hop’s earliest days, could now be linked to MusicBrainz.org"
      • 2016-04-29 12055, 2016

      • reosarevok
        Not bad I guess :)
      • 2016-04-29 12033, 2016

      • ruaok
        reosarevok: chrisskye already hit them up for money. prviate uni and all that. :)
      • 2016-04-29 12040, 2016

      • reosarevok
        haha
      • 2016-04-29 12047, 2016

      • reosarevok
        And $1.5 million sounds like a lot of money :p
      • 2016-04-29 12002, 2016

      • reosarevok
        Not sure why anyone would need that much to "use linked data"