5 ms·
I'm intentionally ignoring any of the sarcasm in your comment. The time needed for a db dump is always dependent upon the amount of data. This is true regardles
by manfre 3y ago
I'm intentionally ignoring any of the sarcasm in your comment. The time needed for a db dump is always dependent upon the amount of data. This is true regardless of the db software or where it's running.
- Ensorceled 3y agoI can't think of any project I've worked on where the main data base could be backed up and restored to a different database in "2 minutes" The sarcasm was warranted.
- re-thc 3y agoWith SSO multi-account and 2FA, it'd probably take longer than 2 minutes just to authenticate and configure AWS correctly to get started.
- emodendroket 3y agoIsn’t the suggestion that the “active work” is very little and most of the time you’re just waiting?
- Ensorceled 3y agoWell, the elapsed time is how long I need production to be offline so there are a few more people "just waiting"
- emodendroket 3y agoSure, but you don’t really expect to swap databases with a huge data store without any downtime, do you? I’m not aware of any technology that makes that easy.
- Ensorceled 3y agoThen why are you defending the ridiculous "2 minute" thing? If the CEO asked how long a migration will take would you respond "2 minutes of engineering time"?
- emodendroket 3y agoIn that situation I would guess the one-click tool doesn’t really handle everything you’d need either so I don’t get what the point of the comparison is.
- Ensorceled 3y agoI’m not the person would said it was two minutes.
- emodendroket 3y agoNor am I but if we go back up the claim was that they were making it much easier to get in than get out, but unless you're telling me that the one-click tool somehow solves all the issues of migrating a large production database that's in use the difference between the two is a minuscule amount of active work.
- kerkeslager 3y agoIf you were the CEO and your engineer and someone said, "2 minutes of actual work and a lot of waiting around due to the limitations of the hardware", would you interpret that as "2 minutes of engineering time"? Obviously I'm going to spend a lot more time communicating the details of the situation to the CEO of a company that is paying me, than I'm going to spend communicating in a Hacker News comment. But as it turns out, no amount of communication is going to be effective if people don't bother to read past the first opportunity they see to jump in with a correction, even if that means stopping reading mid-sentence.
- squeaky-clean 3y agoWhy would you take production offline to swap databases? Elapsed time is how long you need to run the new database alongside the old one.
- Ensorceled 3y agoThis whole thread is about incompatible databases. If you know a 2 minute solution to a live transfer in that situation I’m all ears.
- kerkeslager 3y agoIf only you had read the whole sentence, you might have saved yourself a bit of righteous anger.
- Paul-Craft 3y agoI think you've failed to consider how impractical even doing a SQL dump can be on a large-ish database, forget about the reloading time.
- kerkeslager 3y agoI haven't failed to consider that, you've just failed to read where I explicitly mentioned that. Consider: is that impracticality caused by Amazon creating vendor lock-in? Or is that impracticality caused by the fact that reading terabytes of data from storage, transferring it over the network, and writing it into storage is inherently slow because of the physical limitations of hardware, no matter what vendor you're using? It's a bit odd for me to be in the position of defending Amazon here. I genuinely don't like them, don't use them, and generally do think they're guilty of creating a lot of vendor lock-in. But this is legitimately not an example of any of that.
- Paul-Craft 3y agoI didn't miss where you mentioned it. I missed where you considered it. As in, you know, gave any thought to the practicalities involved.
- kerkeslager 3y agoYou're really claiming you can read my mind to know what I have and have not considered right now, despite me bringing it up specifically. Alrighty then.
- Paul-Craft 3y agoI'm simply going by what you've written here. If you have considered it, then you have not "shown your work," so to speak.