3 ms·
> both the times I argued that MySQL wasn’t the right approach Looking at it holistically, MySQL is ALWAYS going to be the correct approach, if you already hav
by mrweasel 3y ago
> both the times I argued that MySQL wasn’t the right approach
Looking at it holistically, MySQL is ALWAYS going to be the correct approach, if you already have an internal team of MySQL DBAs. Either your problems are small enough that it really doesn't matter if you use CSV files, MongoDB or MySQL or they are large enough and important enough that you want to stick with technology you know and understand, even if it requires 25% extra hardware.
We did a project where we where looking into OpenStack, which was objectively the technological correct choice. Factoring in training, ramp up cost and hardware, it made more sense to just pay VMware.
Without knowing you, I suspect the issue is in how you answer such questions, not whether or not that you're technically correct. I'd go with the route or presenting two options, the one you find to be "the right approach" and the one that fits into the company's current infrastructure. Coming mostly from the operation sides of things, I find that developers can be pretty clueless about the cost and complexity of operations. Often to the point where you wouldn't trust them to design anything unsupervised, because doing so would end up in an operations nightmare.
- darth_avocado 3y agoi am not arguing their decision is wrong on their real world system. It is a system design interview with a hypothetical situation completely unrelated to their prod system, where I suggest a different db than MySQL. They are the ones arguing that my decision is wrong and MySQL is the correct choice, at which point you have to defend your choices.
- mrweasel 3y agoOkay, then yes that's not normal. I'd never tell a candidate that they are just flat out wrong, that honestly seem unprofessional and kinda aggressive. I still might say something like "So I'd go with MySQL here myself, can you guide me through your reasoning for picking another database system or which circumstances that might cause you to go with MySQL as well?".