So when it comes to routing your MySQL traffic several options
- MariaDB MaxScale
- MySQL Router
- You can even still get MySQL Proxy if you wanted it but it is EOF.
Now I have seen HAproxy used more often with clients, it is pretty straight forward to set up. Percona has an example for those interested: