> . As far as I'm aware Facebook's ad platform is mostly backed by hundreds of thousands of Mysql instances.

Same for YouTube itself https://www.mysql.com/customers/view/?id=750 and they use Vitess for horizontal scaling: https://vitess.io/