vidyayug@ubuntu:~$ maxadmin -pmariadb list servers Servers. -------------------+-----------------+-------+-------------+-------------------- Server | Address | Port | Connections | Status -------------------+-----------------+-------+-------------+-------------------- srv1 | puppetagent.vidyayug.com | 3306 | 0 | Master, Running srv2 | sp.test1.com | 3306 | 0 | Slave, Running srv3 | idp.test.com | 3306 | 0 | Slave, Running -------------------+-----------------+-------+-------------+-------------------- vidyayug@ubuntu:~$ maxadmin -pmariadb list services Services. --------------------------+----------------------+--------+--------------- Service Name | Router Module | #Users | Total Sessions --------------------------+----------------------+--------+--------------- Splitter Service | readwritesplit | 1 | 1 CLI | cli | 2 | 3 --------------------------+----------------------+--------+--------------- vidyayug@ubuntu:~$ maxadmin -pmariadb show service "Splitter Service" Service 0x1a9f8d0 Service: Splitter Service Router: readwritesplit (0x7f3c3a0e22e0) State: Started Number of router sessions: 0 Current no. of router sessions: 0 Number of queries forwarded: 0 Number of queries forwarded to master: 0 (0.00%) Number of queries forwarded to slave: 0 (0.00%) Number of queries forwarded to all: 0 (0.00%) Started: Thu Mar 9 14:49:02 2017 Root user access: Disabled Backend databases: puppetagent.vidyayug.com:3306 Protocol: MySQLBackend sp.test1.com:3306 Protocol: MySQLBackend idp.test.com:3306 Protocol: MySQLBackend Users data: 0x1ab2690 Total connections: 1 Currently connected: 1 vidyayug@ubuntu:~$ maxadmin -pmariadb list sessions Sessions. -----------------+-----------------+----------------+-------------------------- Session | Client | Service | State -----------------+-----------------+----------------+-------------------------- 0x1ab2900 | | Splitter Service | Listener Session 0x1ab5f40 | | CLI | Listener Session 0x1ab6eb0 | 127.0.0.1 | CLI | Session ready for routing -----------------+-----------------+----------------+--------------------------