MySQL overview

MySQL is a relational database management system (RDBMS) released under the GNU General Public License (GPL). It is one of the most widely used open-source database systems, and is compatible with a multitude of website applications. Other databases offered by DreamHost include SQLite and MongoDB (on DreamHost VPS and dedicated servers only), however they may not be supported by your desired website applications.

This article describes everything you need to know on how you can create, add, manage, access, restore, and much more for all of your DreamHost MySQL databases.

You can make changes to your MySQL databases on the (Panel > 'Goodies' > 'MySQL Databases').

All about DreamHost's MySQL offerings

As of September 2015, DreamPress and private MySQL servers are being upgraded to MySQL version 5.6.

Shared and Dedicated servers are scheduled to be upgraded in the future. If a newer version is required, please contact support to be provided with other options.

The most common storage engines are provided with all DreamHost managed MySQL products. Here is a list of the available storage engines:

mysql> show engines;
EngineSupportCommentTransactionsXASavepoints
CSV YES CSV storage engine NO NO NO
MRG_MYISAM YES Collection of identical MyISAM tables NO NO NO
FEDERATED NO Federated MySQL storage engine NULL NULL NULL
MyISAM DEFAULT Default engine as of MySQL 3.23 with great performance NO NO NO
InnoDB YES Supports transactions, row-level locking, and foreign keys YES YES YES
MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO


Customers familiar with running their own MySQL server and who wish to use a newer version, may be interested in the trying out DreamCompute which offers multiple newer operating systems to choose from which have newer versions of MySQL available for install.

Comparison of MySQL products

DreamHost shared and VPS products for MySQL run on specialized hardware to optimize disk i/o and therefore the speeds in which they return your query. These are networked products which run independent of the webserver hardware. Dedicated servers offer MySQL that is optimized for other use cases where the webserver and MySQL server co-existing makes more sense.

ProductDescriptionLocal/NetworkedSuitable For Hosting Needs
Shared MySQL Included with a shared hosting plan, and with a Webserver VPS. Networked Standard MySQL for optimized and shared hosting appropriate databases.
MySQL VPS An additional service similar to a webserver VPS that only runs the MySQL server and no other services. Networked High performance MySQL for customers who need higher uptime or have outgrown shared MySQL.
Dedicated MySQL A dedicated server runs a MySQL server locally along with the other web services. Local A dedicated server is ideal for software that sends larges amounts of data between web applications and MySQL, as there is no network in between to limit throughput.

See also