DBaaS Overview
Presentation
Exoscale DBaaS is a database as a service product with a set of data services that can be triggered on demand.
Features
It comes with:
- Managed data engine with high SLA
- Selection of plans with upscale and downscale possibilities as well as redundancy options
- Automatic backup policies
- Lifecycle management
Terminology
- DBaaS: database as a service.
- Service: a service is deployment of a DBaaS flavor.
- Plan: a plan is a combination of compute resources based on Exoscale Compute instances types and of data infrastructure features (replicas, backup frequency, …).
- Fork: a fork is the ability to create a new DBaaS service from an existing running service. It enables uses cases for upgrades, data protection, disaster recovery,… scenarios.
Architecture
Database services are launched on dedicated instances but not directly accessible to the end user or visible in your Compute instance list. The database services are therefore not shared and run on single to several machines specifically deployed for your organization depending on the plan.
Service availability
4 services are currently available. These services along with their short names are:
- Managed PostgreSQL:
pg
- Managed Apache Kafka:
kafka
- Managed Mysql:
mysql
- Managed OpenSearch:
os
- Exoscale for RedisĀ®:
redis
Geographical availability
The Exoscale DBaaS product described in the following guide is available in all current Exoscale zones.
Service level agreement
All plans come with SLA regarding the availability of the data service:
- all Hobbyist and Startup plans: 99.95%
- Business and upwards: 99.99%
Known limitations of DBaaS
A number of features are currently unavailable in DBaaS and need to be taken into account while working with it.
CLI/API support and partial portal support
Interaction with DBaaS currently happens with the exo CLI utility and API for the full set of features. The Web Portal provides a partial coverage of the API and CLI possibilities and will progressively catch up with these for Q2 2022.
Service integration
Integrating services with one another is not currently possible.
Multi-zone setup and geo-replication
All services that support replication from their protocol can be deployed with Geo-Redundancy from the CLI only with the integration capabilities. Read more about this feature in the specifics of each service.
Forks are however possible across zones, enabling to start a copy of a service from one zone in another location.
OpenSearch delayed CLI support
The OpenSearch management is available via the Web Portal only while the CLI is being updated. Full CLI support planned before end of Q1 2022.
Data migration
Migrating from an existing non-Exoscale DBaaS is possible only from the Web portal and applicable to SQL based services only.
General information about Exoscale DBaaS plans
The plan naming convention indicates the resources of each single or cluster of instances powering your service:
- Service type: pg, kafka, redis,...
- Plan: hobbyist-1, business-32, premium-9x-16
Where:
Hobbyist, startup, business, premium keywords differentiate for each service the redundancy and data protection mechanism used. Refer to the product pages to list the available plans and their specifications.
And the optional first digit indicates for distributed systems the number of nodes in the cluster.
Last 1, 2, 4,...32,...,225 indicates the memory associated with each node in the plan in GB. These are indexed on the existing compute instance types available at Exoscale, so a 32GB is a compute general purpose Huge instance.
For example an Apache Kafka service on a premium-9x-16 plan, is a Kafka cluster with 9 nodes each with 16 GB RAM. The other details regarding storage, backup, number of connections, versions and plugins are available in the tables or documentation to be published.
Restrictions and authorizations
Not all plans are available on-demand by default. Some of the plans
require an authorization like some of Exoscale other offerings
(large instance types, GPU enabled instance,…). You can list
the plans that are currently available to your workspace with the
command exo dbaas show <SERVICE TYPE> --plans