Step 9: Test MariaDB MaxScale

Overview

This page details step 9 of the 9-step procedure "Deploy Xpand Storage Engine Topology".

This step tests MariaDB MaxScale 2.5.

Interactive commands are detailed. Alternatively, the described operations can be performed using automation.

Check Global Configuration

Use maxctrl show maxscale command to view the global MaxScale configuration.

This action is performed on the MaxScale node:

$ maxctrl show maxscale
┌──────────────┬───────────────────────────────────────────────────────┐
│ Version      │ 2.5.13                                                │
├──────────────┼───────────────────────────────────────────────────────┤
│ Commit       │ 8a610d4dad58a710669ab137be91f3c9376c3e9a              │
├──────────────┼───────────────────────────────────────────────────────┤
│ Started At   │ Mon, 02 Aug 2021 22:40:59 GMT                         │
├──────────────┼───────────────────────────────────────────────────────┤
│ Activated At │ Mon, 02 Aug 2021 22:40:59 GMT                         │
├──────────────┼───────────────────────────────────────────────────────┤
│ Uptime       │ 107                                                   │
├──────────────┼───────────────────────────────────────────────────────┤
│ Parameters   │ {                                                     │
│              │     "admin_auth": true,                               │
│              │     "admin_enabled": true,                            │
│              │     "admin_gui": true,                                │
│              │     "admin_host": "0.0.0.0",                          │
│              │     "admin_log_auth_failures": true,                  │
│              │     "admin_pam_readonly_service": null,               │
│              │     "admin_pam_readwrite_service": null,              │
│              │     "admin_port": 8989,                               │
│              │     "admin_secure_gui": false,                        │
│              │     "admin_ssl_ca_cert": null,                        │
│              │     "admin_ssl_cert": null,                           │
│              │     "admin_ssl_key": null,                            │
│              │     "admin_ssl_version": "MAX",                       │
│              │     "auth_connect_timeout": 10000,                    │
│              │     "auth_read_timeout": 10000,                       │
│              │     "auth_write_timeout": 10000,                      │
│              │     "cachedir": "/var/cache/maxscale",                │
│              │     "connector_plugindir": "/usr/lib64/mysql/plugin", │
│              │     "datadir": "/var/lib/maxscale",                   │
│              │     "debug": null,                                    │
│              │     "dump_last_statements": "never",                  │
│              │     "execdir": "/usr/bin",                            │
│              │     "language": "/var/lib/maxscale",                  │
│              │     "libdir": "/usr/lib64/maxscale",                  │
│              │     "load_persisted_configs": true,                   │
│              │     "local_address": null,                            │
│              │     "log_debug": false,                               │
│              │     "log_info": false,                                │
│              │     "log_notice": true,                               │
│              │     "log_throttling": {                               │
│              │         "count": 0,                                   │
│              │         "suppress": 0,                                │
│              │         "window": 0                                   │
│              │     },                                                │
│              │     "log_warn_super_user": false,                     │
│              │     "log_warning": true,                              │
│              │     "logdir": "/var/log/maxscale",                    │
│              │     "max_auth_errors_until_block": 10,                │
│              │     "maxlog": true,                                   │
│              │     "module_configdir": "/etc/maxscale.modules.d",    │
│              │     "ms_timestamp": false,                            │
│              │     "passive": false,                                 │
│              │     "persistdir": "/var/lib/maxscale/maxscale.cnf.d", │
│              │     "piddir": "/var/run/maxscale",                    │
│              │     "query_classifier": "qc_sqlite",                  │
│              │     "query_classifier_args": null,                    │
│              │     "query_classifier_cache_size": 0,                 │
│              │     "query_retries": 1,                               │
│              │     "query_retry_timeout": 5000,                      │
│              │     "rebalance_period": 0,                            │
│              │     "rebalance_threshold": 20,                        │
│              │     "rebalance_window": 10,                           │
│              │     "retain_last_statements": 0,                      │
│              │     "session_trace": 0,                               │
│              │     "skip_permission_checks": false,                  │
│              │     "sql_mode": "default",                            │
│              │     "syslog": true,                                   │
│              │     "threads": 2,                                     │
│              │     "users_refresh_interval": 0,                      │
│              │     "users_refresh_time": 30000,                      │
│              │     "writeq_high_water": 16777216,                    │
│              │     "writeq_low_water": 8192                          │
│              │ }                                                     │
└──────────────┴───────────────────────────────────────────────────────┘

Output should align to the global MaxScale configuration in the new configuration file you created.

Check Server Configuration

Use the maxctrl list servers and maxctrl show server commands to view the configured server objects.

This action is performed on the MaxScale node:

  1. Obtain the full list of servers objects:

    $ maxctrl list servers
    
    ┌──────────────────────┬────────────┬──────┬─────────────┬─────────────────┬──────┐
    │ Server               │ Address    │ Port │ Connections │ State           │ GTID │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ @@xpd_monitor:node-2 │ 192.0.2.2  │ 3306 │ 0           │ Master, Running │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ @@xpd_monitor:node-1 │ 192.0.2.1  │ 3306 │ 0           │ Master, Running │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ @@xpd_monitor:node-3 │ 192.0.2.3  │ 3306 │ 0           │ Master, Running │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ es2                  │ 192.0.2.11 │ 3306 │ 0           │ Running         │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ es1                  │ 192.0.2.10 │ 3306 │ 0           │ Master, Running │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ xpand3               │ 192.0.2.3  │ 3306 │ 0           │ Master, Running │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ xpand1               │ 192.0.2.1  │ 3306 │ 0           │ Master, Running │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ xpand2               │ 192.0.2.2  │ 3306 │ 0           │ Master, Running │      │
    ├──────────────────────┼────────────┼──────┼─────────────┼─────────────────┼──────┤
    │ es3                  │ 192.0.2.12 │ 3306 │ 0           │ Running         │      │
    └──────────────────────┴────────────┴──────┴─────────────┴─────────────────┴──────┘
    
  2. For each server object, view the configuration:

    $ maxctrl show server xpand1
    
    ┌─────────────────────┬───────────────────────────────────────────┐
    │ Server              │ xpand1                                    │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Address             │ 192.0.2.1                                 │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Port                │ 3306                                      │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ State               │ Master, Running                           │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Version             │                                           │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Last Event          │ server_down                               │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Triggered At        │ Tue, 03 Aug 2021 18:49:02 GMT             │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Services            │ xpand_service                             │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Monitors            │ xpd_monitor                               │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Master ID           │ -1                                        │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Node ID             │ -1                                        │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Slave Server IDs    │                                           │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Current Connections │ 0                                         │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Total Connections   │ 0                                         │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Max Connections     │ 0                                         │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Statistics          │ {                                         │
    │                     │     "active_operations": 0,               │
    │                     │     "adaptive_avg_select_time": "0ns",    │
    │                     │     "connection_pool_empty": 0,           │
    │                     │     "connections": 0,                     │
    │                     │     "max_connections": 0,                 │
    │                     │     "max_pool_size": 0,                   │
    │                     │     "persistent_connections": 0,          │
    │                     │     "reused_connections": 0,              │
    │                     │     "routed_packets": 0,                  │
    │                     │     "total_connections": 0                │
    │                     │ }                                         │
    ├─────────────────────┼───────────────────────────────────────────┤
    │ Parameters          │ {                                         │
    │                     │     "address": "192.0.2.1",               │
    │                     │     "disk_space_threshold": null,         │
    │                     │     "extra_port": 0,                      │
    │                     │     "monitorpw": null,                    │
    │                     │     "monitoruser": null,                  │
    │                     │     "persistmaxtime": "0ms",              │
    │                     │     "persistpoolmax": 0,                  │
    │                     │     "port": 3306,                         │
    │                     │     "priority": 0,                        │
    │                     │     "proxy_protocol": false,              │
    │                     │     "rank": "primary",                    │
    │                     │     "socket": null,                       │
    │                     │     "ssl": false,                         │
    │                     │     "ssl_ca_cert": null,                  │
    │                     │     "ssl_cert": null,                     │
    │                     │     "ssl_cert_verify_depth": 9,           │
    │                     │     "ssl_cipher": null,                   │
    │                     │     "ssl_key": null,                      │
    │                     │     "ssl_verify_peer_certificate": false, │
    │                     │     "ssl_verify_peer_host": false,        │
    │                     │     "ssl_version": "MAX"                  │
    │                     │ }                                         │
    └─────────────────────┴───────────────────────────────────────────┘
    

Output should align to the Server Object configuration for Xpand nodes and Server Object configuration for ES nodes you performed.

Check Monitor Configuration

Use the maxctrl list monitors and maxctrl show monitor commands to view the configured monitors.

This action is performed on the MaxScale node:

  1. Obtain the full list of monitors:

    $ maxctrl list monitors
    
    ┌─────────────┬─────────┬────────────────────────┐
    │ Monitor     │ State   │ Servers                │
    ├─────────────┼─────────┼────────────────────────┤
    │ xpd_monitor │ Running │ xpand1, xpand2, xpand3 │
    ├─────────────┼─────────┼────────────────────────┤
    │ mdb_monitor │ Running │ es1, es2, es3          │
    └─────────────┴─────────┴────────────────────────┘
    
  2. For each monitor, view the monitor configuration:

    $ maxctrl show monitor mdb_monitor
    
    ┌─────────────────────┬────────────────────────────────────────────────────┐
    │ Monitor             │ mdb_monitor                                        │
    ├─────────────────────┼────────────────────────────────────────────────────┤
    │ Module              │ mariadbmon                                         │
    ├─────────────────────┼────────────────────────────────────────────────────┤
    │ State               │ Running                                            │
    ├─────────────────────┼────────────────────────────────────────────────────┤
    │ Servers             │ es1                                                │
    │                     │ es2                                                │
    │                     │ es3                                                │
    ├─────────────────────┼────────────────────────────────────────────────────┤
    │ Parameters          │ {                                                  │
    │                     │     "assume_unique_hostnames": true,               │
    │                     │     "auto_failover": false,                        │
    │                     │     "auto_rejoin": false,                          │
    │                     │     "backend_connect_attempts": 1,                 │
    │                     │     "backend_connect_timeout": 3,                  │
    │                     │     "backend_read_timeout": 3,                     │
    │                     │     "backend_write_timeout": 3,                    │
    │                     │     "cooperative_monitoring_locks": "none",        │
    │                     │     "demotion_sql_file": null,                     │
    │                     │     "detect_replication_lag": false,               │
    │                     │     "detect_stale_master": null,                   │
    │                     │     "detect_stale_slave": null,                    │
    │                     │     "detect_standalone_master": null,              │
    │                     │     "disk_space_check_interval": 0,                │
    │                     │     "disk_space_threshold": null,                  │
    │                     │     "enforce_read_only_slaves": false,             │
    │                     │     "enforce_simple_topology": false,              │
    │                     │     "enforce_writable_master": false,              │
    │                     │     "events": "all",                               │
    │                     │     "failcount": 5,                                │
    │                     │     "failover_timeout": 90,                        │
    │                     │     "handle_events": true,                         │
    │                     │     "ignore_external_masters": false,              │
    │                     │     "journal_max_age": 28800,                      │
    │                     │     "maintenance_on_low_disk_space": true,         │
    │                     │     "master_conditions": "primary_monitor_master", │
    │                     │     "master_failure_timeout": 10,                  │
    │                     │     "module": "mariadbmon",                        │
    │                     │     "monitor_interval": 2000,                      │
    │                     │     "password": "*****",                           │
    │                     │     "promotion_sql_file": null,                    │
    │                     │     "replication_master_ssl": false,               │
    │                     │     "replication_password": null,                  │
    │                     │     "replication_user": null,                      │
    │                     │     "script": null,                                │
    │                     │     "script_max_replication_lag": -1,              │
    │                     │     "script_timeout": 90,                          │
    │                     │     "servers_no_promotion": null,                  │
    │                     │     "slave_conditions": "none",                    │
    │                     │     "switchover_on_low_disk_space": false,         │
    │                     │     "switchover_timeout": 90,                      │
    │                     │     "user": "mxs",                                 │
    │                     │     "verify_master_failure": true                  │
    │                     │ }                                                  │
    ├─────────────────────┼────────────────────────────────────────────────────┤
    │ Monitor Diagnostics │ {                                                  │
    │                     │     "master": "es1",                               │
    │                     │     "master_gtid_domain_id": 0,                    │
    │                     │     "primary": null,                               │
    │                     │     "server_info": [                               │
    │                     │         {                                          │
    │                     │             "gtid_binlog_pos": null,               │
    │                     │             "gtid_current_pos": null,              │
    │                     │             "lock_held": null,                     │
    │                     │             "master_group": null,                  │
    │                     │             "name": "es1",                         │
    │                     │             "read_only": false,                    │
    │                     │             "server_id": 1,                        │
    │                     │             "slave_connections": []                │
    │                     │         },                                         │
    │                     │         {                                          │
    │                     │             "gtid_binlog_pos": null,               │
    │                     │             "gtid_current_pos": null,              │
    │                     │             "lock_held": null,                     │
    │                     │             "master_group": null,                  │
    │                     │             "name": "es2",                         │
    │                     │             "read_only": false,                    │
    │                     │             "server_id": 1,                        │
    │                     │             "slave_connections": []                │
    │                     │         },                                         │
    │                     │         {                                          │
    │                     │             "gtid_binlog_pos": null,               │
    │                     │             "gtid_current_pos": null,              │
    │                     │             "lock_held": null,                     │
    │                     │             "master_group": null,                  │
    │                     │             "name": "es3",                         │
    │                     │             "read_only": false,                    │
    │                     │             "server_id": 1,                        │
    │                     │             "slave_connections": []                │
    │                     │         }                                          │
    │                     │     ],                                             │
    │                     │     "state": "Idle"                                │
    │                     │ }                                                  │
    └─────────────────────┴────────────────────────────────────────────────────┘
    

Output should align to the Xpand Monitor (xpandmon) configuration and MariaDB Monitor (mariadbmon) configuration you performed.

Check Service Configuration

Use the maxctrl list services and maxctrl show service commands to view the configured routing services.

This action is performed on the MaxScale node:

  1. Obtain the full list of routing services:

    $ maxctrl list services
    
    ┌────────────────────┬────────────────┬─────────────┬───────────────────┬────────────────────────┐
    │ Service            │ Router         │ Connections │ Total Connections │ Servers                │
    ├────────────────────┼────────────────┼─────────────┼───────────────────┼────────────────────────┤
    │ es_service         │ readwritesplit │ 0           │ 0                 │ es1, es2, es3          │
    ├────────────────────┼────────────────┼─────────────┼───────────────────┼────────────────────────┤
    │ xpand_service      │ readconnroute  │ 0           │ 0                 │ xpand1, xpand2, xpand3 │
    └────────────────────┴────────────────┴─────────────┴───────────────────┴────────────────────────┘
    
  2. For each service, view the service configuration:

    $ maxctrl show service es_service
    
    ┌─────────────────────┬─────────────────────────────────────────────────────────────┐
    │ Service             │ es_service                                                  │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Router              │ readwritesplit                                              │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ State               │ Started                                                     │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Started At          │ Tue Aug  3 18:49:02 2021                                    │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Current Connections │ 0                                                           │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Total Connections   │ 0                                                           │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Max Connections     │ 0                                                           │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Cluster             │                                                             │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Servers             │ es1                                                         │
    │                     │ es2                                                         │
    │                     │ es3                                                         │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Services            │                                                             │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Filters             │                                                             │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Parameters          │ {                                                           │
    │                     │     "auth_all_servers": false,                              │
    │                     │     "causal_reads": "false",                                │
    │                     │     "causal_reads_timeout": "10000ms",                      │
    │                     │     "connection_keepalive": "300000ms",                     │
    │                     │     "connection_timeout": "0ms",                            │
    │                     │     "delayed_retry": false,                                 │
    │                     │     "delayed_retry_timeout": "10000ms",                     │
    │                     │     "disable_sescmd_history": false,                        │
    │                     │     "enable_root_user": false,                              │
    │                     │     "idle_session_pool_time": "-1000ms",                    │
    │                     │     "lazy_connect": false,                                  │
    │                     │     "localhost_match_wildcard_host": true,                  │
    │                     │     "log_auth_warnings": true,                              │
    │                     │     "master_accept_reads": false,                           │
    │                     │     "master_failure_mode": "fail_instantly",                │
    │                     │     "master_reconnection": false,                           │
    │                     │     "max_connections": 0,                                   │
    │                     │     "max_sescmd_history": 50,                               │
    │                     │     "max_slave_connections": 255,                           │
    │                     │     "max_slave_replication_lag": "0ms",                     │
    │                     │     "net_write_timeout": "0ms",                             │
    │                     │     "optimistic_trx": false,                                │
    │                     │     "password": "*****",                                    │
    │                     │     "prune_sescmd_history": true,                           │
    │                     │     "rank": "primary",                                      │
    │                     │     "retain_last_statements": -1,                           │
    │                     │     "retry_failed_reads": true,                             │
    │                     │     "reuse_prepared_statements": false,                     │
    │                     │     "router": "readwritesplit",                             │
    │                     │     "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,                                   │
    │                     │     "transaction_replay": false,                            │
    │                     │     "transaction_replay_attempts": 5,                       │
    │                     │     "transaction_replay_max_size": 1073741824,              │
    │                     │     "transaction_replay_retry_on_deadlock": false,          │
    │                     │     "type": "service",                                      │
    │                     │     "use_sql_variables_in": "all",                          │
    │                     │     "user": "mxs",                                          │
    │                     │     "version_string": null                                  │
    │                     │ }                                                           │
    ├─────────────────────┼─────────────────────────────────────────────────────────────┤
    │ Router Diagnostics  │ {                                                           │
    │                     │     "avg_sescmd_history_length": 0,                         │
    │                     │     "max_sescmd_history_length": 0,                         │
    │                     │     "queries": 0,                                           │
    │                     │     "replayed_transactions": 0,                             │
    │                     │     "ro_transactions": 0,                                   │
    │                     │     "route_all": 0,                                         │
    │                     │     "route_master": 0,                                      │
    │                     │     "route_slave": 0,                                       │
    │                     │     "rw_transactions": 0,                                   │
    │                     │     "server_query_statistics": []                           │
    │                     │ }                                                           │
    └─────────────────────┴─────────────────────────────────────────────────────────────┘
    

Output should align to the Xpand router configuration and ES router configuration you performed.

Test Application User

Applications should use a dedicated user account. The user account must be created on the primary server.

When users connect to MaxScale, MaxScale authenticates the user connection before routing it to an Enterprise Server node. Enterprise Server authenticates the connection as originating from the IP address of the MaxScale node.

The application users must have one user account with the host IP address of the application server and a second user account with the host IP address of the MaxScale node.

The requirement of a duplicate user account can be avoided by enabling the proxy_protocol parameter for MaxScale and the proxy_protocol_networks for Enterprise Server.

Create a User to Connect from MaxScale

This action is performed on the primary server:

  1. Connect to the primary server:

    $ sudo mariadb
    
  2. Create the database user account for your MaxScale node:

    CREATE USER 'app_user'@'192.0.2.20' IDENTIFIED BY 'app_user_passwd';
    

    Replace 192.0.2.20 with the relevant IP address specification for your MaxScale node.

    Passwords should meet your organization's password policies.

  3. Grant the privileges required by your application to the d database user account for your MaxScale node:

    GRANT ALL ON test.* TO 'app_user'@'192.0.2.20';
    
    GRANT SELECT ON system.nodes TO 'app_user'@'192.0.2.20';
    
    GRANT SELECT ON system.sessions TO 'app_user'@'192.0.2.20';
    

    The privileges shown are designed to allow the tests in the subsequent sections to work. The user account for your production application may require different privileges.

Create a User to Connect from the Application Server

This action is performed on the primary server:

  1. Create the database user account for your application server:

    CREATE USER 'app_user'@'192.0.2.30' IDENTIFIED BY 'app_user_passwd';
    

    Replace 192.0.2.30 with the relevant IP address specification for your application server.

    Passwords should meet your organization's password policies.

  2. Grant the privileges required by your application to the database user account for your application server:

    GRANT ALL ON test.* TO 'app_user'@'192.0.2.30';
    
    GRANT SELECT ON system.nodes TO 'app_user'@'192.0.2.30';
    
    GRANT SELECT ON system.sessions TO 'app_user'@'192.0.2.30';
    

    The privileges shown are designed to allow the tests in the subsequent sections to work. The user account for your production application may require different privileges.

Test Connection with Application User

To test the connection, use the MariaDB Client from your application server to connect to an ES node through MaxScale.

This action is performed on the application server:

$ mariadb --host 192.0.2.20 --port 3306
      --user app_user --password

Test Application Connections

This action is performed on a client connected to the MaxScale node:

  1. On the MaxScale node, use the maxctrl list listeners command to view the available listeners and ports:

    $ maxctrl list listeners
    
    ┌─────────────────┬──────┬──────┬─────────┬────────────────────┐
    │ Name            │ Port │ Host │ State   │ Service            │
    ├─────────────────┼──────┼──────┼─────────┼────────────────────┤
    │ es_listener     │ 3306 │ ::   │ Running │ es_service         │
    ├─────────────────┼──────┼──────┼─────────┼────────────────────┤
    │ xpand_listener  │ 5001 │ ::   │ Running │ xpand_service      │
    └─────────────────┴──────┴──────┴─────────┴────────────────────┘
    
  2. Use the MariaDB Client to connect to the listener port for the Enterprise Server service (here 3306) on the MaxScale node:

    $ mariadb --host=192.0.2.20 \
          --user=app_user \
          --port=3306 \
          --password
    

    The user account (Test Application Database User) should be specified by the --user option.

    MaxScale uses the Read/Write Split router to route the connection to one of the Enterprise Server nodes.

  3. Use the client connection to query the Enterprise Server node hostname:

    SELECT @@global.hostname;
    

    The output shows the hostname of one of the Enterprise Server nodes.

Test Xpand Administrative Access

  1. On the MaxScale node, use the maxctrl list listeners command to view the available listeners and ports:

    $ maxctrl list listeners
    
    ┌─────────────────┬──────┬──────┬─────────┬────────────────────┐
    │ Name            │ Port │ Host │ State   │ Service            │
    ├─────────────────┼──────┼──────┼─────────┼────────────────────┤
    │ es_listener     │ 3306 │ ::   │ Running │ es_service         │
    ├─────────────────┼──────┼──────┼─────────┼────────────────────┤
    │ xpand_listener  │ 5001 │ ::   │ Running │ xpand_service      │
    └─────────────────┴──────┴──────┴─────────┴────────────────────┘
    
  2. Use the MariaDB Client to connect to the listener port for the Xpand service (here 5001) on the MaxScale node:

    $ mariadb --host=192.0.2.20 \
          --user=app_user \
          --port=5001 \
          --password
    
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MySQL connection id is 3
    Server version: 5.0.45-Xpand-6.0.2
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MySQL [(none)]>
    

Next Step

Navigation in the procedure "Deploy Xpand Storage Engine Topology":

  • This page was step 9 of 9.

  • This procedure is complete.