Description
This component is responsible for importing database backups, snapshoting them and running a MySQL service.
Settings
- Version - The version of MySQL to use.
- Backup - Which backup should be used. (A guide on how backups are used can be found here) You can also find out more about the types of backups below.
- Use same backup for development instances Production only** - If enabled this allows you to specify a different backup for development instances.
- Development backup Production only** - The backup that development instances should use.
-
Exclude table data from backups - When performing a sanitized backup you may also wish to exclude additional tables, either for security as they contain sensitive information, or just because they contain non useful data such as log tables. You can add as many as you want here.
N.B The tables will still be created within your instance, but they will contain no data - Enable schedule backups - If scheduled backups should be enabled.
- Backup schedule - If enabled what frequency they should be taken.
** Production only - these settings are only available for production sites hosted with MDOQ.
MySQL Versions
| Version | Status |
| MySQL 9.1.0 | Active |
| MySQL 9.0.1 | Deprecated |
| MySQL 8.4.3 | Active |
| MySQL 8.3.0 | Deprecated |
| MySQL 8.2.0 | Deprecated |
| MySQL 8.1.0 | Deprecated |
| MySQL 8.0.40 | Active |
| MySQL 5.7.44 | Deprecated |
| MySQL 5.6.51 | Deprecated |
| MySQL 5.5.63 | Deprecated |
Backup Types And Options
There 3 main types of backup:
- None - This will force MDOQ to build with an empty database (as though it was the first install).
- Sanitized - A backup of the production site, with sensitive data removed.
- Full - A full backup of the production site (including orders, customers, quotes etc..).
For development instances you have the option of creating with:
- Latest Sanitized - This will use the latest sanitized backup MDOQ has.
- Latest Full - This will use the latest full backup MDOQ has.
After a development instance has been created, you are able to select a specific backup to use if you wish.
In addition to the backup type, you also have the option to select a "(Built)" version.
When MDOQ imports a new backup (of any type) it takes a snapshot (A built version of the database). Recreating MySQL with a built version is much fast than importing from a database backup.
A built version is simply one that has already been snapshoted.
N.B If you select "latest (Built)" of any type MDOQ will not use any new backups until they have been built. See a guide on this here.
Synchronizing
This will recreate MySQL, using the configured backup type and option.
Synchronizing MySQL will not automatically synchronize the instances database with production.
Effectively it will put the latest database backup if configured to do so.