Author: David FinsterLast Updated: Thu, Nov 17, 2022
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.
Primary nodes handles all Create, Read, Update, and Delete (CRUD) operations and is the single data source for all other nodes.
Replica nodes are copies of the primary node. Replica nodes automatically take over if the primary node fails.
Vultr uses the most popular database engines:
MySQL: 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: 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: 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.
To deploy a managed database cluster, navigate to Add Managed Database and follow these steps.
Choose a database engine — either MySQL, PostgreSQL or Redis.
Choose the type of server nodes for your cluster.
Optimized Cloud Compute - General Purpose or Storage Optimized
Cloud Compute High Performance - AMD or Intel
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.
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. You should choose a location near your customers and application for the best performance. Vultr offers managed databases in every location.
Enter a label for your database cluster and click Deploy Now. The cluster will be available in a few minutes.
After the cluster deploys, click the Manage icon to open the Overview tab.
Now that you've deployed the database, see the guide for your database engine.
For general quesitons, see Frequently Asked Questions about Managed Databases.
To learn how to migrate your data to Vultr, see our Managed Database Migration Guide.