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.

Vultr Managed Databases Quickstart

Last Updated: Wed, Jun 8, 2022
Managed Databases Quickstart Guides

Introduction

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.

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.

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.

Getting Started: Deploy a Cluster

Navigate to Add Database in the customer portal and choose a database engine. MySQL is available now, and PostgreSQL and Redis are coming soon.

Choose the Database Configuration

In this section, you'll make several decisions about your database cluster. A database cluster consists of one primary node and zero or more replica nodes.

Server Type

Vultr offers several server types. Select from one of the following:

VPS Plan

The plan selector displays a summary of cost, vCPU, storage, and memory options. You should choose the performance level that best suits your expected requirements.

Number of Replica Nodes

For performance and redundancy, you can select one or more replica nodes. A replica node has a full copy of the primary node's data. Replica nodes automatically take over if the primary node fails. If you have more than one replica node, they hold an election to select the new primary.

Your replica nodes are the same server type and plan as the primary node.

Choose the Cluster Location

Vultr offers managed databases in every location. You should choose a location near your customers and application.

Choose a Label and Deploy

Enter a label for your database cluster and click Deploy Now. The cluster will be available in a few minutes.

Using the Cluster

You need the connection information from the Overview page to use the database cluster.

  1. Navigate to Managed Databases in the customer portal.
  2. Click the Manage icon to open the Overview tab.

    edit-database

  3. Use the Copy Connection String and Copy MySQL URL buttons to transfer the information to your clipboard. For example:

    Connection Details

You can use these connection details in web applications, programming languages, or GUI tools like MySQL Workbench, dbForge Studio, HeidiSQL, DataGrip, DBeaver, SQuirreL SQL, and more. Please consult your application's documentation to learn how to use the connection details.

Set Trusted Sources

When you deploy a database cluster, it's open to all internet traffic. You should set a list of allowed IP addresses in the Trusted Sources section. See the previous image, for example. After you set an IP address as trusted, all other IP traffic is blocked, similar to a firewall.

Setting the trusted sources is a good security practice before you create your databases and add users.

Queries and Logs

Use the Queries & Logs tab to monitor the running queries, database statistics, and recent log entries.

Logs

Users and Databases

On the Users & Databases tab, you can manage the cluster's users and passwords. You can also create and destroy databases in the cluster.

Users

Settings

Use the Settings tab to manage the cluster options. Use the Upgrade Window menu to set the preferred time for system upgrades.

Upgrade

Use the SQL Modes menu to set the mode for MySQL. See the MySQL documentation to learn more about SQL modes.

Modes

Choose the Delete Database menu to destroy your database.

Delete

More Resources

MySQL Documentation

Vultr Resources

Database FAQs

Want to contribute?

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