This site requires JavaScript to be enabled
Welcome|
Recent searches
IE BUMPER

MySQL

ITS offers standards-based, professionally managed MySQL database systems including hardware, software, and system administration for University of Texas customers. 

  • MySQL

    MySQL is an open source relational database management system (RDBMS). It is commonly used for database services for other open source applications, such as Drupal and Wordpress. This service provides three database environments to support the full application development life cycle. The included environments are Development, Quality Assurance (QA), and Production. This service includes database/system administration, database backups and recovery, and monitoring.  

     

    Submit one of the following forms to open a ticket to the ITS Database Team. Access to these forms is limited to the campus network and campus VPN.

     

    Available to:Faculty and Staff
    Features
    • 10 gigabytes of storage space on the central MySQL database servers
    • Daily backups with a 14 day retention period (Prod) or minimum seven day retention period (Dev/Qual)
    • Ability to safely store Confidential Data in databases
    • Access to the ITS Database team for advice and troubleshooting
    • Access to commercial MySQL support via the ITS Database team
    • MySQL 8

     

    MySQL is offered as a “Fully Managed” database service. In the Fully Managed ITS MySQL shared infrastructure, ITS owns, manages, and supports the hardware and software resources in support of the centrally funded shared MySQL environment. This database service is recommended for departments, colleges, or other groups that require MySQL service. ITS provides the hardware, software, and staff resources to manage the central MySQL infrastructure. It is also recommended for those who may be using Confidential Data in their databases.

    If you have a requirement to store Confidential Data or HIPAA data, there may be additional reviews imposed by the Information Security Office and University Compliance Services to make sure that all appropriate controls are in place.

    Cost

    ITS provides the MySQL shared database infrastructure to University staff and faculty as a centrally funded service. Additional databases, dedicated databases, and/or storage beyond the 10GB quota may incur additional costs. Please contact db-requests@its.utexas.edu for more information.

    Service Level Objectives

     Key Metrics

    • Availability: 99.5%
    • Routine work request acknowledgment response time: 1 business day
    • Review and response to pending open requests: 5 business days

    Overview

    This document summarizes some of the service level agreement items that are specific for the MySQL database service. Please refer to our general ITS Database SLA for detailed information.

    Service description

    MySQL is an open source relational database management system (RDBMS). It is commonly used for database services for other open source applications, such as Drupal and Wordpress.

    Intended users

    MySQL can be used by faculty, staff, and students sponsored by a faculty or staff member.

    Supported computing environment

    In order to manage database(s), customers must either be connected with a Campus IP address or use the Campus VPN. Client access is available through phpMyAdmin. Other client software can be downloaded from sources such as http://www.mysql.com, assuming the operating system meets the minimum installation requirements.

    Technical support

    Both Tier 1 and Tier 2 technical support is available during normal business hours. Routine requests are typically addressed within one business day.

    Tier 1

    Any user can call the ITS Service Desk at 512-475-9400. External users should send an email message to the ITS Service Desk at help@its.utexas.edu, which will create a support ticket. Routine requests are typically addressed within one business day. Users with a departmental Technical Support Contact (TSC) should contact that individual. The Service Desk may escalate issues to Tier 2 staff.

    Tier 2

    Any user can call the ITS Service Desk at 512-475-9400. Internal users may send an email message to db-requests@its.utexas.edu or submit a General Request on the ServiceNow MySQL service page for service requests that do not require immediate attention to reach Tier 2 support directly.

    Maintenance

    ITS will notify customers about unscheduled maintenance and about service availability or service delivery issues using the Alerts and Outages page.

    Services may not be available during scheduled or unscheduled maintenance periods.

    Scheduled maintenance

    Routine scheduled maintenance occurs each month on the following schedule:

    • ITS MySQL Dev: Second Wednesday 6:30AM-7:00AM
    • ITS MySQL Qual: Third Wednesday 6:30AM-7:00AM
    • ITS MySQL Prod: Fourth Wednesday 6:30AM-7:00AM

    Additional scheduled maintenances may occur throughout the year. Customers will be notified of these additional maintenances at least one week in advance.

    To the maximum extent possible, installation of service, application, and security updates will be performed during scheduled maintenance.

    Unscheduled maintenance

    Unscheduled maintenance tasks that require service downtime will be announced as soon as possible on the Alerts and Outages page.

    Incident notification

    ITS will notify customers using the Alerts and Outages page of service availability and service delivery issues for MySQL.

    Backups

    Daily backups are created and have a 14 day retention period for Prod and a minimum seven day retention period for Dev/Qual.

    User responsibilities

    Customers (users) of the service and identified owners/administrators agree to be aware of and adhere to the university's Acceptable Use Policy. Please refer to the ITS Database SLA for full details. Please also review the Policies tab for this service.

    MySQL customers agree to:

    • Regularly check email for service announcements.
    • Provide and maintain contact information for primary and secondary departmental TSCs along with other contact information as defined in the ITS Database SLA.
    • Patch desktops as recommended by the vendor.
    • Use supported client software.
    • Provide critical information within four hours of receiving a request from ITS seeking to resolve a customer issue.

    Departmental IT support staff agrees to:

    • Maintain knowledge of the currently installed version of MySQL and its features.
    • Regularly check email for service announcements.
    • Provide and maintain contact information with ITS for support purposes as defined in the ITS Database SLA.
    • Assign and provide ITS with contact information for a secondary TSC that will assume all responsibilities of the primary TSC when the primary TSC is unavailable.
    • Use supported client software.
    • For purposes of resolving customer issues, be willing and available to provide critical information to ITS in a timely manner when requested.
    • Provide Tier 1 support for the department.