No, libnss-mysql only supports one MySQL server. The best way to achieve redundant MySQL servers is to use a load balancer - either a hardware device, or you should be able to use any of the software listed at http://lcic.org/load_balancing.html
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is posible to write in config file more that one MySQL server with user information?
No, libnss-mysql only supports one MySQL server. The best way to achieve redundant MySQL servers is to use a load balancer - either a hardware device, or you should be able to use any of the software listed at http://lcic.org/load_balancing.html