MariaDB



MariaDB is one of the most popular community-developed relational database management systems published under the GNU GPL. MariaDB born as a MySQL fork from former developers after Oracle acquisition.

Readings

 * 1)  MariaDB

Activities

 * 1) Perform the following tasks:
 * 2) * Install MariaDB. For example in MacOS:
 * 3) * Start and configure MariaDB.
 * 4) * Backup and restore a database
 * 5) * Create a simple database schema
 * 6) * Perform simple SQL queries against a database
 * 7) * Create a basic table

Install and start MariaDB in MacOS

 * Start MariaDB:
 * (command is mysql but you are actually starting MariaDB)
 * (command is mysql but you are actually starting MariaDB)

Starting MariaDB .180619 10:15:19 mysqld_safe Logging to '/usr/local/var/mysql/file.err'. 180619 10:15:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql SUCCESS! SUCCESS! MariaDB running (80662)
 * Check MariaDB is running:

Create a table: CREATE TABLE

 * Connect to database test, will be created in default MariaDB installation:


 * Create a basic table with two columns using the   SQL statement:

MariaDB [test]> describe my_first_table; +--+ +--+ +--+ MariaDB [test]> describe my_first_table; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+ 2 rows in set (0.003 sec)
 * Show tables so we can check our new created table is available:
 * Tables_in_test  |
 * my_first_table  |
 * Show details about your new table:
 * Field           | Type    | Null | Key | Default | Extra |
 * my_first_column | char(1) | YES  |     | NULL    |       |
 * my_second_column | char(1) | YES |     | NULL    |       |


 * 1) Show privileges:
 * 2) Allow remote root access:

Advanced Features

 * Understand MariaDB partitioning (w:https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Partitioning) and uses cases .   to see if your version support it.
 * Create a MariaDB Cluster using MariaDB /Galera Cluster/.