Professor: Iyad Koteich
On 2022-07-04, I present at class a LAB with AWS using two services:
- EC2(Elastic Compute Cloud) Instances
- 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)
- Create an EC2 Instance with an ubuntu server
- Instal MariaDB - apt install mariadb-server
- Configure a Security group
- Change bind-address to 0.0.0.0
- Create a user and give access to him.
Create User:
- CREATE USER 'admin'@'%' IDENTIFIED BY 'password';
- GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;
- 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?
- relationship -> one-to-one [indicate]
- relationship -> one-to-many [orders]
- [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.