/tag/mysql

  • MySQL - A basic relational database

    « Return to Databases MySQL is an open-source relational database management system. It supports standard SQL syntax and models. Some important concepts are: Tables Rows Keys Schemas Data types Selects Joins Indexes Other CRUD operations Getting Started After submitting a request for a MySQL database, a username and password be created for you, this information along with your endpoint name will be sent to you via our ticketing system. Store this information somewhere secure, and do not share this information with others. User: <your-db-username> Pass: <your-db-password> Host: <mysql-shared-endpoint-name> Port: 3306 The MySQL service is backed by a pair of servers in HA replication mode.
  • Database Service Request

    – A Relational Database Service is available for researchers who need such resources in Rivanna or microservice applications. Currently database services are limited to the MySQL RDBMS, and can only be accessed from within the HPC network. Note that you cannot connect directly to this database service from elsewhere on campus, VPN, etc. but only from Rivanna or other Research Computing systems. Upon approval of this request you will be given the following: The database host endpoint address A database username A database password Connections can then be made over port 3306 to the endpoint using normal MySQL tools and libraries.