ARCHIVED: Legacy MySQL for Webserve account details

This content has been archived, and is no longer maintained by Indiana University. Resources linked from this page may no longer be available or reliable.
Important:
On Webserve, the default version of PHP is 7.1; however, PHP 5.6 will still be available until it is retired at the end of December 2018. Webtest servers are already using PHP 7.1. For help specifying which version of PHP to use, see PHP server-side scripting language.
Note:
Refer to the host providing the MySQL service as mysql.iu.edu or mysql-test.iu.edu, regardless of the manner in which you connect to the host server, e.g., via ssh (Secure Shell), scp (Secure Copy), or sftp (Secure FTP), or from a web application.
  • Core database:
    • The core database is contained within the mysql directory, /ip/account/mysql/data/mysql. This directory should not be deleted or corrupted.
    • The process ID of the running MySQL server process is contained in account.pid.
  • Interactive login: You can log in to the server providing the MySQL service from an SSH (secure shell) client capable of using the SSH2 connection protocol.
  • File transfer using SFTP (Secure FTP), and scp (Secure Copy): You can transfer data and other files to and from the server providing the MySQL service using either scp (Secure Copy)-equipped Unix platforms or the SFTP (Secure FTP) component of the Windows-based SSH (Secure Shell) client.
  • Cron scheduled background processing: All MySQL service accounts are pre-enabled to use the cron scheduled background processing system. This enables you to run database checkpoint and backup processing at night (and sometimes during the day) without significantly impacting database or system performance because cron scheduled processing runs at a lower priority than your account's MySQL server.

    You are responsible for performing and maintaining your own database backups on mysql.iu.edu and mysql-test.iu.edu.

  • The master MySQL configuration/settings file: Your account login directory contains a symbolic link to the master configuration file for your account's MySQL server named .my.cnf, which has been customized for your account. The master configuration file is provided as a read-only file. For assistance in making changes in your master configuration file, contact Web Services Support.

  • Online MySQL reference manuals: For an online reference manual for the version of MySQL running on mysql.iu.edu, see MySQL 5.0 Reference Manual.

This is document bfoa in the Knowledge Base.
Last modified on 2018-08-28 07:40:15.

Contact us

For help or to comment, email the UITS Support Center.