db-ping

MariaDB/MySQL compatible database connection and capability checker

Is your database connection unstable? Do you want to know the SLA of your database connection over a longer period, or just quickly measure how long of a downtime a database restart or some other operation caused? When the database isn't serving queries, do you want to know exacly why?

This tool helps to measure and identify database connectivity issues such as:

• Downtime duration and SLA
• DNS propagation delay, hostname not matching active database server
• TCP/IP routing issues, server not reachable
• TLS certificate issues
• Authentication errors
• Server load issues: too many connections, too many queries or too much load
• Server health issues: disk write operations stalled or other I/O delay

Under development

This tool is in very early stages of development and not intended for general use yet, but it does run and can be tested.

Installation

$ pip3 install https://github.com/ottok/db-ping/archive/refs/heads/main.zip

In addition to the Python 3.x standard library, db-ping requires dnspython and the MariaDB Connector/Python client library for MariaDB/MySQL databases.

pip3 will attempt to install these dependencies automatically, but OS- or distribution-specific procedures may be necessary in some cases. For example, on Ubuntu and other Debian-based distributions, you must install the MariaDB C libraries as follows:

$ sudo apt-get install libmariadb3 libmariadb-dev

Usage

See db-ping --help for complete options.