Overview
The MySQL GridContainers are designed for customers who demand guaranteed performance and absolute reliability for their hosted database systems. For more general details on our MySQL GridContainers, please see our Grid Features page.
Below is a table that lists disk space, RAM size, MySQL user limits, and MySQL connection limits for each type of MySQL pool/container offered by Media Temple.
| Disk space | RAM | *Users | Connections | |
| SmartPool v.2 | 4GB | Variable Shared | 2X Allowed Service DBs | Shared |
| Lite | 4GB | 512MBs | 2X Allowed Service DBs | 60 ** |
| Pro | 6GB | 1GB | 2X Allowed Service DBs | 100 ** |
| Advanced | 8GB | 2GB | 2X Allowed Service DBs | 150 ** |
* Available database users are always twice the number of databases allowed on a service. The number of available databases varies per plan, see your Grid plan details for specific numbers.
** Numbers listed for containers are the total allowed connections. For DB containers, these connection limits are the default assigned. You may change these values in the my.conf file within your Account Center. Increasing these numbers may cause adverse performance issues, so edit with caution.
Advanced Features of the Grid MySQL GridContainers
Accessing your Grid Container
- Log into your Account Center.
- Click on the blue Admin button associated to your Grid Server.
- In the Database box, click on Grid Containers.
- Click on Manage.
- Great! You should now be in your GridContainer and can utilize its features.
Adding additional MySQL users
- While in your GridContainer, click Users & Settings.
- Click Add User.
- Enter a username and password. Be sure to use a strong password.
- Once you have met all the password requirements, which will turn green, the Create Database User button will light up.
Changing permissions on a MySQL user
- While in Users & Settings, click on the Permissions button for the user which you want to edit permissions. Permissions can be set on a per database basis:
- No Access
- Read Only
- Read/Write
- When finished, click on the Save button.
Changing the MySQL container size
While in your Grid Container, click on the Upgrade/Downgrade button to increase or decrease allowed memory to your MySQL Container.
Rebooting the MySQL Container
Clicking on the Reboot Container button will cause the MySQL Container to shut down and reboot. This can be helpful if your GridContainer is frozen or locked up.
Repairing database tables
Clicking on the Repair Tables button will repair all tables in all of your databases with just on click.
Query Analyzer
This is a two-step process: First, click on the Analyze Slow Queries button -- a progress bar will display, when the report is completed the page will refresh.
After the Analyze Query Report is complete, you will see your report. You also can print or download your Analyze Query Report.
Custom my.cnf
Accessing the mysql config will allow you edit a custom my.cnf file for your server. This feature however should only be utilized if you are very comfortable making root level edits to your server. To start, click Edit Config.
Input your custom changes in the text box. Then click Save Config.
Comments