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. DreamHost also offers SQLite on DreamHost VPS and Dedicated servers.
View the following article for instructions on how to add a MySQL database:
You can make changes to your MySQL databases on the (Panel > 'Goodies' > 'MySQL Databases').
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;
|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.
|Product||Description||Local/Networked||Suitable 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.|
MySQL limitations due to shared hosting
Not all privileges are available to manage your database due to the nature of shared hosting. View the following article for a list of available privileges.
How many databases can my account contain?
There is no limit to the amount of databases, but in general you will have for each site that requires a database.
- How do I restore my database in the panel?
- How do I manage my database?
- How do I connect to my database via SSH?
- How do I connect to my database with a temporary MySQL hostname?
- How do I connect to my database using a third-party program?
- How do I connect to my database using SQLyog?
- Troubleshooting your MySQL database
- Backing up database overview
- Finding your database login credentials
- phpMyAdmin overview
- How do I optimize my database?
- SSH overview