« 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. One serves as the primary for READS and WRITES, and
the read-replica can be used for READ queries only. These endpoints are available only within the HPC networks and cannot be accessed
from elsewhere in the UVA WAN. You cannot use MySQL tools remotely (from University offices, labs, or home offices over VPN).
To use MySQL from the command-line, use the mysqlclient
module in Rivanna:
$ module load mysqlclient
Or use the appropriate library for the language you are coding in to establish a connected client.
You can now create a connection to the server. Use port 3306
(the default port):
$ mysql -h <mysql-endpoint-name> -u <your-username> -p
Password: ***********
|
data, databases, howto, mysql, rdbms, rivanna