Getting started with your MySQL GridContainer


Browse by products and services

  • 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 (mt) Media Temple.

  Disk space RAM Users Connections
SmartPool v.2 4GB 64 MBs 5 30
Lite 4GB 128 MBs 10 60 *
Pro 6GB 256 MBs 20 100 *
Advanced 8GB 512 MBs 50 150 *

* Note: 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.
    705_ac_managedatabase
  4. Click Users & Settings
    705_usersettings_button
  5. Click Add User705_add_db_user
  6. Enter a username and password. Be sure to use a strong password.705_create_db_username
  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.
    705_ac_managedatabase
  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.

705_db_user_permissions

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.
    705_ac_gridcontainers
  4. Clicking on the Upgrade/Downgrade button allows to increase or decrease allowed memory to your MySQL Container.

705_dc_upgrade_downgrade

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.

705_dc_reboot

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.

705_dc_repair

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.
    705_dc_analyze1
  5. After the Analyze Query Report is complete, you will see your report. You also can print or download your Analyze Query Report.
705_dc_analyze2

Resources