/tag/database

  • Redis - A Key/Value Store

    « Return to Databases redis is an in-memory, key/value store. Think of it as a dictionary with any number of keys, each of which has a value that can be set or retrieved. However, Redis goes beyond a simple key/value store as it is actually a data structures server, supporting different kinds of values. Some fundamental concepts: Can be used as a databse, cache, or message broker Supports multiple data types and structures Built-in replication Keys can be up to 512MB in size /userinfo/howtos/general/databases/ Getting Started Rivanna has access to an open Redis service in the HPC network:
  • 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.
  • Introduction to Databases

    There are two main families of databases: Relational and NoSQL. Relational databases store information in an orderly, column, row, and table schema. They “relate” the tables together to present different views of the data. NoSQL databases are much less structured. This means they can store different data alongside each other – which makes things both easier to store but harder to query across. There are additional types of databases, such as ledger, time-series and others. Those are beyond the scope of this introduction. Relational Databases (RDBMS) Most users have at least heard of relational databases such as:
  • 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.
  • Database Service Request

    here is a response Name * E-mail * User ID * Group Family Submit –