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.