“Basic nodes” will work just fine in the majority of situations. Similarly, if your database takes a lot of disk space, “Storage-Optimized nodes” may interest you. “General Purpose nodes” give you dedicated CPUs, so if you know that your database is going to require a lot of CPU, it might make sense to choose this option. Under “Choose a database configuration” you have three “Machine Types” to choose from. As WordPress only works with MySQL, select it from the available options. All resources created in this datacenter will be members of the same VPC network, which means they can communicate securely over private IP addresses. This will ensure that latency between your web server and external database is kept to a minimum.Ĭhoosing the same datacenter as your web server allows the use of a VPC Network automatically. Make sure to choose the same datacenter where your web server instance is located. Your first step is to choose a datacenter region. This will open the “Create database cluster” page. Select Databases from the list of available products to create. To create a new DigitalOcean database, log into your DigitalOcean account and click the Create button at the top of the DigitalOcean dashboard.

Only Allow Connections From Your DigitalOcean InstanceĬreating a New DigitalOcean Managed MySQL Database.

Creating a New DigitalOcean Managed MySQL Database.

We also have a doc for setting up a managed database server on Amazon Lightsail. By the end of this tutorial, you will have the database hostname, port, username, password, and database name you need to configure the managed MySQL database as an external database in SpinupWP. This guide will help you set up a DigitalOcean managed MySQL database for use with new servers set up by SpinupWP. Setting Up a DigitalOcean Managed MySQL Database and Adding It to SpinupWP

Digital ocean mysql create user remote