Re: How to implement mysql consolidation strategy with multiple instances?

[Peter Brawley]

As I understand it, MySQL Router is part of InnoDB Cluster with all the assumptions you'd expect from that arrangement, and MySQL Proxy relies on MySQL server authentication plugins. I'm unaware of a built-in capability of the sort you are looking for, so I think you'd need to implement such logic in some sort of wrapper (or wrappers) for your RDBMSs and their users.