Getting started with your MySQL GridContainer

• Applies to: Grid
  • Difficulty: Easy
  • Time Needed: 10
  • Tools Required: Account Center access

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

Adding additional MySQL users

1. Log into your Account Center.
2. Click on the Admin button for your Grid account or click on your primary domain.
3. In the Database box, click on Manage Databases.
   
4. Click Users & Settings
   
5. Click Add User
6. Enter a username and password. Be sure to use a strong password.
7. 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

1. Log into your Account Center.
2. Click on the Admin button for your Grid account or click on your primary domain.
3. In the Database box, click on Manage Databases.
   
4. 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
5. When finished, click on the Save button.

Changing the MySQL container size

1. Log into your Account Center.
2. Click on the Admin button for your Grid account or click on your primary domain.
3. In the Database box, click on Grid Containers.
   
4. Clicking on the Upgrade/Downgrade button allows to increase or decrease allowed memory to your MySQL Container.

Rebooting the MySQL Container

1. Log into your Account Center.
2. Click on the Admin button for your Grid account or click on your primary domain.
3. In the Database box, click on Grid Containers.
4. 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

1. Log into your Account Center.
2. Click on the Admin button for your Grid account or click on your primary domain.
3. In the Database box, click on Grid Containers.
4. Clicking on the Repair Tables button will repair all tables in all of your databases with just on click.

Query Analyzer

1. Log into your Account Center.
2. Click on the Admin button for your Grid account or click on your primary domain.
3. In the Database box, click on Grid Containers.
4. 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.
   
5. After the Analyze Query Report is complete, you will see your report. You also can print or download your Analyze Query Report.

Resources

• Grid Hosting FAQs: MySQL GridContainer
• Managing a MySQL database with phpMyAdmin
• my.cnf file
• MySQL system variables