ProxySQL in Boulder

In an effort to keep Boulder's development environment reasonably close to production we use ProxySQL in our Docker stack to proxy connections to our MariaDB database.

Ports

ProxySQL listens on the following ports:

• 6033 Proxy MySQL Interface
• 6032 Admin MySQL Interface
• 6080 Admin Web Interface

Accessing the Admin MySQL Interface

mysql -uradmin -pradmin -h 127.0.0.1 --port 6032

MacOS

You will need to bind the port in docker-compose.yml, like so:

  bproxysql:
    ports:
      - 6032:6032

Accessing the Admin Web Interface

You can access the ProxySQL web UI at https://127.0.0.1:6080. The default username/ password are stats/ stats.

MacOS

You will need to bind the port in docker-compose.yml, like so:

  bproxysql:
    ports:
      - 6080:6080

Sending queries to a file

To log all queries routed through the ProxySQL query parser, uncomment the following line in the mysql_variables section of test/proxysql/proxysql.cnf, like so:

# If mysql_query_rules are marked log=1, they will be logged here. If unset,
# no queries are logged.
eventslog_filename="/test/proxysql/events.log"

Then set log = 1; for rule_id = 1; in the mysql_query_rules section, like so:

{
    rule_id = 1;
    active = 1;
    # Log all queries.
    match_digest = ".";
    # Set log=1 to log all queries to the eventslog_filename under
    # mysql_variables.
    log = 1;
    apply = 0;
},

Sending ProxySQL logs to a file

Replace the entrypoint: under bproxysql in docker-compose.yml with /test/proxysql/entrypoint.sh. This is necessary because if you attempt to run ProxySQL in the background (by removing the -f flag) Docker will simply kill the container.