Is there a guide for scaling airflow horizontally with meltano?

Nothing I know of as of yet. In theory, standard Airflow scaling principles should apply. I also see many users applying kubernetes-type runners to run dockerized meltano cli commands, using the scheduler of their cloud platform.