Database Privileges on the Grid

Overview

The Grid's database SmartPool is a shared hosting platform, but still is capable of running quite a bit of complex processes. However, since this is the case, certain database commands can not be run on the Grid due to their potentially damaging effects to other customers in the SmartPool.

What privileges are allowed on the Grid?

While the SmartPool is a shared environment and has some limitation, most commands are still operable on the Grid. Here is a list of common privileges that ARE allowed on the Grid:

ALTER

CREATE (limited - see below for details)

DELETE

DROP

INDEX

INSERT

SELECT

UPDATE

LOCK TABLES

CREATE TEMPORARY TABLES

Even with a MySQL GridContainer these are the only commands allowed on the Grid. All of these functions are available to be performed via phpMyAdmin as well as any database administration program that you may utilize to access your Grid databases.

What are the limitations due to operating on the shared hosting platform?

Here is a list of database commands/privileges that are currently excluded due to their potentially dangerous nature on shared hosting platforms. These commands/privileges may require root access which is unavailable on the Grid:

CREATE VIEW

CREATE FUNCTION

CREATE PROCEDURE

CREATE DATABASE

What are my options if I need these privileges?

If you absolutely need this level of access, the Grid may not be the option for you. However, our DV and DV Developer offerings allow these privileges. Our DV is a dedicated (non-shared) hosting option that offers extensive control over your hosting environment.