This is imported from bugzilla item
http://bugs.mariadb.com/show_bug.cgi?id=722

Description Markus Mäkelä 2015-02-04 19:14:51 UTC
Created attachment 183 http://bugs.mariadb.com/attachment.cgi?id=183
Failing configuration

Quote from the readconnroute.c file:

> The router may also have options associated to it that will limit the

 > choice of backend server. Currently two options are supported, the "master"

 > option will cause the router to only connect to servers marked as masters

 > and the "slave" option will limit connections to routers that are marked

 > as slaves. If neither option is specified the router will connect to either

 > masters or slaves

.

With this assumption the Read Connection Router service from the attached configuration should work.

Currently if no router_options is defined, the default operation is to route to a master. If the service has no master servers, new session creation will fail.