I cut a bunch of apps (and their large databases) over from MySQL to Postgres several years ago. It was tedious, but I've never had cause to regret it in any way.
When MySQL became Oracle I was very relieved to not have to think about the implications.