Infrastructure

Managed MySQL

Assistance-operated MySQL and MariaDB for production, commerce, CMS, and legacy application workloads


Managed MySQL is built for teams running web platforms, commerce systems, CMS workloads, internal business applications, and existing MySQL/MariaDB estates that need stronger operations without a disruptive platform rewrite.

Best-fit use cases#

Use caseWhy Managed MySQL fits
Existing MySQL applicationKeep the database engine your application expects while improving operations and reliability
CMS and commerce platformsFamiliar ecosystem for WordPress, Drupal, Magento, custom commerce, and LAMP-style systems
Business applicationsPredictable relational storage for ERP, CRM, inventory, and order-processing workloads
Legacy modernizationStabilize operations before broader application modernization
Development and stagingCost-effective managed databases on Assistance-operated physical servers

What Assistance operates#

AreaIncluded managed service responsibility
ProvisioningMySQL or MariaDB setup, topology selection, storage sizing, network placement, and secure baseline configuration
ReliabilityReplication, HA/failover design where required, backup policies, restore procedures, and operational runbooks
MaintenancePatch planning, minor version updates, lifecycle guidance, maintenance windows, and rollback plans
PerformanceSlow-query visibility, InnoDB tuning review, connection management, read replica guidance, and capacity review
SecurityTLS, encryption options, user/role recommendations, audit logging options, and credential rotation support
ObservabilityDashboards and alerts for availability, replication lag, storage, connections, locks, and backup health
SupportSeverity-based support and escalation for managed database platform incidents

Ownership boundary#

ResponsibilityAssistance ownsCustomer owns
Runtime operationsConfigure, monitor, patch, back up, restore, and operate MySQL/MariaDBApplication use of the database and client compatibility
Schema changesRisk review and rollout advice when scopedMigration scripts, data validation, rollback logic, ORM changes
AvailabilityReplication/failover mechanics inside agreed topologyApplication retry behavior, transaction handling, and deployment timing
Data retentionImplement agreed backup and retention policyLegal/business retention rules and data classification
AccessService accounts, least-privilege guidance, rotation procedureUser approval, identity source, application secret usage

Deployment options#

OptionWhen to use it
Assistance physical serversDevelopment, staging, CI dependencies, and predictable internal workloads with flat-rate economics
Customer cloud accountProduction systems that must live near application services or inside existing compliance controls
Managed cloud service operationsAssistance operates RDS, Azure Database for MySQL, Cloud SQL, or equivalent service in your account where appropriate
Migration engagementMove from self-hosted, hosted, or cloud-native MySQL into the agreed managed operating model

Reliability and support model#

TopicManaged MySQL approach
AvailabilityTarget and measurement window defined by deployment tier, topology, and support plan
BackupsAutomated backups with retention and point-in-time recovery targets defined during onboarding
FailoverDocumented replica promotion and routing behavior for HA deployments
RecoveryRestore testing or evidence checks included when recovery assurance is required
ResponseP1 response targets are scoped in the support agreement; 24/7 critical response is available for covered production services

Onboarding#

1. Workload review#

We inspect current database version, size, write/read patterns, slow-query history, replication status, backup posture, downtime tolerance, compliance requirements, and target environment.

2. Managed design#

Assistance proposes topology, sizing, replication, backup retention, recovery objectives, maintenance windows, access model, monitoring, and migration path.

3. Build or migrate#

We provision the managed MySQL environment and support migration through dump/restore, replication-based cutover, or staged environment promotion depending on risk and downtime tolerance.

4. Operate#

After handover, we monitor service health, replication, storage, backups, and performance indicators. Support paths and runbooks are kept aligned with the live environment.

Supported capabilities#

  • MySQL 8.0 and supported lifecycle versions by agreement
  • MariaDB for compatible workloads where it is the better operational fit
  • Replication and read replicas
  • ProxySQL or connection-pooling/routing patterns where appropriate
  • Slow-query logging and performance schema review
  • Backup retention and PITR targets scoped by plan

Not included by default#

  • Rewriting application SQL or business logic
  • Guaranteeing compatibility with unreviewed schema migrations
  • Owning CMS/plugin code or third-party application behavior
  • Unlimited retention, replica count, or cross-region topology outside the plan
  • Compliance certification work that requires a separate audit engagement

Getting started#

Frequently asked questions#

Can you manage MariaDB as well as MySQL? Yes. We support MariaDB where it is compatible with the workload and a better fit for licensing, features, or existing application expectations.

Can you migrate from RDS or Cloud SQL? Yes. We assess source configuration, data size, replication options, downtime tolerance, and rollback requirements before choosing the migration method.

Do you provide 99.99% uptime by default? No generic uptime promise is applied by default. Availability targets are scoped to topology, provider dependencies, customer responsibilities, and the selected support plan.

Do you tune application queries? We include database-level performance visibility and recommendations. Deeper application query rewrites or schema refactors are scoped as project work.

Can MySQL run on Assistance physical servers? Yes. This is often useful for development, staging, CI dependencies, and predictable internal workloads where flat-rate economics matter.