Back to all use cases

Managed ServicesSoftware / Digital Platforms

Handing over the MySQL pager and the 8.0 problem together

Subscription Software Company

A typical engagement: AceMQ takes over operations of a software company's self-run MySQL 8.0 servers in the customer's own AWS account and runs the move to 8.4 LTS inside the managed service.

Overview

MySQL 8.0 moved to Oracle Sustaining Support on 21 April 2026, and a small platform team that already struggles to keep up with on-call, backups and replica health has one more project to schedule. This scenario describes how AceMQ's Tier 3 managed MySQL absorbs both, in an account the customer owns.

Challenge

The team ran its customer-facing database as a source and two replicas on EC2 instances. Backups had never been restored, replica lag grew during the nightly batch, minor releases slipped, and the move to 8.4 LTS kept losing to product work. Older application connectors still authenticated with mysql_native_password, which 8.4 disables by default.

Environment

MySQL 8.0 on Linux EC2 instances in the customer's AWS account, GTID-based asynchronous replication to two replicas, backups to object storage, and a change process the customer's security team controls.

Approach

Onboarding starts with an assessment of release level, backup and binary log retention, replica lag against the batch window, errant GTIDs, client connectors and authentication plugins. Active risks are fixed first. AceMQ then takes the pager under the contracted SLA, working through the customer's access controls and change process, and runs the 8.0 to 8.4 LTS upgrade as a project: rehearsal on a restored copy, a rollback plan at each step and a cutover window agreed with the customer.

Solution

  1. Assess the release, backup chain, binary log retention, replica lag, errant GTIDs and every client's authentication plugin before taking over
  2. Set up monitoring for lag, connections, long transactions, deadlocks and disk, routed to AceMQ's on-call
  3. Schedule restore tests into a scratch environment, with point-in-time recovery tried against a chosen moment, and record the results
  4. Rehearse the 8.0 to 8.4 LTS upgrade on a restored copy, including the authentication changes and replica apply behaviour
  5. Keep failover, restore and upgrade runbooks as the customer's property for a clean handover

Outcome

The engagement delivers an assessed estate, active risks remediated, monitoring and on-call run by AceMQ, scheduled restore tests with recorded results, and a rehearsed upgrade to a supported LTS series. The customer's data and AWS account stay with the customer throughout.

Technologies

MySQLAmazon EC2GTID Replication
  • Remediation

    MySQL Replication Lag Remediation

    E-Commerce Marketplace OperatorCross-Industry

    Resolving replica lag that grew to hours during batch windows because single-threaded apply could not keep pace with large multi-row transactions.

    MySQLProxySQLPrometheusLinux
    Read case study: MySQL Replication Lag Remediation
  • Managed Services

    Managed SQL Server in the Customer's Own Cloud Account

    SaaS Platform TeamSoftware

    A typical engagement: AceMQ takes over operations of a SaaS platform's SQL Server estate in the customer's own AWS account, with the data and the licences staying with the customer.

    SQL ServerAmazon EC2Always On Availability Groups
    Read case study: Managed SQL Server in the Customer's Own Cloud Account
  • Support

    Debezium MySQL Binlog Retention and Schema History Support

    Online Travel PlatformSoftware

    Ongoing support for a MySQL change data capture pipeline that needed a full re-snapshot after a planned outage outlasted binlog retention and a trimmed schema history topic.

    DebeziumMySQLSQL ServerOracle DatabaseKafkaAmazon RDS
    Read case study: Debezium MySQL Binlog Retention and Schema History Support

Related Reading

Looking for MySQL Managed Operations?

AceMQ's senior MySQL engineers have handled this exact type of engagement before. Whether you need architectural guidance, hands-on remediation, or an ongoing managed partnership, we're ready to help.