The MySQL Database Hosting service provides accounts and storage space to Stanford departments and official university groups on campus to develop and maintain MySQL databases, applications, and services. The MySQL service is not currently available for individual use.
The MySQL service is a shared service and is intended for small- and medium-scale databases. It is not intended for large or heavily used databases, for which a system such as Oracle or a dedicated MySQL server would be more appropriate.
The MySQL service is only available to on-campus applications. Applications hosted off-campus must provide their own database service.
The MySQL servers run on Linux and have MySQL version 8.1.0 installed.
Features
- University IT is responsible for system upgrades and security patches to the operating system and the MySQL software.
- Up to four daily backups are stored under a private directory called db_private in AFS. You can use the MySQL console or MySQL client commands to export the contents of your database outside of the daily backups. The access information will be mailed to you once you are registered.
- Supports stunnel 4 connections for access to MySQL.
Designed for
Current faculty and staff; departments, groups, and services
Requirements
A full-service SUNet ID.
Data security
May not be used to store High Risk Data, as defined by the Information Security Office.
Rates
Free of charge
Get started
To register for the MySQL service for your group, department, or service website, please review and agree to the MySQL Service Agreement and request access via the MySQL Database Application. If your database will be used with a web.stanford.edu (AFS-based) website running Wordpress, Drupal or MediaWiki, please note that in the comments of the application to expedite processing. Note: Provisioning for new accounts may take up to one business day.
If you already use the legacy MySQL database hosting service, please note that the on-prem platform you currently use will be decommissioned on Oct.31, 2024.
- Although you will continue to have access to the on-prem platform until Oct. 31, 2024, you must migrate your existing database(s) to cloud MySQL database hosting before the platform is decommissioned.
- Accounts and databases will no longer be accessible on the legacy on-premise MySQL database hosting after Oct. 31, 2024.
- To access the cloud MySQL Database Hosting service via the new phpMyAdmin, you must request a new account from the new MySQL Database Application (even if you already have an account in the legacy MySQL database hosting service). Note: Provisioning for new accounts may take up to one business day.
Note: The username and password are encrypted during authentication, so you do not have to worry about the password being seen in clear text while it is transferred between a host and the MySQL server. However, the transfer of database data will be in the clear unless you use stunnel (an SSL tunneling connection). Stunnel adds data encryption when data is transferred between the server and the client.
Get help
- Administrative Systems maintains the MySQL servers 24 hours a day, seven days a week, except for scheduled outages. For assistance, submit a Help request.
- University IT does not support MySQL database-management-related questions. You are responsible for such things as database schema design, application debugging, and how to use MySQL.
