|
On login, the specified database appears to be selected, but any non-qualified statements fail. This setup is just two MariaDB 10.1.14 servers behind MaxScale in docker using the readwritesplit router:
~ mysql -h 172.17.0.4 test
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 10.0.0 1.4.3-maxscale MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [test]> create table foo(id int(11) auto_increment primary key);
ERROR 1046 (3D000): No database selected
MySQL [test]> use test;
Database changed
MySQL [test]> create table foo(id int(11) auto_increment primary key);
Query OK, 0 rows affected (0.01 sec)
MaxScale> list servers
Servers.
------------------
Server | Address | Port | Connections | Status
------------------
pxc-1 | 10.1.3.241 | 3306 | 1 | Slave, Synced, Running
pxc-2 | 10.1.3.242 | 3306 | 1 | Master, Synced, Running
------------------
MaxScale> list services
Services.
-------------------------+--------------
Service Name | Router Module | #Users | Total Sessions
-------------------------+--------------
Splitter Service | readwritesplit | 2 | 26
CLI | cli | 2 | 4
-------------------------+--------------
MaxScale> show service "Splitter Service"
Service 0xbc8fd0
Service: Splitter Service
Router: readwritesplit (0x7f9a769862c0)
State: Started
Number of router sessions: 25
Current no. of router sessions: 1
Number of queries forwarded: 314455
Number of queries forwarded to master: 314430
Number of queries forwarded to slave: 25
Number of queries forwarded to all: 21
Master/Slave percentage: 99.99%
Started: Wed Jul 6 17:30:45 2016
Root user access: Disabled
Backend databases
10.1.3.242:3306 Protocol: MySQLBackend
10.1.3.241:3306 Protocol: MySQLBackend
Users data: 0xc9e910
Total connections: 26
Currently connected: 2
|