MySQL vs MariaDB

Monitors Galera cluster membership, flow control pause percentages, and receive queue backlog across active-active cluster nodes.

# 1. Audit Galera cluster size, status, and flow control pauses
mariadb -h galera-node1 -u dbre_admin -p -e "
SHOW GLOBAL STATUS WHERE Variable_name IN (
  'wsrep_cluster_size', 
  'wsrep_cluster_status', 
  'wsrep_connected', 
  'wsrep_ready', 
  'wsrep_flow_control_paused', 
  'wsrep_local_recv_queue_avg'
);"

# 2. Inspect active replication certification queue depth
mariadb -h galera-node1 -u dbre_admin -p -e "
SHOW STATUS LIKE 'wsrep_local_recv_queue'; 
SHOW STATUS LIKE 'wsrep_cert_deps_distance';"

Identifies thread saturation, client connection spikes, and authentication plugin configurations across user accounts.

# 1. Audit active client connection threads and thread pool health
mysql -h mysql-host -u dbre_admin -p -e "
SHOW GLOBAL STATUS WHERE Variable_name IN (
  'Threads_connected', 
  'Threads_running', 
  'Connections', 
  'Slow_queries'
);"

# 2. Inspect authentication plugins configured across all user accounts
mysql -h mysql-host -u dbre_admin -p -e "
SELECT 
  user, 
  host, 
  plugin 
FROM mysql.user 
WHERE user NOT IN ('mysql.session', 'mysql.sys');"