Follow

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

Accessing your Grid Container

  1. Log into your Account Center.
  2. Click on the blue Admin button associated to your Grid Server.
  3. In the Database box, click on Grid Containers.
    g-2.png
  4. Click on Manage.
    g-3.png
  5. Great! You should now be in your GridContainer and can utilize its features.

Adding additional MySQL users

  1. While in your GridContainer, click Users & Settings.
    705_usersettings_button
  2. Click Add User.
    705_add_db_user
  3. Enter a username and password. Be sure to use a strong password.705_create_db_username
  4. 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. 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
  2. When finished, click on the Save button.

705_db_user_permissions

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.

705_dc_upgrade_downgrade

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.

705_dc_reboot

Repairing database tables

Clicking on the Repair Tables button will repair all tables in all of your databases with just on click.

705_dc_repair

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.
705_dc_analyze1

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

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.
g-6.png

Input your custom changes in the text box. Then click Save Config.

g-7.png

Resources

Was this article helpful?
1 out of 1 found this helpful

Comments

Powered by Zendesk