MySQL operations,
simplifiedSecure and automate the deployment, maintenance and upgrades of your MySQL databases across private and public clouds.
Contact usMade to give you peace of mind
- SLA-backed support with optional screen sharing
- 10 years of security maintenance
- Hybrid and multi-cloud ready
Run MySQL on your favorite stack and across clouds
A hyper-automated MySQL made for high availability
Thanks to our software operator for MySQL, your deployments will be:
- Highly available with built-in replication and automatic failover.
- Reliable with expert-crafted and self healing state-machine automation.
- Upgraded automatically during your maintenance windows and with minimum downtime.
- Disaster recovery ready with built-in backup and restore capabilities to ensure business continuity.
- Hybrid and multi-cloud ready ‐ Our automation supports deployment within and across private and public clouds.
- Shipped with a holistic observability and alerting solution based on Prometheus, Loki and Grafana and Loki to monitor all of your database fleets.
What can you achieve with MySQL?
MySQL is one of the most popular databases. Its popularity is rooted in its sound architectural foundations that make it a good fit for several use cases:
Web and mobile applications
MySQL is the M in the popular LAMP architecture that powers a lot of e-commerce, content management and forum-like applications.
Data warehousing and business intelligence
MySQL is a capable relational database with good support for the SQL standard making it a good choice for running analytical queries without the need to duplicate your data.
Applications managing geospatial data
MySQL has extensive support for spatial data types and indexes making it a good choice for powering related systems.
FinOps and banking
MySQL provides the transactional ACID guarantees and the mature replication capabilities that finance systems need.
Text search use cases
MySQL also provides basic full text search capabilities allowing you to accommodate such use cases without the need for duplicating your data or compromising on its consistency.
Hardened and supported software packages
We provide 10 years of maintenance for MySQL related artefacts in the format of your choice:
- Deb packages for seamless integration with your Ubuntu installations.
- Snaps for added confinement and atomic updates.
- OCI-compliant images for your containerised environments.
You can also get 24/7 support with optional screen sharing for all your MySQL deployments.
How it works
The diagram below depicts a high level overview on the components we use. Key architecture insights:
- We use MySQL's Group Replication in single primary mode to provide high availability for our deployments.
- We also use MySQL Router to provide automatic and transparent failovers for the connected applications.
- We expose two endpoints. One for read and write operations on the primary, and another one to scale reads on the replicas.
- We can backup our deployments to any S3 compatible storage solution.
- We provide a full monitoring and alerting solution based on Prometheus, Loki and Grafana.
Services
Managed MySQL
We manage your MySQL deployments in the cloud of your choice. We can build a private cloud, adapt to your existing one or use public cloud infrastructure.
We take care of automatically deploying, hardening, patching, optimising and upgrading your MySQL databases using our open source operators.
Consulting
Unlock the potential of your data with Canonical's advisory services. We can:
- Design and architect tailored solutions for your specific use cases.
- Deliver Proof of Concepts (PoC) to implement your ideas and de-risk your projects.
- Train your staff on Canonical solutions for MySQL.
MySQL related resources
Guides
Best practices to migrate your data to the cloud.
Improve your security posture with a backup strategy.
From our blog
MySQL high availability made charmingly easy
Set up Charmed MySQL by following a set of commands.
Patterns to achieve database high availability
Avoid downtime with these proven best practices.
Should you use open source databases?
Learn about the drivers and challenges in open source database adoption.
"MySQL" is a trademark or registered trademark of Oracle. Other trademarks are property of their respective owners.
Canonical's MySQL offerings are not sponsored, endorsed, or affiliated with Oracle.