About the New MySQL for Webserve service at IU

The New MySQL for Webserve service at Indiana University is designed to provide better MySQL support for Webserve users and eliminate the need for individual administration of MySQL database instances. IU group account owners can create MySQL accounts automatically and get nearly instant access to the new environment.

Whereas the Legacy MySQL for Webserve service creates an individual instance for each account holder, the new MySQL service has a single instance in which account holders have root-like credentials and functionality, with access to only the databases and resources they own. Account holders can create additional users, databases (called "schemas"), and tables; they can also grant some user permissions.

On this page:


Creating an account

For help creating a MySQL for Webserve account, see On Webserve, how do I create a New MySQL for Webserve account or reset a New MySQL for Webserve root user password?

Schemas

The term "schema" has replaced "database" in all MySQL documentation and IU documentation supporting the New MySQL for Webserve environment. Although the term "database" still works in all MySQL commands (e.g., CREATE database 'test'), the term is deprecated and may disappear from future MySQL revisions. UITS recommends adopting "schema" as quickly as possible.

New MySQL account naming conventions

In the new MySQL single-instance environment, every user's schemas and tables are contained within a single high-performance MySQL instance. MySQL environments do not allow any two schemas or users to share the same name, so users and schemas will have their names prepended with the group account name and an underscore (_), as follows:

  account_schema1

Because group account names are unique, this guarantees that content retains a unique identity within the environment. The procedures to create new objects will automatically prepend the group account name and underscore to the name.

Working with MySQL API procedures

The new MySQL single-instance environment relies on a new model, the stored procedure, which is a set of commands that automates many common MySQL tasks and ensures compliance with naming conventions. To call a procedure, you must initially be connected to your MySQL account using your preferred connection method.

Procedures are formatted in the following manner (replace procedureName with the name of the stored procedure you are invoking and include the required parameters inside the parentheses):

  CALL api.procedureName(parameter01, parameter02, ...)

For a list of available procedures, use the following command:

  CALL api.listProcedures();

To access the technical guide for a particular MySQL procedure, use the following command (replace procedureName with the name of the procedure):

  CALL api.help('procedureName');

For more, including examples and service maintenance information, use the following command:

  CALL api.help('me');

MySQL Workbench

UITS recommends using MySQL Workbench to connect to your MySQL for Webserve account. MySQL Workbench provides a graphical environment for creating and managing connections to MySQL database servers, and features a built-in SQL Editor for executing SQL queries on those database connections.

At IU, you have the following options for using MySQL Workbench:

  • The MySQL Workbench open source Community Edition is available free of charge (for Windows, OS X, and Linux) from Oracle's Download MySQL Workbench page.
  • IU students, faculty, and staff can use a virtualized version of MySQL Workbench on their personal workstations and mobile devices via IUanyWare.

For more, see At IU, how do I connect to the Webserve MySQL servers with MySQL Workbench?

Getting help

If you have questions about the New MySQL for Webserve service, or need help connecting to your account, contact Support Center Tier 2 - Web Services Support.

This is document aojg in the Knowledge Base.
Last modified on 2017-08-21 16:22:14.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.