Percona Server for MySQL 8.4 LTS on Ubuntu 24.04

Percona Server for MySQL 8.4 LTS on Ubuntu 24.04 by cloudimg

Percona Server for MySQL 8.4.8 LTS on Ubuntu 24.04 LTS (Noble Numbat), purpose-built for Microsoft Azure and maintained by cloudimg. Percona Server is a free, open-source, 100%-compatible drop-in replacement for MySQL Community Edition with enterprise-grade performance, scalability, and observability features — extra storage engines, advanced threadpool, deeper InnoDB telemetry, and longer LTS support windows than upstream MySQL.

Why Choose cloudimg?

• 24/7 Expert Support with guaranteed 24-hour response and 1-hour critical-issue average. Contact support@cloudimg.co.uk
• Production-Ready from Launch — security-patched, validated, and pre-configured before publication
• Azure-Native Integration — Azure Linux Agent, cloud-init, Gen2 Hyper-V boot
• Per-VM Credential Generation — both `root@127.0.0.1` (TCP) and `cloudimg` (application user) passwords rotated uniquely at first boot. `root@localhost` stays on `auth_socket` so customers can always recover via `sudo mysql`. Credentials written to `/etc/cloudimg-credentials.txt` (mode 0600).
• Memory-Tuned for Standard_B2s — `innodb_buffer_pool_size=256M`, `performance_schema=OFF`, `max_connections=100` keep the server stable on a 4 GB VM out of the box. Customers can raise these on larger sizes.

What is Included

• Percona Server for MySQL 8.4.8-8 LTS from `repo.percona.com/ps-84-lts`
• Bound to `127.0.0.1:3306` by default — open NSG port 3306 + change `bind-address` to `0.0.0.0` to allow remote clients
• `cloudimg` application user with full privileges on the `cloudimg` schema
• Anonymous users + test database removed at first boot
• percona-server-mysql-8-4-firstboot.service systemd one-shot
• mysql.service systemd unit auto-starting on boot
• Ubuntu 24.04 LTS base with latest security patches at build time
• Azure Linux Agent for SSH key injection and seamless cloud integration

Use Cases

• Drop-in upstream MySQL replacement for application backends
• Production OLTP database for SaaS workloads needing extended LTS
• Replication source/replica with ROW binlog format pre-configured
• Observability-heavy MySQL workloads (Percona's enhanced sys schema and performance counters)
• Migration target from upstream MySQL Community Edition with zero compatibility changes

Technical Specifications

• Operating System: Ubuntu 24.04 LTS (Noble Numbat)
• Percona Server Version: 8.4.8-8 LTS
• Default Port: 3306 (bind-address 127.0.0.1)
• Default Schema: `cloudimg` (rotate or recreate as needed)
• Authentication: caching_sha2_password (MySQL 8 default) for cloudimg + root@127.0.0.1; auth_socket for root@localhost
• Service Management: systemd (mysql.service, percona-server-mysql-8-4-firstboot.service)
• Recommended Size: Standard_B2s for development; Standard_D4s_v3 or larger for production
• VM Generation: Hyper-V Gen2 with UEFI boot

Notes on Hardening

For production replication, set `server_id` uniquely per replica, configure `gtid_mode=ON`, and use `mysqldump` or Percona XtraBackup for snapshots. For TLS, generate certificates and add `ssl-ca`, `ssl-cert`, `ssl-key` to `/etc/mysql/mysql.conf.d/zz-cloudimg-percona.cnf`. Increase `innodb_buffer_pool_size` to ~50–75% of RAM on production-sized VMs.

Support

cloudimg provides 24/7/365 expert technical support. Contact support@cloudimg.co.uk or visit www.cloudimg.co.uk.