Architecture and data design
Assess schemas, access patterns, transactions, growth, partitioning, service boundaries, and where MySQL fits the system.
- Architecture decision record
- Data-model findings
- Scale and dependency risks
Free Database Audit: Get a comprehensive health report for your database - no obligation, NDA protected
Learn MoreSchedule AuditDatabase SRE architecture advisory
In short: MySQL consulting turns version, workload, topology, recovery, and operating evidence into a defensible architecture or migration decision. JusDB's Database SRE team delivers written findings, trade-offs, and validation criteria—not an unsupported instance count, uptime guarantee, or zero-downtime promise.
The engagement begins with the decision your team needs to make. Recommendations are checked against the exact MySQL release, compatible distribution, connector, plugin, and managed-service constraints in scope.
Consulting scope
A good engagement owns a defined decision and leaves implementation teams with evidence, constraints, and acceptance criteria.
Assess schemas, access patterns, transactions, growth, partitioning, service boundaries, and where MySQL fits the system.
Map the exact source to a supported LTS or Innovation target, then validate SQL, connectors, plugins, replication, and operations.
Review asynchronous replication, GTIDs, Group Replication, InnoDB Cluster, routing, quorum, fencing, and failure behavior.
Use workload, plans, locks, memory, storage, replication, connection, and growth evidence to identify the next constraint.
Evaluate backup coverage, restore tests, point-in-time recovery, privileges, encryption, secrets, logging, and patch strategy.
Compare self-managed MySQL, RDS, Aurora MySQL, Cloud SQL, Azure Flexible Server, Kubernetes, and compatible distributions.
Upgrade planning
The documented server path is only one part of the decision. SQL behavior, connectors, plugins, replication, rollback, and managed-platform constraints also need evidence.
MySQL 5.7 → MySQL 8.0 → MySQL 8.4 LTS
Oracle documents the intermediate 8.0 step. Logical migration or replication may be selected instead, but compatibility and rollback still require rehearsal.
MySQL 8.0 → MySQL 8.4 LTS
Run Upgrade Checker, review removed or changed behavior, connectors and plugins, then choose in-place, logical, or replication-led execution.
MySQL 8.4.x → MySQL 9.7.x LTS
Treat the next-LTS move as an application and operating-model change, even when the server path is supported.
Follow Oracle's current Innovation and intervening LTS rules
Innovation releases have a shorter cadence and may contain behavior changes; automated SQL and performance regression tests are essential.
Method
Agree on the architecture or planning question, environments, owners, service objectives, constraints, and evidence available.
Inventory versions, plugins, connectors, schemas, workload, plans, topology, configuration, metrics, recovery state, and incidents.
Compare options against compatibility, failure modes, correctness, lifecycle, operability, cost drivers, and change risk.
Document findings, rejected options, priorities, dependencies, acceptance criteria, rollback conditions, and accountable owners.
Scope boundaries
Separate scopes protect production ownership and prevent advisory copy from making implementation or support guarantees.
FAQ
MySQL consulting is a defined advisory engagement for architecture, version and upgrade planning, replication, high availability, cloud platform selection, security, capacity, data modeling, or recovery decisions. JusDB's Database SRE team reviews the available evidence and delivers written findings, trade-offs, validation steps, risks, and a prioritized roadmap. Implementation and ongoing operations are scoped separately.
Traditional DBA staffing often emphasizes routine administration. Database Reliability Engineering covers the wider production service: objectives, observability, automation, capacity, failure testing, incident learning, safe changes, and recovery as well as MySQL internals. JusDB identifies as a Database SRE or DBRE team; legacy remote-DBA URLs remain only for search and link continuity.
The target depends on your source release, support requirements, application compatibility, connectors, plugins, deployment platform, and change cadence. Oracle documents LTS and Innovation tracks and currently identifies 8.4.x and 9.7.x as consecutive LTS series. We verify the supported path with current MySQL documentation and MySQL Shell Upgrade Checker before recommending a target.
Oracle's documented path from MySQL 5.7 to 8.4 requires an intermediate upgrade to MySQL 8.0; LTS series cannot be skipped. A later move from 8.4.x to 9.7.x is documented as the next-LTS path. The practical migration may instead use logical export and import or replication, but compatibility, rollback, and data validation must be rehearsed for the actual environment.
Consulting can identify performance risk and define a remediation roadmap, but a performance-tuning engagement owns the measured bottleneck, controlled changes, and before-and-after validation. Keeping those scopes separate prevents an architecture review from making unsupported promises about query latency or throughput before representative workload evidence is available.
No topology can guarantee a universal uptime percentage or zero interruption. InnoDB Cluster, Group Replication, and MySQL Router can automate parts of membership, primary election, and routing, but quorum, fencing, capacity, network conditions, application reconnect behavior, data consistency, and operator procedures still determine impact. We design and test against agreed RPO and RTO objectives.
Useful inputs include the exact MySQL distribution and patch level, platform, topology, schemas, representative queries and plans, growth, workload windows, configuration, connector versions, replication and backup state, relevant metrics, incidents, service objectives, security constraints, and planned changes. Sanitized or read-only evidence can be used where direct access is restricted.
Yes, after the advisory findings are accepted and implementation scope, access, change ownership, validation, and rollback are agreed. Performance work belongs in performance tuning, cutover execution belongs in migration, incident response belongs in Support, and ongoing observability, maintenance, capacity, recovery, and reliability improvement belong in retained MySQL DBRE.
Technically reviewed by the JusDB Database Reliability Engineering team (Database SRE/DBRE). Last reviewed 19 July 2026. Recommendations are rechecked against the exact server, connector, plugin, topology, and managed platform versions in scope.
Bring the decision, current version and platform, workload constraints, and reliability objectives. We will help define a review scope and decision-ready outputs.