How to scale MySQL horizontally?

cross-posted from: https://programming.dev/post/8057166

What is the industry/production grade solutions or if you have already any experience please share it. Thanks