i used mysql for almost 20 years, since 3.23 and in the last 4 years i am exclusively using postgres (because of the hype and i thought i am missing out), and its not my cup of tea.
i just love mysql's hackable storage engine (particularly the new lsmt engines), and i hate toast so much, not to mention the permission system which is so convoluted and it is so easy to shoot yourself in the foot. and of course it does not play nice with low iops ebs.
its too expensive to migrate from pg now, but i would avoid it in the future
i usually dont use super sophisticated sql, so mysql is actually pretty good for me considering i can tune the knobs on some tables pretty well.
it could be just that i am more comfortable with hacking mysql, or just the early design principles of early mysql makes it a more hackable (its easier to lose some characters from acid haha)
nothing against postgres, i just think its a bit overhyped and its also harder to squeeze it in the cloud's ridiculous iops prices
i just love mysql's hackable storage engine (particularly the new lsmt engines), and i hate toast so much, not to mention the permission system which is so convoluted and it is so easy to shoot yourself in the foot. and of course it does not play nice with low iops ebs.
its too expensive to migrate from pg now, but i would avoid it in the future
i usually dont use super sophisticated sql, so mysql is actually pretty good for me considering i can tune the knobs on some tables pretty well.