Hardened MySQL 9.7 LTS on CentOS Stream 9

Charges for this image cover the security hardening, optimization, and pre-integration work Hanwei performs on top of the upstream MySQL 9.7 LTS and CentOS Stream 9 projects. MySQL 9.7 LTS is installed from the MySQL community repository, the data directory is initialized and the service is enabled, so the server is listening when the instance finishes booting. This is the current long-term support series, with vendor support published through 2034. The operating system underneath carries the same hardened and tuned baseline used across this catalogue.

What Hanwei Adds to Upstream MySQL 9.7 LTS

• Server installed and initialized at build time: packages come from the MySQL 9.7 LTS community repository, /var/lib/mysql is initialized and mysqld is enabled, so the server accepts local connections as soon as the instance boots.
• Transparent huge pages disabled at boot: a oneshot unit sets them to never before the database starts, following the vendor's guidance. This is not the distribution default, where the tuned virtual-guest profile leaves them enabled.
• TLS material generated per instance, not baked into the image: the server certificate, CA and RSA key pair are removed before sealing and regenerated on first boot, so no two subscribers share a private key.
• Tuning baseline applied identically across the catalogue: the file descriptor limit goes from 1024 to 65536 and the memory-map ceiling from 65530 to 262144; the device receive backlog goes from 1000 to 16384 and the TCP SYN backlog from 128 to 8192, so bursts queue instead of being dropped; socket buffer maxima reach 16 MB for larger autotuned windows; connections keep their congestion window across idle periods; and the journal is capped at 500 MB. The profile raises ceilings only and does not alter protocol semantics or application behaviour.
• Applied hardening beyond the distribution default: SSH is limited to a vetted cipher, key exchange and MAC list, X11 forwarding is off, the login grace period is shortened and verbose authentication logging is on; auditd runs a base rule set for privileged command execution; the kernel drops ICMP redirects on IPv4 and IPv6, logs martian packets, filters reverse paths in loose mode, restricts dmesg, disables setuid core dumps and turns off sysrq.
• AWS operational integration: the SSM Agent is installed and enabled for Session Manager and Patch Manager without an inbound SSH rule; chrony points at the Amazon Time Sync Service; and the root filesystem extends at boot when the volume exceeds the image default.
• Patch level set at the build date: packages come from official upstream repositories at the newest level published when the image was built.
• Repeatable build and EC2 validation: each version comes from the same build process and is launched and exercised on EC2 before release.

Access and Security Posture

• SELinux runs in enforcing mode and auditd records activity against a base rule set.
• Sign in as 'ec2-user' with the key pair selected at launch, then use 'sudo su -' for a root shell. Session Manager is available as an alternative that needs no inbound port.
• Direct root login over SSH is disabled and password authentication is not accepted.
• No authorized keys and no SSH private keys are embedded in the image.

Operational Impact on EC2

• Launch-to-usable-database time is reduced to a single boot cycle.
• Every instance starts from an identical configuration, removing drift between development, staging and production hosts.
• Network services need no per-host limit or backlog adjustment before handling load.
• Clock accuracy comes from the Amazon Time Sync Service, which matters for log correlation and request signing.
• Post-launch patching effort is lower because the package set is current at release.

Where This Image Fits

• New deployments that should start on the current MySQL long-term support series.
• Application backends that need a MySQL endpoint on an instance the team controls.
• Development and test environments recreated frequently from an identical database configuration.
• Workloads that need the longest available MySQL support window without changing engine.

About MySQL 9.7 LTS and CentOS Stream 9

MySQL 9.7 is the current long-term support release. The 9.x series continues the InnoDB storage engine while adding JavaScript stored programs, vector data types for similarity search, and optimizer and replication refinements. As an LTS release its behaviour is held stable through the series, and vendor support runs to 2034.

CentOS Stream 9 is a Linux distribution that tracks the development stream of Red Hat Enterprise Linux 9. Packages land in CentOS Stream before they appear in a RHEL minor release, so it stays close to the RHEL package set and toolchain while remaining freely redistributable. It uses dnf, systemd and SELinux, which makes it a predictable base for server workloads that need RHEL compatibility.