Article

Table of Contents
Theme:
Was this article helpful?
Try Vultr Today with

$50 Free on Us!

Want to contribute?

You could earn up to $600 by adding new articles.

Frequently Asked Questions about Managed Databases

Last Updated: Tue, Jun 7, 2022
FAQ Managed Databases

Frequently Asked Questions

Vultr's managed databases automate many challenging aspects of database administration so that you can stay focused on your app. They are secure, redundant, and do not require manual installation or configuration. In addition, they offer automated failover to replica nodes, scheduled automatic updates, end-to-end security, and full logs.

Here are some of our most frequently asked questions.

Using Databases

How do I connect to my database?

You can reach your database over the public internet with the connection string shown on the Overview tab of the Database Details page in the Vultr customer portal.

Your connection string connects to the primary node and will automatically switch to the newly-elected primary node in case of a database failover.

Can I access the database from the public internet?

Yes, you will find your connection information in the Vultr customer portal.

How do I add users or databases to the cluster?

  1. Navigate to the Managed Databases section.
  2. Click your cluster to open the Overview tab.
  3. Choose the Users & Databases tab to manage your users and databases.

How do I delete a database cluster?

  1. Navigate to the Managed Databases section.
  2. Click your cluster to open the Overview tab.
  3. Choose the Settings tab to manage the cluster options.

Security

How do I create an admin (superuser) or root-level account?

Managed databases do not allow customers to create superuser accounts. All user management is done through the Vultr customer portal.

How do I restrict database access?

When first deployed, a database cluster is open to all. Use the Trusted Sources section of your managed database configuration screen to restrict access to your database cluster before creating your databases or users. You should also use a strong password for all user accounts.

Is the database secure?

Your data is encrypted at rest and in transit.

Do you offer backups?

Yes, managed databases are fully backed up. To restore a backup, please open a support ticket.

Configuration

What database properties can I configure?

Users cannot change MySQL database properties or use the root user for cluster stability. However, you can view the database properties with the SHOW VARIABLES; SQL query.

Notes about SQL Modes

  • The ANSI (Combination Mode) SQL mode includes the following SQL modes: REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, and ONLY_FULL_GROUP_BY.
  • Some modes can be toggled on individually, but if ANSI (Combination Mode) is enabled, that setting will take precedence.
    • For example, if you want to disable ONLY_FULL_GROUP_BY, you will also need to disable ANSI (Combination Mode), because it is a part of that mode bundle.
  • According to the MySQL documentation, TRADITIONAL (Combination Mode) includes the following SQL modes: STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION.
  • We do not support the NO_BACKSLASH_ESCAPES or PAD_CHAR_TO_FULL_LENGTH SQL modes at this time.

Do I need to use primary keys for my tables?

Yes, you must use primary keys for all database tables, which is enforced through the database configuration.

General Information

What are managed databases?

Vultr's managed databases automate many challenging aspects of database administration so that you can stay focused on your app. They are secure, redundant, and do not require installation or configuration.

What is a database cluster?

A database cluster consists of a primary node and, optionally, one or more replica nodes.

  • A primary node handles all Create, Read, Update, and Delete (CRUD) operations and acts as the single data source for all other nodes.
  • A replica node is a copy of the primary node. Replica nodes automatically take over if the primary node fails.

What databases are available?

Vultr uses the most popular database engines:

  • MySQL: Available now. The world's most popular open-source relational database has been in development since 1995 and continues to have an active community of developers.
  • PostgreSQL: Coming soon. This open-source object-relational database system has more than 30 years of active development and a reputation for reliability, feature robustness, and performance.
  • Redis: Coming soon. This open-source in-memory data structure store is a popular database, cache, and message broker. In addition, it has support for rich data types, atomic operations, and Lua scripting.

What managed database plans are available?

Vultr offers several server types:

We have plans ranging from 1 to 96 vCPUs, and between 1 and 256 GB of RAM. Not all plan sizes are available for every server type.

What MySQL storage engines are available?

MySQL databases use the InnoDB storage engine. We do not support other storage engines.

What versions of MySQL are available?

We use the latest version of MySQL and keep your server updated.

Where can I deploy a database cluster?

You can deploy a managed database cluster at any of Vultr's locations. All nodes in the cluster are deployed in the same location.

How do I upgrade my database?

Your upgrades are managed automatically. You can schedule the automatic upgrades in the Settings tab of the customer portal or trigger an upgrade manually.

How long does it take to deploy a database?

Managed database clusters are self-service, and you can provision a new database cluster in just a few minutes through the customer portal.

Can I use a mixture of node types?

No, all nodes in your cluster are the same type.

Can I add a replica node to an existing cluster?

This is not available during the beta. This feature will be available in the public release.

Can I deploy managed databases with the Vultr API or vultr-cli?

Support for Vultr API and vultr-cli is coming soon. Today, you can deploy managed databases from the Vultr customer portal.

Administration

How do I move a database cluster to a new location?

Migrating a cluster to a new location is not supported during the beta, but it's a planned feature for the final release. If you have questions about migration, please contact our support team.

How do I scale my database cluster up or down?

Scaling, either horizontally by adding or removing nodes or vertically by selecting a different server type, is not supported. Instead, you must migrate to a new cluster. Migrating a cluster is not supported during the beta, but it's a planned feature for the final release. If you have questions about migration, please contact our support team.

How do I migrate a database cluster?

You may need to migrate a cluster to:

  • Add or remove replica nodes
  • Scale the number of replica nodes up or down
  • Change the nodes to a new plan with higher or lower performance
  • Move a cluster to a new location

Migrating a cluster is not supported during the beta, but it's a planned feature for the final release. If you have questions about migration, please contact our support team.

Can I set the SQL Mode for MySQL?

Yes. MySQL can operate in different SQL modes. You can apply these modes in the database server's Settings tab through the customer portal. See the MySQL documentation to learn more about SQL modes.

Performance

Do applications experience any downtime during node failover or updates?

During updates and node failover, your application may experience brief outages of up to 15 seconds, which will cause your applications to disconnect from your database nodes. You should configure your client applications for a reasonable number of reconnection attempts before timing out to maintain availability.

How many connections will my database support?

The number of database connections allowed depends on the amount of memory allocated to your database. This information is not available during the beta. We will publish a table with details after the public release.

Can I defer updating the database to the latest version?

You can select the update window, but you cannot defer an update from happening.

Billing

How is database bandwidth charged?

Data transfer through the public internet counts against a monthly bandwidth quota.

Does Vultr have a Service Level Agreement (SLA) for managed databases?

Vultr backs managed databases with a 100% uptime guarantee. In addition, Vultr continuously monitors your database clusters. If you deploy replica nodes, they will automatically failover by electing a new primary if the primary node becomes unavailable.

Where can I find more information?

Vultr managed databases are popular open-source databases. You can find more answers to frequently asked questions on these websites:

Want to contribute?

You could earn up to $600 by adding new articles.