Overview
This article provides information about various MySQL server types and the log viewing options for each one.
Background
DreamHost MySQL users do not have access to MySQL server logs. However, depending on which type of MySQL server your databases are running on, it may be possible for support to retrieve them for you.
Checking MySQL server type
Visit the MySQL Databases page, which shows you a list of all of your hostnames and databases. At the top of the section, your database server name is listed.
- If the database server name starts with iad1, this means you're on a Shared MySQL server. For example, "iad1-mysql-e2-20a:rudie" MySQL Server.
-
If the database server name starts with sql and is followed by a number, this means you're using a private MySQL server. For example, "sql###:mysql" MySQL Server.
-
If the database server name starts with ds and is followed by a number, this means you're using a dedicated MySQL server. For example, "ds###:mysql" MySQL Server.
Log options per server
The following provides the available log options for each database server type.
Shared MySQL servers
-
Unfortunately, logs are not available on Shared MySQL servers. This means that even technical support would be unable to retrieve them for you.
Private MySQL servers
-
Logs on a private MySQL server are available only if you contact DreamHost support. Make sure to specify the database name and time frame you wish to retrieve logs from.
Dedicated Servers
-
On a Dedicated Server, the MySQL databases are on the same machine. This means you can retrieve them by logging into the server via SSH.
DreamCompute
-
DreamCompute is completely configured manually, so any configuration is completely up to you.