MySQL Filter

    The following documentation runs through the setup of Envoy described above.

    Ensure that you have a recent versions of and docker-compose installed.

    A simple way to achieve this is via the Docker Desktop.

    Step 2: Clone the Envoy repo

    SSH

    HTTPS

    1. git clone https://github.com/envoyproxy/envoy.git

    Terminal 1

    Step 4: Issue commands using mysql

    Terminal 1

    1. $ docker run --rm -it --network envoymesh mysql:5.5 mysql -h envoy -P 1999 -u root
    2. ... snip ...
    4. mysql> CREATE DATABASE test;
    5. Query OK, 1 row affected (0.00 sec)
    7. mysql> USE test;
    8. Database changed
    9. Query OK, 0 rows affected (0.01 sec)
    11. mysql> SELECT COUNT(*) FROM test;
    13. | COUNT(*) |
    14. +----------+
    15. |        0 |
    16. +----------+
    17. 1 row in set (0.01 sec)
    19. mysql> INSERT INTO test VALUES ('hello, world!');
    20. Query OK, 1 row affected (0.00 sec)
    22. mysql> SELECT COUNT(*) FROM test;
    23. +----------+
    24. | COUNT(*) |
    25. |        1 |
    26. +----------+
    29. mysql> exit
    30. Bye

    Check egress stats were updated.

    Terminal 1

    Step 6: Check TCP stats

    Terminal 1

    1. $ curl -s http://localhost:8001/stats?filter=mysql_tcp
    2. tcp.mysql_tcp.downstream_cx_no_route: 0
    3. tcp.mysql_tcp.downstream_cx_rx_bytes_buffered: 0
    4. tcp.mysql_tcp.downstream_cx_rx_bytes_total: 347
    5. tcp.mysql_tcp.downstream_cx_total: 1
    6. tcp.mysql_tcp.downstream_cx_tx_bytes_buffered: 0
    7. tcp.mysql_tcp.downstream_cx_tx_bytes_total: 702
    8. tcp.mysql_tcp.downstream_flow_control_paused_reading_total: 0
    9. tcp.mysql_tcp.downstream_flow_control_resumed_reading_total: 0
    10. tcp.mysql_tcp.idle_timeout: 0
    11. tcp.mysql_tcp.upstream_flush_total: 0