[g1] type=server address=10.10.0.164 protocol=MySQLBackend [g2] type=server address=10.10.0.165 protocol=MySQLBackend [g3] type=server address=10.10.0.166 protocol=MySQLBackend [Galera_Monitor] type=monitor module=galeramon servers=g1,g2,g3 user=monitor password=maxscale [rw2] type=service router=readwritesplit servers=g1,g2,g3 master_accept_reads=true user=monitor password=maxscale │ Parameters │ { │ │ │ "auth_all_servers": false, │ │ │ "causal_reads": "false", │ │ │ "causal_reads_timeout": 10000, │ │ │ "cluster": null, │ │ │ "connection_keepalive": 300, │ │ │ "connection_timeout": 0, │ │ │ "delayed_retry": false, │ │ │ "delayed_retry_timeout": 10000, │ │ │ "disable_sescmd_history": false, │ │ │ "enable_root_user": false, │ │ │ "lazy_connect": false, │ │ │ "localhost_match_wildcard_host": true, │ │ │ "log_auth_warnings": true, │ │ │ "master_accept_reads": true, │ │ │ "master_failure_mode": "fail_instantly", │ │ │ "master_reconnection": false, │ │ │ "max_connections": 0, │ │ │ "max_sescmd_history": 50, │ │ │ "max_slave_connections": "255", │ │ │ "max_slave_replication_lag": 0, │ │ │ "net_write_timeout": 0, │ │ │ "optimistic_trx": false, │ │ │ "password": "*****", │ │ │ "prune_sescmd_history": false, │ │ │ "rank": "primary", │ │ │ "retain_last_statements": -1, │ │ │ "retry_failed_reads": true, │ │ │ "router_options": null, │ │ │ "session_trace": false, │ │ │ "session_track_trx_state": false, │ │ │ "slave_connections": 255, │ │ │ "slave_selection_criteria": "LEAST_CURRENT_OPERATIONS", │ │ │ "strict_multi_stmt": false, │ │ │ "strict_sp_calls": false, │ │ │ "strip_db_esc": true, │ │ │ "targets": null, │ │ │ "transaction_replay": false, │ │ │ "transaction_replay_attempts": 5, │ │ │ "transaction_replay_max_size": "1073741824", │ │ │ "transaction_replay_retry_on_deadlock": false, │ │ │ "use_sql_variables_in": "all", │ │ │ "user": "monitor", │ │ │ "version_string": null │ │ │ } │ ├─────────────────────┼─────────────────────────────────────────────────────────────┤ │ Router Diagnostics │ { │ │ │ "queries": 375844771, │ │ │ "replayed_transactions": 0, │ │ │ "ro_transactions": 22917150, │ │ │ "route_all": 1023, │ │ │ "route_master": 46669427, │ │ │ "route_slave": 329174321, │ │ │ "rw_transactions": 0, │ │ │ "server_query_statistics": [ │ │ │ { │ │ │ "avg_selects_per_session": 45625, │ │ │ "avg_sess_active_pct": 0, │ │ │ "avg_sess_duration": "5.00135min", │ │ │ "id": "g1", │ │ │ "read": 6160, │ │ │ "total": 46675587, │ │ │ "write": 46669427 │ │ │ }, │ │ │ { │ │ │ "avg_selects_per_session": 156960, │ │ │ "avg_sess_active_pct": 23.78, │ │ │ "avg_sess_duration": "5.00135min", │ │ │ "id": "g2", │ │ │ "read": 160571295, │ │ │ "total": 160571295, │ │ │ "write": 0 │ │ │ }, │ │ │ { │ │ │ "avg_selects_per_session": 164808, │ │ │ "avg_sess_active_pct": 24.74, │ │ │ "avg_sess_duration": "5.00135min", │ │ │ "id": "g3", │ │ │ "read": 168599935, │ │ │ "total": 168599935, │ │ │ "write": 0 │ │ │ } │ │ │ ] │ │ │ } │ └─────────────────────┴─────────────────────────────────────────────────────────────┘