Uber Engineering explains the technical reasoning behind its
switch in database technologies, from Postgres to MySQL: https://eng.uber.com/mysql-migration/
These things are always an interesting read, because it looks at
one company’s decision making process and operational steps.
At Open Query we’re not a fan of migrations – it doesn’t matter
from what brand to what brand, migrations tend to
be expensive and painful. Any application tends
to be more suited to a particular brand – because of design and
implementation choices. This is neither good nor bad, it’s just a
fact that has to be acknowledged when considering these things.
Similarly, infrastructure (what hardware there is and how
it’s set up and connected) tends to be dependent on the brand
choice, as different databases have different needs in that
space, …[Read more]