Non-relational stores are not a replacement for relational ones. They have different consistency and CAP behavior.
I say this as someone that despises MySQL.
Same obviously applies for PostgreSQL but is actually slightly harder for a number of reasons with less out of the box solutions like Vitess available.