A Cloud experience with MariaDB Database

Professor: Iyad Koteich

On 2022-07-04, I present at class a LAB with AWS using two services:

1. EC2(Elastic Compute Cloud) Instances
2. RDS(Relational Database Service) - Database (MariaDB)

The purpose is to compare the configuration and utilization of MariaDB as an IAAS or PAAS.

MariaDB - IAAS(infrastructure-as-a-service)

1. Create an EC2 Instance with an ubuntu server
2. Instal MariaDB - apt install mariadb-server
3. Configure a Security group
4. Change bind-address to 0.0.0.0
5. Create a user and give access to him.

Create User:

1. CREATE USER 'admin'@'%' IDENTIFIED BY 'password';
2. GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;
3. FLUSH PRIVILEGES;

Change Bind Address: /etc/mysql/mariadb.conf.d/ and change bind-address

MariaDB - PAAS(platform-as-a-service)

• Create a RDS Instance item
• Configure a Security group

Relational Database: MariaDB is Relational Database and what is it?

1. relationship -> one-to-one [indicate]
2. relationship -> one-to-many [orders]
3. [son] relationship -> many-to-many [rent cars]

Data Definition Language.

• CREATE DATABASE trebasdb;
• ** USE trebasdb; **
• CREATE TABLE users( id int(4) AUTO_INCREMENT, name varchar(30) NOT NULL, email varchar(50), PRIMARY KEY (id) );

Data Manipulation Language.

• SELECT * FROM
• DELETE FROM
• INSERT INTO

Design patterns.