As a user of PlanetScale I don’t know what distinction you are making here and why.

I’ve never had compatibility issues with single-node databases. It “just works” in the cloud and locally thanks to MySQL support in vitess.