Skip to content Skip to navigation

MySQL Database Hosting

 

IT Services upgraded the MySQL Database Hosting service (also known as mysql-user) on Saturday March 22, 2014. For more information, please see the email sent to the MySQL Partners mailing list. Please direct questions or problems to helpsu.stanford.edu.

 

The MySQL Database Hosting service provides accounts and storage space to Stanford departments and official university groups 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 and heavily-used databases, for which a system such as Oracle or a dedicated MySQL server would be more appropriate.

The MySQL servers run on the Linux version 2.6 operating system and have MySQL version 5.1 installed.

Features

  • IT Services is responsible for system upgrades, security patches to the operating system, and the MySQL software.
  • Up to four daily backups are stored under a private directory for your group. You can use the MySQL console or MySQL client commands to make more snapshots of your database. The access information will be mailed to you once you are registered.
  • Supports stunnel 4 connections for access to MySQL.

Getting started

To register for the MySQL service for your group, department, or service web site, please review and agree to the MySQL Service Agreement.

When you have agreed to the terms and conditions, you will be directed to a database setup page. Upon completion of that page, the system will issue you a MySQL user name and initial password.

You can use mysql commands or the MySQL console (MySQL account required) to manage your existing databases. Extensive documentation is available from the MySQL console.

Note: The user name and password are encrypted during the 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 clear text unless you use stunnel (SSL tunneling connection), Stunnel adds data encryption when data is transferred between the server and the client.

Learn more

Last modified March 24, 2014