Scaleway Elements Database
What is Scaleway Elements Database?
The Scaleway Elements Database service allows you to create managed database instances, enabling you to focus on development, configuration or fine-tuning of the database engine, rather than administration.
Which services does Scaleway Elements Database manage for me?
Scaleway Elements Database manages:
- User permissions
- Backup and restoration of databases
- Automated backup
- Event logs
- Database management
- Cloning
- Node Scale-up
- High-Availability of clusters
- Custom configurations
Which relational database engines are supported by Scaleway Elements Database?
Scaleway Elements Database currently supports PostgreSQL 9.6, 10, and 11.
Support for MySQL will be available soon.
How can I access my database once it is provisioned?
On the details page of your instance, the IP address and your instance’s port are shown.
It is possible to connect to your instance from any application using this IP address and the login/password of any valid database user. This can be managed from the “users” tab.
Can I upgrade my database engine version?
You can upgrade your database engine version to the next minor release from the management console. A major version upgrade requires your instance’s migration. During the failover to the new version, a short downtime of the instance occurs.
Do I have access to my instance during the upgrade process?
Your instance will not be available during the upgrade to a new version.
Are automatic backups enabled or disabled by default?
Automatic backups are enabled by default. It is possible to disable them at any time in the backup settings of your instance:
How do I list my instances?
You can view a list of your Scaleway Elements Database Instances in the management console. Alternatively, you can use the API to retrieve a list of them.
How do I access my instance?
To access your Database instance, use the psql command-line tool with the following command:
psql -h $IP -p $PORT -U $YOUR_USER -d $DATABASE_NAME
You will have to enter your password to establish the connection. The default $DATABASE_NAME to be used is rdb.
How many Database Instances can I have?
You can have as many Database Instances as your quota allows. Quotas can be increased by contacting the assistance via support ticket.
Will my instance be available while being in maintenance?
Your Database Instance can be partially unavailable during the maintenance window.
Which postgreSQL extensions are available?
The following pg_extensions are available for Scaleway Elements Database:
| Extension name | Comment |
|---|---|
| chkpass | data type for auto-encrypted passwords |
| pgrowlocks | show row-level locking information |
| sslinfo | information about SSL certificates |
| citext | data type for case-insensitive character strings |
| tablefunc | functions that manipulate whole tables, including crosstab |
| uuid-ossp | generate universally unique identifiers (UUIDs) |
| pg_buffercache | examine the shared buffer cache |
| intarray | functions, operators, and index support for 1-D arrays of integers |
| bloom | bloom access method - signature file based index |
| hstore | data type for storing sets of (key, value) pairs |
| isn | data types for international product numbering standards |
| dict_int | text search dictionary template for integers |
| tsm_system_rows | TABLESAMPLE method which accepts number of rows as a limit |
| btree_gin | support for indexing common datatypes in GIN |
| plpgsql | PL/pgSQL procedural language |
| tsm_system_time | TABLESAMPLE method which accepts time in milliseconds as a limit |
| unaccent | text search dictionary that removes accents |
| pgcrypto | cryptographic functions |
| intagg | integer aggregator and enumerator (obsolete) |
| pg_freespacemap | examine the free space map (FSM) |
| pgstattuple | show tuple-level statistics |
| pg_trgm | text similarity measurement and index searching based on trigrams |
| cube | data type for multidimensional cubes |
| dblink | connect to other PostgreSQL databases from within a database |
| fuzzystrmatch | determine similarities and distance between strings |
| earthdistance | calculate great-circle distances on the surface of the Earth |
| dict_xsyn | text search dictionary template for extended synonym processing |
| btree_gist | support for indexing common datatypes in GiST |
| pg_visibility | examine the visibility map (VM) and page-level visibility info |
| ltree | data type for hierarchical tree-like structures |
| pg_prewarm | prewarm relation data |
| postgis | PostGIS geometry, geography, and raster spatial types and functions |
| address_standardizer_data_us | Address Standardizer US dataset example |
| address_standardizer | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. |
| postgis_sfcgal | PostGIS SFCGAL functions |
| postgis_topology | PostGIS topology spatial types and functions |
| postgis_tiger_geocoder | PostGIS tiger geocoder and reverse geocoder |
What happens if a node is not in optimal condition?
If High-Availability (HA) is enabled, fail-over to a healthy node will be done automatically, and your unhealthy node will be auto-healed. If HA is disabled, your instance will be unavailable.
Is my instance available during backup?
Yes, your instance is available during backup. There will be a performance impact and some actions may not be available.
Can I upgrade my current plan?
You can upgrade your current plan from the management console by using the Scale up feature or via the API by upgrading your node_type.
Is there a limitation on the number of backups I can have?
You can have as many backups as your quota permits. In case you need to increase your quotas, contact our technical assistance by support ticket.
How am I billed for my Database Instances?
Billing of your Database Instance starts at the moment of its creation and ends at deletion of the resource.
Which relational database engines does Scaleway Elements Database support?
PostgreSQL 9.6, 10 and 11 are currently supported.
MySQL support will come at a later date.
What does Scaleway Elements Database manage on my behalf?
On your behalf, the Scaleway Elements Database Service manages the deployment on Compute ressources, OS, system updates, database engine updates and configuration. High-availability and backups are also managed by the service.
How do I backup my database?
If the automatic backup feature is enabled, new backups will be created according to your backup schedule, which can be set on the “instance overview” tab.
It is also possible to launch manual backups by clicking on the Create a backup button from the backups tab.
Is it possible to increase the storage capacity of an already provisioned Database Instance?
You can increase the storage capacity for your Database Instance by using the Scale up function from the management console. It allows you to migrate your database to a more powerful instance.
How do I import data into a Scaleway Elements Database?
To import data into your Scaleway Elements Database, export your data using the pg_dump command in a first step:
pg_dump -h OLD_DB_IP -p OLD_DB_PORT -U OLD_DB_USERNAME -F c -b -v -f "/usr/local/backup/database.backup" DATABASE_NAME
Once the data is exported, import the database using the pg_restore command:
pg_restore -h INSTANCE_IP -p INSTANCE_PORT -U USERNAME -d DATABASE_NAME -v "/usr/local/backup/database.backup"
The different parameters used in the commands represent the following values:
-h(--host): IP address of the host-p(--port): Port number of the host-U(--username): PostgreSQL user-F(--format): Formatc:cjust after a-Fmeans that the format is the binary format specific to postgreSQL-b(--blobs): Specifies the binary string type-v(--verbose)-f(--file): Specifies the file name