Databases - Managed Databases

Note

In addition to MySQL database clusters, you can now create PostgreSQL and MongoDB database clusters with Linode’s Managed Database service. For more details, see Choosing a Database Engine and Plan and Plans and Pricing.

Linode’s Managed Databases combine performance, reliability, and high availability into a fully managed database solution. Databases are used by most organizations to store their business and operational data, including customer information, financial details, application content, ecommerce transactions, and much more. Managing the database infrastructure to store and safeguard this data can put additional stress on the resources you have available. Managed Databases take care of managing this critical infrastructure for you, providing you with an easy to use DBaaS (database-as-a-service) solution built on top of Linode’s trusted and reliable platform.

• Automated deployment: When a database is deployed through Managed Databases, the infrastructure, software, and firewall, and high availability systems are configured automatically. This can save hours of time compared to manually setting up a database.

• Automatic updates: Updates to the underlying software of your database cluster are installed automatically using user-configurable maintenance windows. See Automatic Updates and Maintenance Windows.

• Access controls: Prevent unauthorized database access by only allowing connections from specific IP addresses (or ranges).

• Daily Backups: Automatic daily backups are provided at no additional cost and are retained for 7 days. This provides you with a recovery point for each day over the last 7 days.

Managed Databases can be configured with either 1 or 3 underlying machines, also called nodes. Using 3 nodes provides you with a highly available database cluster, complete with data redundancy and automatic failover. Your data is replicated across every other node in the cluster. If one goes down, any traffic is redirected to the other available nodes.

The following database management systems (DBMSs) are available (or coming soon) to Managed Databases:

• MySQL: An industry standard relational database management system that uses the SQL query language. Many popular applications (including WordPress) require MySQL or MySQL compatible databases.

• PostgreSQL: An object-relational database management system that can use either SQL or JSON queries. It’s generally more flexible and feature-rich than MySQL, though it’s not a drop-in replacement and applications need to have built-in support for it.

• MongoDB: A document-oriented database software that uses JSON files to store data. It is one of the most popular NoSQL databases and, as such, it is unstructured and very flexible.

  Note

  Managed MongoDB clusters are currently accessible over public IP addresses. To provide an additional layer of protection, support for private IP addresses will be available in the coming months.

See Choosing a Database Engine and Plan for more details on each of the available database engines.

• Any production application that utilizes a database, especially one with high-traffic or one that stores critical data.
• Medium to high traffic websites using WordPress, CraftCMS, Drupal, or other database-enabled application.
• E-commerce sites
• Organizations that don’t want to commit IT resources towards managing a database cluster.

See the Use Cases for Managed Databases guide to learn more about these use cases.

Managed Databases can be created and deployed across all regions.

Pricing starts at $15/mo for a 1 GB instance with a single node. Review the pricing page for additional plans and their associated costs. There may be some differences between each available database engine due to licensing costs and other factors.

Managed Databases do not consume network transfer or include a monthly transfer allowance. Transfer is consumed when connecting to a Managed Database from a Compute Instance when that instance is located in a different data center.

In addition to the resources allocated to each available plan (outlined above), Managed Databases have the following specifications:

• Fully-managed, including automated deployment and maintenance
• Multiple database engines and versions
• Customize access controls to allow connections from trusted sources
• Automatic backups are taken daily and retained for 7 days
• Administrative access with elevated user permissions
• Access the database using command-line or desktop applications
• 100% SSD (Solid State Disk) storage
• 40 Gbps inbound network bandwidth
• Free inbound network transfer
• Provisioning and management through the Cloud Manager, Linode CLI, or programmatically through the Linode API

• Managed Databases cannot be resized to a different plan or cluster size after they are created.

• The default user cannot be changed or removed, though the password can be reset at any time.

• You are not able to access the underlying operating system of a database cluster. Configuration files (such as my.cnf ) cannot be directly edited and configuration changes done through the SET PERSIST command do not persist when the cluster is rebooted.

• MongoDB database clusters are currently only accessible over public IP addresses. As such, any traffic counts towards your monthly network transfer usage. Support for private IP addresses will be available in the coming months.

• Live replicas or standby nodes for a high availability Managed Database cluster cannot be created or hosted outside of Linode’s Managed Database service.