Charmed MySQL Documentation

charm
, ,
1

Charmed MySQL documentation

This is IAAS/VM operator. To deploy in K8s, use Charmed MySQL K8s.

The Charmed MySQL Operator delivers automated operations management from day 0 to day 2 on the MySQL Community Edition relational database. It is an open source, end-to-end, production-ready data platform on top of Juju.

image
image1800×1107 224 KB

MySQL is the world’s most popular open source database. A relational database stores data in separate tables rather than putting all the data in one big storeroom. The database structure is organized into physical files optimized for speed. The logical data model, with objects such as data tables, views, rows, and columns, offers a flexible programming environment.

This MySQL operator charm comes in two flavours to deploy and operate MySQL on physical/virtual machines and Kubernetes. Both offer features such as replication, TLS, password rotation, and easy to use integration with applications. The Charmed MySQL Operator meets the need of deploying MySQL in a structured and consistent manner while allowing the user flexibility in configuration. It simplifies deployment, scaling, configuration and management of MySQL in production at scale in a reliable way.

“Charmed MySQL”, “MariaDB”, “OSM MariaDB”, “Percona Cluster” or “Mysql Innodb Cluster”?

This “Charmed MySQL” operator is a new “Charmed SDK”-based charm to replace a “MariaDB”, “OSM MariaDB”, “Percona Cluster” and “Mysql Innodb Cluster” operators.
Read more about legacy charms here.

Project and community

Charmed MySQL is an official distribution of MySQL. It’s an open-source project that welcomes community contributions, suggestions, fixes and constructive feedback.

In this documentation
Tutorials
Get started - a hands-on introduction to using Charmed MySQL operator for new users
How-to guides
Step-by-step guides covering key operations and common tasks
Reference
Technical information - specifications, APIs, architecture		 Explanation
Concepts - discussion and clarification of key topics

Navigation

Navigation
Level Path Navlink
1 tutorial Tutorial
2 t-overview Overview
2 t-set-up 1. Set up the environment
2 t-deploy 2. Deploy MySQL
2 t-scale 3. Scale replicas
2 t-manage-passwords 4. Manage passwords
2 t-integrate 5. Integrate applications
2 t-enable-tls 6. Enable TLS encryption
2 t-clean-up 7. Clean up the environment
1 how-to How To
2 h-setup Deploy
3 h-deploy-lxd LXD
3 h-deploy-maas MAAS
3 h-deploy-ec2 AWS EC2
3 h-deploy-gce GCE
3 h-deploy-azure Azure
3 h-deploy-multi-az Multi-AZ
3 h-deploy-terraform Terraform
3 h-deploy-airgapped Air-gapped
2 h-integrate Integrate with another application
2 h-external-access External access
2 h-scale Scale replicas
2 h-enable-tls Enable TLS
2 h-backups Back up and restore
3 h-configure-s3-aws Configure S3 AWS
3 h-configure-s3-radosgw Configure S3 RadosGW
3 h-create-backup Create a backup
3 h-restore-backup Restore a backup
3 h-migrate-cluster Migrate a cluster
2 h-monitoring Monitoring (COS)
3 h-enable-monitoring Enable monitoring
3 h-enable-alert-rules Enable alert rules
4 r-alert-rules Alert rules
3 h-enable-tracing Enable tracing
2 h-upgrade Upgrade
3 h-upgrade-intro Overview
3 h-upgrade-juju Upgrade Juju
3 h-upgrade-major Perform a major upgrade
3 h-rollback-major Perform a major rollback
3 h-upgrade-minor Perform a minor upgrade
3 h-rollback-minor Perform a minor rollback
2 h-development Development
3 h-development-integrate Integrate a database with your charm
3 h-migrate-mysqldump Migrate data via mysqldump
3 h-migrate-mydumper Migrate data via mydumper
3 h-migrate-backup-restore Migrate data via backup/restore
3 h-troubleshooting Troubleshooting
2 h-async Cross-regional async replication
3 h-async-deployment Deploy
3 h-async-clients Clients
3 h-async-failover Switchover / Failover
3 h-async-recovery Recovery
3 h-async-removal Removal
2 h-contribute Contribute
1 reference Reference
2 r-releases Release Notes
3 r-revision-274-275 Revision 274/275
3 r-revision-240 Revision 240
3 r-revision-196 Revision 196
3 r-revision-151 Revision 151
2 r-system-requirements System requirements
2 r-testing Testing
2 r-profiles Profiles
2 r-plugins-extensions Plugins/extensions
2 r-alert-rules Alert rules
2 r-contacts Contacts
1 explanation Explanation
2 e-architecture Architecture
2 e-interfaces-endpoints Interfaces and endpoints
2 e-statuses Statuses
2 e-users Users
2 e-logs Logs
3 e-audit-logs Audit Logs
2 e-juju Juju
2 e-legacy-charm Legacy charm
1 search Search