MySQL - Capabilities and Limitations
Discover the capabilities and limitations of Public Cloud Databases for MySQL
Last updated July 13, 2022
Objective
This page provides the technical capabilities and limitations of the Public Cloud Databases' MySQL offer.
We continuously improve our offers. You can follow and submit ideas to add to our roadmap at https://github.com/ovh/public-cloud-roadmap/projects/2.
Capabilities and limitations
Supported regions and multi-AZ
The Public Cloud Databases offer is available in the following regions:
BHS(Beauharnois, Canada)DE(Frankfurt, Germany)GRA(Gravelines, France)SBG(Strasbourg, France)UK(London, United Kingdom)WAW(Warsaw, Poland)
Entire database instances have to be in the same region. Multi-AZ is currently not supported.
MySQL versions
The Public Cloud Databases offer supports the following MySQL versions:
- MySQL 8.0
MySQL recommends always installing and using the latest stable version.
MySQL connectors
You can use any of the MySQL-recommended connectors and API to access your cluster.
Plans
Three plans are available:
- Essential
- Business
- Enterprise
Here is an overview of the various plans' capabilities:
| Plan | Number of nodes by default | Read replicas | MySQL License | Network |
|---|---|---|---|---|
| Essential | 1 | No | Community | Public only |
| Business | 2 | Planned | Community | Public & Private vRack |
| Enterprise | 3 | Planned | Community | Public & Private vRack |
Your choice of plan affects the number of nodes your cluster can run, the SLA, and a few other features such as private network, read replicas and backup retention.
Nodes and replicas
- Essential: the cluster can support at most one node.
- Business: the cluster is delivered with 2 nodes by default. Adding read replicas is planned.
- Enterprise: The cluster is delivered with 3 nodes by default. Adding read replicas is planned.
License type
Each cluster is provided with the MySQL Community (GPL) license.
If any, license cost is included inside the service plans. You can't bring your own licenses.
Hardware resources
Here are the node types you can choose from:
| Name | Disk (GB) | Cores | Memory (GB) |
|---|---|---|---|
| db1-7 | 160 | 2 | 7 |
| db1-15 | 320 | 4 | 15 |
| db1-30 | 640 | 8 | 30 |
| db1-60 | 1280 | 16 | 60 |
| db1-120 | 2560 | 32 | 120 |
Right now, all nodes of a given cluster should be of the same type and live in the same region.
Effective storage
The disk size listed above is the total disk size of the underlying machine. However, a small part of it goes towards the OS install.
We try hard to avoid "disk full" situations that could be harmful to cluster health. Therefore:
- When reaching 97% capacity, the customer will have his database instance moved in "DISK_FULL" state, and 'read-only" mode, meaning no more writes can be done.
- You then have the ability to upgrade to a higher service plan with more storage.
Features
Network
MySQL clusters are reachable through default port 3306.
Public networking can be used for all the offers.
Private networking (vRack) is available for Business and Enterprise.
When using private networking, some network ports get created in the private network of your choice. Thus, further operations on that network might suffer from some restrictions - e.g. you won't be able to delete the network if you didn't stop the Public Cloud Databases services first.
Ingress and Egress traffic are included in the service plans and unmetered.
Maximum simultaneous connections
The number of simultaneous connections in Public Cloud Databases for MySQL depends on the available total memory on the node. We allow 75 connections per each GB of usable memory. Usable memory is the total memory on the node minus operating system and management overhead, which is currently estimated at 350 MiB. The usable memory is rounded to nearest gigabyte.
So for example on a server with 7 GB memory, you will get 7 * 75 = 525 connections and with 15 GB memory you will get 14 * 75 = 1050 connections. Note that the MySQL max-connections setting is always set to one higher (e.g. 526 / 1051 in the example cases) because there is usually one system process that consumes one of the available connections.
Advanced parameters
We do not currently support MySQL advanced parameters.
Backups
Essential plan clusters are automatically backed up daily during their maintenance window. Backup retention is 2 days.
Business plan clusters are automatically backed up daily during their maintenance window. Backup retention is 14 days.
Enterprise plan clusters are automatically backed up daily during their maintenance window. Backup retention is 30 days.
Logs and metrics
Logs and metrics are available via the OVHcloud Public Cloud Control Panel. As of today, you can't export logs and metrics, nor plug them into a remote tool.
- Logs retention: 1000 lines of logs
- Metrics retention: 1 calendar month
Please note that if the database instance is deleted, logs and metrics are also automatically deleted.
Users and roles
Creation of users is allowed via the Control Panel and API with default admin roles and privileges.
We want your feedback!
We would love to help answer questions and appreciate any feedback you may have.
Are you on Discord? Connect to our channel at https://discord.gg/PwPqWUpN8G and interact directly with the team that builds our databases service!
Esta documentação foi-lhe útil?
Não hesite em propor-nos sugestões de melhoria para fazer evoluir este manual.
Imagens, conteúdo, estrutura... Não hesite em dizer-nos porquê para evoluirmos em conjunto!
Os seus pedidos de assistência não serão tratados através deste formulário. Para isso, utilize o formulário "Criar um ticket" .
Obrigado. A sua mensagem foi recebida com sucesso.