Emergency Incident Response
Server down, replication broken, disk full, or a table locked behind a runaway DDL. A senior engineer joins a live bridge within 15 minutes with access to diagnose — not a ticket acknowledgement.
MySQL Support
Last reviewed by Scott Sternloff
AceMQ provides 24/7 MySQL support from named senior engineers, with a 15-minute response to a production emergency, for self-managed servers, RDS, Aurora and Percona. MySQL 8.0 has been in Oracle Sustaining Support since April 2026, so we also run the 8.0 to 8.4 LTS upgrade as a project, with the support contract in place while it happens. Replica lag, InnoDB deadlocks, ALTER statements that hold a metadata lock for hours and binlogs filling a volume are the daily work.
Planning a build, upgrade or migration instead? See AceMQ MySQL consulting and services.
Customers




Partners


Incident Triage
These are real symptoms from real MySQL production environments — and the first thing our engineers check when one comes in.
| Symptom you're seeing | What we check first | Typical resolution |
|---|---|---|
| Replica lag climbing into hours during the nightly batch | Whether apply is actually parallel — replica_parallel_workers and replica_parallel_type, plus binlog_transaction_dependency_tracking on 8.0 (8.4 removes it and always uses writesets). A single large multi-row transaction serialises the whole apply pipeline regardless of worker count, so we look at transaction size before we look at hardware. | 1–2 hours |
| Disk read I/O spiking while query volume stays flat | Innodb_buffer_pool_reads against Innodb_buffer_pool_read_requests for the real hit rate. An undersized buffer pool means the hot working set no longer fits, and every index lookup that used to be memory-resident becomes a disk seek. | Under 1 hour |
| Deadlocks and lock wait timeouts appearing under normal concurrency | SHOW ENGINE INNODB STATUS for the last deadlock, then the access pattern behind it. Under REPEATABLE READ, gap and next-key locks on a secondary index range are taken far wider than developers expect, so two statements that look disjoint contend on the same gap. | 1–2 hours |
| An ALTER TABLE has blocked writes for hours | Whether that specific DDL is INPLACE or COPY on your version, and the metadata lock queue behind it — one long-running SELECT can block the ALTER, which then blocks every subsequent query on the table. For large tables we move the change to gh-ost or pt-online-schema-change. | 2–4 hours |
| Binary logs filling the disk with no change in write volume | binlog_expire_logs_seconds against what is still reading the stream. A stopped replica or a paused CDC connector holds a position, and purge won't advance past a needed file. Row-based logging on wide-table updates also inflates binlog size dramatically. | Under 1 hour |
| "Too many connections" with the server mostly idle | Threads_connected versus Threads_running and the count of long-sleeping connections. Usually an application pool with no max, or a framework opening a connection per request without returning it — raising max_connections buys hours, not a fix. | Under 2 hours |
| A report query became ten times slower after a data load | Index statistics freshness — InnoDB's sampled statistics can drift badly after a bulk load, flipping the optimizer to the wrong index. We run ANALYZE TABLE, review histograms for skewed columns, and check whether a GROUP BY is now spilling internal temp tables to disk. | Under 2 hours |
| After failover a replica refuses to start with a GTID error | gtid_executed on both sides for errant transactions — writes applied directly to a replica that the new primary has never seen. These have to be identified and either injected as empty transactions or resolved by reseeding, and read_only enforcement fixed so it can't recur. | 2–4 hours |
Resolution times reflect typical MySQL engagements under an active AceMQ support contract. Every P1 closes with a written root-cause analysis.
What's Included
MySQL services under one contract: incident response, query and index tuning, replication and high availability review, schema changes, and consulting on upgrades and migrations between self-managed and managed MySQL database services.
Server down, replication broken, disk full, or a table locked behind a runaway DDL. A senior engineer joins a live bridge within 15 minutes with access to diagnose — not a ticket acknowledgement.
Every P1 closes with a written RCA: what failed, why, the fix applied, and the schema, index, or configuration change that stops it happening again. Delivered as standard, not on request.
EXPLAIN ANALYZE on your real slow log, composite index ordering, covering indexes, histogram statistics for skewed columns, and killing the temp-table spills that come from unindexed GROUP BY and ORDER BY.
GTID hygiene, semi-synchronous replication trade-offs, InnoDB Cluster and Group Replication behaviour under partition, and failover automation that fails over for the right reasons.
Alerts for CVEs affecting your exact MySQL, Percona, or MariaDB build, with tested upgrade paths — including the 5.7 to 8.x jump where authentication plugin and collation changes break clients.
Large table alterations with gh-ost or pt-online-schema-change, major version upgrades, and migrations between self-managed, RDS, Aurora, and Percona — planned with a rehearsed rollback.
Why AceMQ
The same senior engineers stay on your account. They know your schema, your replication topology, and your batch windows — so a P1 call starts with a hypothesis instead of twenty minutes of context transfer.
You reach a senior MySQL engineer directly by phone, email, or Slack. Nobody collects information to hand off, and there is no escalation approval between you and the person who can read an InnoDB status dump.
Large table DDL is where most MySQL maintenance goes wrong. We plan alterations with gh-ost or pt-online-schema-change, measure the throttle against your replica lag budget, and rehearse the cutover before it touches production.
Aurora MySQL replaces the storage and redo layer outright, which changes failover, replica lag, and what buffer pool tuning even means. We support all three models and know which advice stops applying where.
Engineers across 26+ countries and every time zone. Your 3am replication break is someone's mid-afternoon — no overnight skeleton crew, no waiting for a region to come online.
We diagnose across the connection pool, the ORM's generated SQL, storage latency, filesystem and kernel settings, and Kubernetes. MySQL symptoms often have causes well outside the database process.
Cloud, Kubernetes, bare metal, hybrid, and air-gapped — including environments where you can't give us outbound network access.
Upgrade project
MySQL 8.0 moved to Oracle Sustaining Support on 21 April 2026, and managed MySQL services set their own end-of-standard-support dates for it, so most estates are now planning the move to 8.4 LTS. This is the checklist we work through. MySQL 5.7 has to go through 8.0 first.
| Upgrade step | What we check | What changes in 8.4 |
|---|---|---|
| Authentication | Accounts and drivers still using mysql_native_password | Deprecated and disabled by default, so those clients fail to connect until the accounts or the setting change |
| Replication syntax | Failover scripts, monitoring and tooling that call CHANGE MASTER TO, SHOW SLAVE STATUS or START SLAVE | These statements are removed; the REPLICA and REPLICATION SOURCE forms replace them |
| Configuration | my.cnf and cloud parameter groups for expire_logs_days, default_authentication_plugin and transaction_write_set_extraction | Removed variables are rejected at startup; binlog_expire_logs_seconds and authentication_policy replace the first two |
| Table definitions | AUTO_INCREMENT on FLOAT or DOUBLE columns, and foreign keys on non-unique or partial keys | The first blocks the upgrade; the second is rejected by default through restrict_fk_on_non_standard_key |
| Changed defaults | innodb_adaptive_hash_index, innodb_io_capacity, innodb_flush_method and innodb_log_buffer_size | Several defaults change, so the performance profile moves even with an unchanged config file |
| Rehearsal and cutover | Upgrade a replica first, replay real traffic, then promote | Replication from an older source to a newer replica is supported, not the reverse, so the rollback is planned before cutover |
Source: MySQL 8.4 Reference Manual, What Is New in MySQL 8.4, checked 20 October 2026. If the upgrade cannot happen before your deadline, OSSeva (osseva.io) supplies patched builds of MySQL 5.7 and 8.0 Community while you finish it.
Escalation Path
Every tier reaches a senior MySQL engineer. There is no tier-1 triage layer to get through.
P1 escalation path
A replay of one P1, from the first page to the written root-cause analysis
15-minute P1 response, 24/7.
A response time, not a resolution time.
P1 opened, on-call engineer paged
Phone, email or Slack reaches the on-call senior engineer directly, whether the incident is in RabbitMQ, Kafka, Redis, PostgreSQL or Kubernetes. No web form, no tier-1 queue.
Senior engineer on your bridge
A senior engineer who already knows your environment joins a live bridge, so nobody has to re-explain your topology.
Specialists across the stack join
When an incident crosses components, the engineers who know each one join. For RabbitMQ, the path runs to the core team.
Written root-cause analysis
Root cause, the fix applied and the prevention steps, delivered after every P1.
Pricing
AceMQ MySQL support contracts typically run $24,000–72,000 a year, depending on SLA level, scope (number of clusters or nodes, and environments) and deployment (self-managed, cloud-managed or Kubernetes).
| What moves the price | How it changes the contract |
|---|---|
| SLA level | Business-hours cover costs less than 24/7 cover with a 15-minute emergency response. |
| Scope | More clusters or nodes, and more environments, make a larger contract. |
| Deployment | Self-managed, cloud-managed and Kubernetes estates need different amounts of hands-on work. |
Covering several technologies under one contract, for example RabbitMQ, Kafka and Redis, earns an aggressive discount.
Support In Practice
MySQL support work from AceMQ. Each card links to the full write-up: the database estate, what AceMQ diagnosed or changed, and the result.
Digital Commerce Platform
Emergency remediation of a Memcached tier evicting hot keys while reporting free memory, traced to slab class allocation.
B2B SaaS Platform Provider
Assessment of Memcached sizing, key distribution, and hit rate to determine whether adding capacity would actually help.
E-Commerce Marketplace Operator
Resolving replica lag that grew to hours during batch windows because single-threaded apply could not keep pace with large multi-row transactions.
Travel Booking Platform
Ongoing support for deadlocks and lock wait timeouts under booking concurrency, including history list growth from long-running transactions.
Media Streaming Provider
Review of replication topology, failover readiness, backup recoverability, and configuration drift across a MySQL estate that had grown organically.
Online Travel Platform
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.
Support options
AceMQ offers MySQL support in four tiers, each handing more of the day-to-day work to AceMQ: 24/7 support and incident management for servers your DBAs run, proactive monitoring that finds replica lag, errant GTIDs and backup gaps first, managed MySQL on your own infrastructure, and fully managed MySQL on AceMQ infrastructure. MySQL 5.7 to 8.4 is supported, and 5.7 and 8.0 can be kept patched through OSSeva.
You run it, we back you up
Best for: DBA teams that run MySQL themselves and need senior escalation cover.
You run it, we watch it with you
Best for: Teams that want the stalled replica or the unrestorable backup found in a review, not in an outage.
We run it in your cloud or data centre
Best for: Regulated estates that must keep MySQL inside their own boundary.
We host it and run it, as a service
Best for: Teams that want MySQL without a DBA rota or an Aurora bill they cannot tune.
| Who does what | Tier 1 24/7 support | Tier 2 Proactive monitoring | Tier 3 Managed, your infrastructure | Tier 4 Fully managed by AceMQ |
|---|---|---|---|---|
| Who runs MySQL day to day? | Your team | Your team, with AceMQ reviews | AceMQ | AceMQ |
| Where does it run? | Your infrastructure | Your infrastructure | Your cloud account or data centre | AceMQ infrastructure |
| 24/7 incident response | 15-minute P1 response | 15-minute P1 response | 15-minute P1 response | 15-minute P1 response |
| Health checks and CVE alerts | On request | Scheduled | Included | Included |
| Patching and upgrades | Your team, AceMQ advises | Planned with AceMQ | Done by AceMQ | Done by AceMQ |
| Monitoring and on-call | Your team | Your team | AceMQ | AceMQ |
| Data, keys and accounts | Yours | Yours | Yours | Your data, hosted by AceMQ |
Every Tier can start as an ad hoc engagement or an annual partnership, and you can move up or down a Tier as your team changes.
One partner for MySQL
Support is one part of what AceMQ does for MySQL. The same engineers deliver consulting, health checks, migrations and end-of-life cover, and support the systems that usually run next to it.
MySQL support covers 24/7 emergency incident response with a 15-minute SLA, root cause analysis on every P1, query and index tuning, replication and HA review, online schema change planning, CVE and patch advisory, quarterly health checks, and upgrade or migration support. Every ticket goes to a named senior engineer assigned to your account. There is no first-line triage layer and no per-incident charge.
Yes, alongside self-managed, Percona, and MariaDB deployments. The distinction matters more than most vendors admit: Aurora MySQL replaces InnoDB's storage and redo handling with a distributed log-structured layer, so replica lag, failover behaviour, and buffer pool tuning all work differently from RDS MySQL or a self-managed server. We support all of them, and part of what you get is knowing which advice from the internet stops being true on your platform.
MySQL 8.0 is: Oracle moved it to Sustaining Support on 21 April 2026 (mysql.com, checked 20 October 2026), so Oracle no longer ships new fixes for it. The 8.4 LTS series is the supported line to move to. AceMQ supports both around the clock, runs the 8.0 to 8.4 upgrade, and OSSeva can supply patched 8.0 Community builds if the upgrade has to wait.
It depends on the engine. REPAIR TABLE only helps MyISAM, ARCHIVE and CSV tables. For InnoDB the usual route is to restore the last good backup and replay the binary logs to the point just before the damage. If there is no usable backup, innodb_force_recovery lets the server start in a restricted mode so the data can be dumped and reloaded into a clean instance. We run this against a copy first, because the higher recovery levels can make the damage worse.
P1 emergencies — server unavailable, replication broken, disk full, tables locked — get a 15-minute first response with a senior engineer joining a live bridge. P2 critical issues are 1 hour, P3 high-priority 4 hours, and P4 standard questions next business day. These are contractual response times covering nights, weekends, and holidays.
Usually yes. Replica lag during batch windows is almost always a concurrency problem in the apply path rather than a throughput problem on the replica. Older versions apply serially by default, and even with parallel workers configured, a single transaction that updates millions of rows serialises everything behind it. We check transaction sizing first, then worker configuration and, on 8.0, binlog_transaction_dependency_tracking, then whether row-based logging on wide tables is inflating the stream. Splitting the batch into bounded chunks fixes more of these than adding CPU ever does.
Not a blocking ALTER, whatever the version claims about online DDL. Some operations run INPLACE without a table rebuild, but many still copy, and even an INPLACE operation needs a brief exclusive metadata lock at the start and end that can queue behind one long-running SELECT and stall every query on the table. For large tables we use gh-ost or pt-online-schema-change to build a shadow copy with the throttle tied to your replica lag budget, then swap atomically. We rehearse against a restored copy first so the runtime and lag impact are measured rather than guessed.
Yes. We support 5.7 and older builds that no longer receive upstream patches, including backported mitigations and workarounds where official fixes are unavailable. Plenty of regulated and vendor-locked environments cannot upgrade on Oracle's timeline. In parallel we map the 8.x upgrade path, because that jump carries real breakage — the default authentication plugin, utf8mb4 collation changes, and reserved word additions all surface as client failures rather than server failures. Where you need security patches on a version you cannot yet leave, AceMQ's OSSeva platform provides patched builds of MySQL 5.7 and 8.0 Community Edition after Oracle stops fixing them.
Oracle sells technical support as part of MySQL Enterprise Edition, which also includes tools such as MySQL Enterprise Backup, Enterprise Audit and the monitoring console, and covers releases inside Oracle Lifetime Support. That is the only source of product fixes, and worth keeping for Enterprise customers on a supported release. It does not cover MySQL Community Edition, Percona Server, cloud-hosted MySQL, or any version in Sustaining Support, which since April 2026 includes MySQL 8.0. AceMQ provides MySQL support for all of those: expert MySQL support engineers on call around the clock for the MySQL server you actually run, with the reliability, scalability and uptime work that keeps incidents from recurring. Where a fault is a genuine defect on a supported Enterprise release, we prepare the Oracle case with the diagnosis done.
MySQL 5.7, 8.0, 8.4 LTS and the innovation releases, on Community Edition, Enterprise Edition and Percona Server, plus MariaDB estates that grew out of MySQL. Platforms covered are on-premises, self-managed in any cloud, Kubernetes with the common operators, and managed services such as Amazon RDS and Aurora MySQL, Azure Database for MySQL and Cloud SQL, where the provider runs the server and we cover schema, queries, replication behaviour and the upgrade calendar the provider imposes. High availability with Group Replication, InnoDB Cluster or Orchestrator, backup and point-in-time recovery, and upgrades from 5.7 through 8.0 to 8.4 LTS are all in scope.
Beyond incident response, the contract covers the work that prevents incidents: query and index reviews from the slow log and performance schema, InnoDB buffer pool and redo sizing, replication topology and lag monitoring, connection pooling with ProxySQL or in the application, online schema change tooling for large tables, and backup restores that are actually rehearsed. Each review leaves documented configuration and a runbook, so the next problem is handled faster whether or not we are on the call.
Yes. MySQL 8.0 moved to Sustaining Support in April 2026, so most estates are now planning the 8.4 LTS move. The usual surprise is authentication: mysql_native_password is disabled by default in 8.4 and removed in 9.0, so clients and accounts still using it fail to connect after the upgrade. We find those accounts and drivers first, test the application against 8.4 on a replica, and cut over with a rehearsed rollback.
With a baseline health check rather than waiting for the first outage. We review configuration, replication topology and lag history, the slow log, backup and restore evidence, and the versions and CVEs that apply to your builds, then agree access and escalation paths for incidents. The written findings rank what is most likely to page you next, so MySQL support starts by removing known risks while the 15-minute emergency response is already in place.
Yes. MySQL consulting from AceMQ is project work with a written outcome, run by the engineers who also answer the pager: the 8.0 to 8.4 LTS upgrade, a replication and HA review, query and index tuning, or an online schema change on a large table. Many teams start with one project and keep the support contract afterwards.
Yes. AceMQ works on MySQL in two ways: ad hoc engagements for a defined piece of work, such as a health check, an upgrade or an incident, or an annual partner engagement that covers 24/7 support, proactive reviews and named engineers. Many teams start ad hoc and move to an annual partnership once the first engagement is done.
Every AceMQ proposal is tailored to your requirements: your MySQL environment, the SLA you need, the hours of cover and the scope of work. Most contracts run $24,000–72,000 a year, depending on the SLA, the scope and how MySQL is deployed, with aggressive discounts when several technologies share one contract. Request a quote and AceMQ replies within 1 hour.
Let's talk
Reactive cover, proactive reviews, or AceMQ running MySQL for you on your infrastructure or ours. A senior engineer scopes it with you, and quote requests are answered within 1 hour.
Production incident right now?Email a MySQL Architect
Send us a message and we'll follow up within 1 hour — or book a free 30-min consultation directly.
305-204-2607info@acemq.comPrefer to talk now? Call us directly or use the consultation tab to find a time that works.