/tag/databases
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 nodes can connect to external Redis databases hosted in Kubernetes or a public cloud (AWS, Azure, GCP, etc.
MySQL - A basic relational database
« Return to Databases
window.onscroll = function() {scrollFunction()}; function scrollFunction() { if (document.body.scrollTop 100 || document.documentElement.scrollTop 100) { document.getElementById(“scrollBtn”).style.display = “block”; } else { document.getElementById(“scrollBtn”).style.display = “none”; } }; function topFunction() { document.body.scrollTop = 0; document.documentElement.scrollTop = 0; }; 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.
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 Software on Ivy Linux VM
The following database software are available on the Ivy Linux Virtual Machines
MySQL Is the most popular open-source relational database, used in academia and industry worldwide. It has been in use for over 20 years and is backed by a large developer community. It is available in both free and proprietary versions.
MariaDB MariaDB is a community developed version of MySQL, and is highly compatible with MySQL and other relational databases. Existing databases can be easily migrated between MySQL and MariaDB, and vice versa.
PostgreSQL Unlike MariaDB and MySQL, PostgreSQL is an object relational database, and can be used in a manner similar to other relational databases.
