Step 1. Install MariaDB Server |
Follow installation instructions. |
Step 2. MariaDB Basics - Create/Select/Insert/Update data |
This primer should get you up and going with MariaDB in about 10 minutes. If you're new to relational databases, please read Introduction to Relational Databases. After completing these steps you will have the basics of getting information in and out of an existing MariaDB database.
Check out our Knowledge Base to learn more about Basic SQL Statements. |
Step 3. Getting started with MariaDB in the Cloud |
1. MariaDB on AWS Marketplace: We created pre-built MariaDB images on Amazon AWS. These images are a quick way to get a basic install of MariaDB up and running. 2. MariaDB on AWS RDS: MariaDB is one of the database options available when using Amazon's RDS service. 3. MariaDB on Azure: The MariaDB TX Cluster offering in Microsoft Azure deploys 3 data/Galera nodes and 2 MariaDB MaxScale nodes, all running CentOS 7. |
Step 4. Try NoSQL features with MariaDB |
Dynamic columns allow one to store different sets of columns for each row in a table. It works by storing a set of columns in a blob and having a small set of functions to manipulate it. 1. Create a table with a BLOB column.
2. Insert data with dynamic column using COLUMN_CREATE( ) function.
3. View table with COLUMN_JSON() function.
4. Get a list of attributes from dynamic columns.
5. Get a value from dynamic column with COLUMN_GET() function.
To learn more about features of dynamic column, follow our tutorials below. Dynamic Columns Tutorial – Part 1: Introduction Dynamic Columns Tutorial – Part 2: Searching and Updating |