Another option for scaling SQL is the Vitess OSS. Might give it a look. Uses a similar pattern of using an actor up front and then scaling MySQL on the back-end.

https://vitess.io/overview/

Would like a similar solution but with Postgres on the back end instead.