Benchmark: MySQL
Description
This section contains recommendations for configuring MySQL resources.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-azure-complianceStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select MySQL.
Run this benchmark in your terminal:
powerpipe benchmark run azure_compliance.benchmark.all_controls_mysqlSnapshot and share results via Turbot Pipes:
powerpipe benchmark run azure_compliance.benchmark.all_controls_mysql --shareControls
- SQL managed instances should use customer-managed keys to encrypt data at rest
- Vulnerability assessment should be enabled on SQL Managed Instance
- Geo-redundant backup should be enabled for Azure Database for MySQL
- Ensure server parameter 'audit_log_enabled' is set to 'ON' for MySQL flexible Server
- Ensure server parameter 'audit_log_events' has 'CONNECTION' set for MySQL flexible Server
- Ensure server parameter 'tls_version' is set to 'TLSv1.2' (or higher) for MySQL flexible server
- Ensure server parameter 'require_secure_transport' is set to 'ON' for MySQL flexible server
- Ensure server parameter 'audit_log_enabled' is set to 'ON' for MySQL Database Server
- Ensure server parameter 'audit_log_events' has 'CONNECTION' set for MySQL Database Server
- MySQL servers should use customer-managed keys to encrypt data at rest
- Infrastructure encryption should be enabled for Azure Database for MySQL servers
- Ensure 'TLS Version' is set to 'TLSV1.2' for MySQL flexible Database Server
- Private endpoint should be enabled for MySQL servers
- Public network access should be disabled for MySQL servers
- Enforce SSL connection should be enabled for MySQL database servers