Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connectionidis1Server version:5.5.30(ProxySQL Admin Module) Copyright (c)2000,2018, Oracle, MariaDB Corporation Ab and others. Type'help;'or'\h'forhelp. Type'\c'toclearthe current input statement. MySQL [(none)]>s...
[root@localhost ~]# mysql -uadmin -padmin -h127.0.0.1-P6032 Welcometo theMariaDBmonitor.Commandsend with ; or \g. YourMySQLconnection id is1 Serverversion:5.5.30(ProxySQLAdminModule) Copyright(c)2000,2018,Oracle,MariaDBCorporationAband others. Type'help;'or'\h'for help.Type'\c'to clea...
remove_backend() : HttpAuthBackendComponent remove_base_options() : Query_block remove_bits() : Item_sum_bit remove_bucket() : mysql_harness::SecureMemoryPool::BucketPool< BucketType > remove_cached_entry() : sha2_password::Caching_sha2_password remove_channel_observation_manager() : Channel...
MySQL connection id is 2 Serverversion: 5.5.30 (ProxySQL) Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. '\c' to clear the current inputstatement. MySQL [(none)]> show databases; ---+ | Database | +---+ | information...
| default_schema | schema_locked | transaction_persistent | fast_forward | backend | frontend | ...
ProxySQL 是一款可以实际用于生产环境的 MySQL 中间件,它有官方版和 percona 版两种。percona版是在官方版的基础上修改的,添加了几个比较实用的工具。生产环境建议用官方版。
►IoBackend ►IoComponent ►IoPluginConfig ►IORequest ►IoThread ►Is_empty_geometry ►IS_internal_schema_access ►Is_rtree_box_valid ►Is_target_geometry ►Is_worker IsTransportSecure ►Item ►Item_aggr_avg_field ►Item_aggr_bit_field ►Item_aggr_numeric_field ►Item_...
frontend, backend: 目前版本这两个都需要使用默认的1,将来有可能会把 Client -> ProxySQL (frontend) 与 ProxySQL -> BackendDB (backend)的认证分开。从 runtime_mysql_users 表内容看到,记录数比 mysql_users 多了一倍,就是把前端认证与后端认证独立出来的结果。
listen:Listen section defines a complete proxy with its frontend and backend parts combined in one section. It is generally useful for TCP-only traffic. Specify the HAproxy instance name next to it. The next line describing the section must be indented. ...
backend INT CHECK (backend IN (0,1)) NOT NULL DEFAULT 1, frontend INT CHECK (frontend IN (0,1)) NOT NULL DEFAULT 1, max_connections INT CHECK (max_connections >=0) NOT NULL DEFAULT 10000, attributes VARCHAR CHECK (JSON_VALID(attributes) OR attributes = '') NOT NULL DEFAULT '', ...