Managed Applications: MySQL Database

Service Guide

Updated: October 19, 2017

Overview

Database Server Software 1.0 is a Managed Hosting product. The standard “Service” consists of the licensing, installation, configuration, administration, monitoring, maintenance and support for software components.

Customer chooses the Database type, edition, version and options at the time of purchase.

Licensing

Licensing of the Database Software can either be provided by CenturyLink or obtained by Customer.

If provided by CenturyLink, CenturyLink will, as part of the Service, obtain and maintain the required Software licenses under the Software Vendors Use Rights and License Agreement. All users of the Service are subject to the terms and conditions of the referenced license agreements.

If provided by Customer, Customer may obtain, and maintain throughout the Service Term, the required Software licenses. If Customer chooses to obtain the licenses, CenturyLink will install the Software as part of the Service provided Customer secures and grants the applicable accesses to CenturyLink to allow CenturyLink to perform the Service. Customer shall at all times comply with any and all end user license agreements related to the Software. Customer represents and warrants that a written license agreement exists with the License vendor that permits CenturyLink to perform activities described in the proceeding sections. Customer agrees to provide CenturyLink with evidence of licensing as requested prior to the deployment date and periodically as requested to update the status of the license. If Customer fails to provide the license agreement, CenturyLink may, at its option, delay the deployment date or terminate the Agreement.

Third Party Software Terms

If any third party software, including any corresponding documentation, is provided to Customer by CenturyLink in connection with the Service, Customer agrees to be bound by any additional licensing terms and conditions applicable to such third party software and that it will use such third party software strictly in accordance with such terms and conditions. CenturyLink makes no representations or warranties whatsoever with regard to such third party software.

Indemnification

Except as otherwise provided by mandatory applicable law without possibility of contractual waiver and notwithstanding anything in the Master Service Agreement or elsewhere, CenturyLink and its affiliated companies shall not be liable to Customer or indemnify Customer for any claims of infringement of patent, copyright or other intellectual property right related to third-party software components.

Service Level Agreement

The Service Level Agreement (SLA) associated with this Service Guide is the Managed Hosting Services SLA.

CenturyLink SLA applies to all vendor supported configurations. Any configuration or version identified as “unsupported” by vendor will be subject to reasonable effort support by CenturyLink and will not be subject to SLA Service Credits.

Security

CenturyLink utilizes CIS Level 1 security benchmarks and NIST for additional security standards when deploying Managed Database Services and will provide security policies for Managed Database Services to Customer upon request.

Monitoring

CenturyLink will enable application level monitoring for each environment as they are created within the product configuration.

CenturyLink will retain primary notification and resolution responsibilities for all automated environment alerts. A Customer technical contact will be engaged to perform primary resolution of incidents associated with a non-production level environment.

Maintenance and Support

Change Management:

All changes to the CenturyLink managed applications, systems, network and facilities are subject to CenturyLink’s change management process. This process is intended to confirm that work is reviewed for completeness (risk assessment, completed test procedure, metrics for measuring progress, back out procedure, etc.) and accuracy prior to scheduling and implementation.

Major and Minor Releases:

Major and Minor Releases require a new installation of the Software binaries, which is not included in this Service. CenturyLink suggests that Customer purchase a new managed server (via a Service Order) and migrate data (defined in a SOW) as a commercially reasonable practice.

Maintenance Windows:

All times listed under Scheduled Maintenance Windows are local times and subject to change. CenturyLink will use commercially reasonable efforts to perform routine maintenance only during the Saturday or Sunday defined maintenance windows. See Maintenance Windows page for details.

Support:

CenturyLink will provide support for the Service during installation, content migration, Customer validation, and 24x7 monitoring and management by the CenturyLink Service Center after installation.

Customer Contact:

Customer will designate and maintain a Customer Contact during the Service Term (including current contact information). “Customer Contact” means a technical point of contact available 24x7 with sufficient knowledge, authority and access to address configuration issues, event notifications, system or infrastructure modifications and authentication of applicable CenturyLink systems.

Supported Editions, Versions, Platforms and Operating Systems

See Managed Database Compatibility Matrix

Additional Licensing Terms

If Customer provided licensing, Customer represents and warrants that a written license agreement exists with Oracle MySQL that permits CenturyLink to perform activities described in the proceeding sections.

Supported Services

MyISAM: MySQL non-transactional storage engine

InnoDB: MySQL transactional storage engine

Access

Customers are given login access and access to Httpd directories but not root or sudo access.

Patch Releases

CenturyLink compiles, packages, certifies, approves and delivers Software patch versions for installation in a Customer environment. Customer must approve the installation by contacting CenturyLink support. Any Outages directly caused by Customer's failure to accept the implementation of a patch will not be subject to SLA Service Credits.

Additional Services

Database Replication:

Customer may increase database availability by purchasing CenturyLink optional Managed Replication Service; MySQL Replication or MySQL Read-Only Replication. The Managed Replication Service includes replication setup, enabling replication session monitoring, and managing failover and fail-back. The supported replication product is statement-based replication. Any other methods (including row-based) can be supported via a Statement of Work (SOW).

MySQL Enterprise Monitor:

Customers may elect to use a tool called MySQL Enterprise Monitor. This tool is a virtual DBA assistant that can help the customer manage more MySQL servers, tune those servers as well as fix problems that arise.

Tasks performed on behalf of the customer include:

Licensing:

  • Maintain licensing and Software maintenance with Oracle MySQL for CenturyLink provided licenses

Installation:

  • Prepare server for application service (OS specific parameters)
  • Install MySQL Server (including available options and features)
  • Harden MySQL Server to CIS Level 1 and CenturyLink standards
  • Install CenturyLink Monitoring
  • Perform quality assurance against MySQL Server installation/hardening

Configuration:

  • Create/Configure MySQL Server service accounts
  • Configure supported protocols (TCP/IP, Named pipes, TCP Port, IP Address and SSL Certificate allocation)
  • Configure Database Storage Engine
  • Configure Database Replication, if purchased
  • Configure CenturyLink Monitoring
  • Configure CenturyLink approved and provided Database Backups and Maintenance Jobs
  • Install and configure CenturyLink Disk/Tape Backups, if purchased

Administration:

  • Rebuild broken database Replication sets, if purchased
  • Perform Database Backups and Restores
  • MySQL Server Log Monitoring
  • Restart/stop/start services
  • Update managed servers with all recommended security patches, service packs and hot-fixes upon customer request

Maintenance and Support:

  • Coordinate patching with Customer during maintenance hours

Monitors

Monitor

Description

Frequency

MySQL Error Log The MySQL error log is polled for the words “ERROR” or “FAILED” will trap (case ignored) Instant
MySQL Process Check if the MySQL Server process is running 1 Minute
Remote Root Checks for root account available from anything other than local host 24 Hours
Root Password Checks for root password 24 Hours
Anonymous Checks for anonymous accounts 24 Hours
Key Buffer Used % Checks percentage of maximum amount of Key Buffer used since startup 1 Minute
Write hit Ratio of key writes to hard disk to key writes to RAM 1 Minute
Read hit Ratio of key reads from hard disk to key reads from RAM 1 Minute
% of Total Questions Percentage of Slow Queries of all statements 1 Minute
% of Max used Percentage of Max used connections to Max Connection Size 1 Minute
InnoDB Buffer Pool Size Configured size of InnoDB Buffer Pool size 1 Minute
InnoDB Buffer Pool Usage Buffer Pool used 1 Minute
InnoDB Buffer Pool % Used Percentage of Buffer Pool used 1 Minute

Definitions

See Definitions for Managed Database Services.