Listed below are database management systems available on the Helix Systems, with brief descriptions and links to more
information about how to use them.
A database management system is tool for creating, querying, updating, and administering databases. They are typically used in a client-server mode, with the client being either an interactive login session or a script API.
Users are welcome to create their own databases. In addition, the Helix staff maintains a central MySQL server for various applications the run on our systems. To inquire about the availability of this server, please contact us at firstname.lastname@example.org.
MySQL is a general-purpose RDBMS, and is widely used as a backend for many applications.
Version Env Module Path 5.0.95 none - Biowulf default n/a 5.1.69 none - Helix default n/a 5.1.72 mysql/5.1.72 /usr/local/apps/mysql/5.1.72/bin 5.5.34 mysql/5.5.34 /usr/local/apps/mysql/5.5.34/bin 5.6.14 mysql/5.6.14 /usr/local/apps/mysql/5.6.14/bin
Once a MySQL module has been loaded, the command local_mysql allows a MySQL instance to be started on a node. Here is an example of how to start a MySQL server on an interactive node, using the local /scratch disk as the root directory:
For more information about how to use local_mysql, type
SQLite is a file-based RDMBS. It is appropriate for simple and reliable database management by a few simultaneous users. It is not appropriate for highly-distributed access due to file-locking restrictions.
Version Env Module Path 3.3.6 none - Biowulf default n/a 3.6.20 none - Helix default n/a 3.7.5 sqlite/3.7.5 /usr/local/sqlite-3.7.5/bin
Strangely enough, sqlite can be called with the command