Learn about how your database service schedules and performs maintenance operations.
Managed Databases (also called Cloud Databases) allow you to focus on building and deploying cloud applications while OVHcloud takes care of the database infrastructure and maintenance.
Why maintenance operations?
Sometimes during a cluster lifecycle, some action may be required to keep it running smoothly. For example, a new patch version of some underlying OS package might get released to provide some fixes.
How are those operations carried out?
- At some point, the system finds out that a maintenance operation becomes necessary. For example, a new version of some package participating in the service installation may become available.
- It then exposes a new maintenance operation for your service, with a description showing what needs to be done, a status (
SCHEDULED,APPLYING,APPLIED), and a scheduled date. That date is computed using the "maintenance time" property of your service. - The operation is triggered when the scheduled date is reached.
What is the expected impact on the service?
The underlying VM often needs to be rebuilt, or the service needs to restart.
For single-node services, that means there is a short time when your service becomes unavailable.
For multi-node services, per-engine resiliency mechanisms ensure the service remains available when a node gets operated on. If the application handles such cases gracefully (for example, reconnects and retries properly on failure) then the impact should be minimal or even non-existent.
How can I monitor the planned maintenance?
You can monitor planned maintenance from the OVHcloud Control Panel by selecting your engine and then the Manage maintenance --> button in the Configuration panel.
Via the OVHcloud API
You can also use the OVHcloud API to get a list of maintenance operations for a service. Each engine has its own API endpoint similar to the one below for MySQL, which will be used throughout this guide.
GET /cloud/project/{serviceName}/database/mysql/{clusterId}/maintenance
To see the details of a maintenance operation, use:
GET /cloud/project/{serviceName}/database/mysql/{clusterId}/maintenance/{maintenanceId}
How can I control the scheduling?
You can change the Maintenance time for your service to a time that suits you. For example, if your application is less busy at night, you can target that timeframe. Be aware that this only affects future maintenance operation scheduling, it won't reschedule already existing operations.
You can also apply a specific operation early by clicking the more options ... button to the right of the maintenance operation and selecting Apply now.
Via the OVHcloud API
You can preemptively apply some operations using this API endpoint:
POST /cloud/project/{serviceName}/database/mysql/{clusterId}/maintenance/{maintenanceId}/apply
This might be a good idea if, for example, you are approaching a busy period and want to avoid disturbances during that time.
Go further
For more information and tutorials, please see our other Cloud Databases support guides or explore the guides for other OVHcloud products and services.
If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.