MySQL / MariaDB Backup
Compatibility
MySQL Compatibility
| Version | Support |
|---|---|
| MySQL 5.7 | ✔ |
| MySQL 8.0 | ✔ |
| MariaDB 10 | ✔ |
Supports all editions of MySQL and MariaDB. Including managed services like Amazon RDS, Azure Database for MySQL, and Google Cloud SQL as long as you have access to the database server.
Supported Backup Types
| Backup Type | Support |
|---|---|
| Full | ✔ |
All MySQL versions supports full backups only supporting the mysqldump utility.
I. Adding a Server
The first and foremost step involves adding a server. In the platform selection, select MySQL.
II. Setting up the Agent
The second step is to set up the agent on your server. Follow the linux agent installation guide to set up the agent on your Linux server.
Kindly make sure that the agent is running with sufficient privileges to access the MySQL server.
III. Setting up the connection
After the agent is installed and running, you need to set up the connection to your MySQL instance. PettiCloud requires you to specify the following details:
- Host: The hostname or IP address of your MySQL server.
- Port: The port number on which your MySQL server is running (default is
3306). - User: The username to connect to the MySQL server.
- Password: The password for the specified user.
Now click on authenticate to verify the connection. If the connection is successful, you will be navigated to the Create Backup Job page where you can create your first backup job.
IV. Creating a Backup Job
Once the connection is set up, you can create a backup job. The backup job allows you to specify the type of backup you want to perform, the frequency of the backup, and other options. You can choose to perform a full backup of your MySQL database. The backup job can also be exclusive to a single database or include all databases in the MySQL server. You can start the backup job after specifying the required jobs.
V. Viewing Snapshots
Once the backup job is created, you can view the snapshots of your MySQL databases in the dashboard. The snapshots will show the details of the backup, including the size, type, and status.
With this, your MySQL backup is set up and running. You can now manage your backups from the PettiCloud dashboard.
Known Limitations
Snapshot sizes greater than 1,048,576,000,000 bytes (~ 976 GiB) are not supported.