I'm trying to figure out how to achieve mysqlrouter HA. Can multiple mysqlrouter be load balanced?
For cluster resilience, should I create mysqlrouter instance on the same compute instance the MySQL instance is installed? Or should I create separate mysqlrouter compute instance?
Thanks,
- Xinhuan