role verfication

#### Role Verification /var/lib/mysql  ####

[ec2-user@ip-172-31-40-167 ~]$ ssh -i aws.pem 172.31.37.48
The authenticity of host '172.31.37.48 (172.31.37.48)' can't be established.
ED25519 key fingerprint is SHA256:Tl0gsBDONvn1tDzNd1WiLB6OjxsfqGlvDtbyOxgdZ2o.
This key is not known by any other names
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added '172.31.37.48' (ED25519) to the list of known hosts.
   ,     #_
   ~\_  ####_        Amazon Linux 2023
  ~~  \_#####\
  ~~     \###|
  ~~       \#/ ___   https://aws.amazon.com/linux/amazon-linux-2023
   ~~       V~' '->
    ~~~         /
      ~~._.   _/
         _/ _/
       _/m/'
Last login: Wed Jun 28 11:25:51 2023 from 172.31.40.167
[ec2-user@ip-172-31-37-48 ~]$
[ec2-user@ip-172-31-37-48 ~]$
[ec2-user@ip-172-31-37-48 ~]$ ls


[ec2-user@ip-172-31-37-48 ~]$ df -h
Filesystem      Size  Used Avail Use% Mounted on
devtmpfs        4.0M     0  4.0M   0% /dev
tmpfs           475M     0  475M   0% /dev/shm
tmpfs           190M  2.9M  188M   2% /run
/dev/xvda1      8.0G  2.5G  5.5G  32% /
tmpfs           475M     0  475M   0% /tmp
/dev/xvdb       7.8G  124M  7.3G   2% /var/lib/mysql
tmpfs            95M     0   95M   0% /run/user/1000
[ec2-user@ip-172-31-37-48 ~]$


#### Filesystem ext4 for /dev/xvdb ####

[ec2-user@ip-172-31-37-48 ~]$ lsblk -f
NAME      FSTYPE FSVER LABEL UUID                                 FSAVAIL FSUSE% MOUNTPOINTS
xvda
├─xvda1   xfs          /     0bfb954f-5412-4d5a-8d40-3a2596532c79    5.4G    32% /
├─xvda127
└─xvda128 vfat   FAT16       8EFE-43B9
xvdb      ext4   1.0         d7503892-7b30-41f3-996d-99573b6a015b    7.2G     2% /var/lib/mysql
[ec2-user@ip-172-31-37-48 ~]$


### fstab entry properly came ###
[ec2-user@ip-172-31-37-48 ~]$ cat /etc/fstab
#
UUID=0bfb954f-5412-4d5a-8d40-3a2596532c79     /           xfs    defaults,noatime  1   1
UUID=8EFE-43B9        /boot/efi       vfat    defaults,noatime,uid=0,gid=0,umask=0077,shortname=winnt,x-systemd.automount 0 2
/dev/xvdb /var/lib/mysql/ ext4 defaults 0 0


#### permission correct ####

[ec2-user@ip-172-31-37-48 ~]$ ll /var/lib/mysql/
total 122944
-rw-rw----. 1 mysql mysql     24576 Jun 28 11:19 aria_log.00000001
-rw-rw----. 1 mysql mysql        52 Jun 28 11:19 aria_log_control
drwx------. 2 mysql mysql      4096 Jun 28 11:19 blog_db
-rw-rw----. 1 mysql mysql       976 Jun 28 11:19 ib_buffer_pool
-rw-rw----. 1 mysql mysql  12582912 Jun 28 11:19 ibdata1
-rw-rw----. 1 mysql mysql 100663296 Jun 28 11:20 ib_logfile0
-rw-rw----. 1 mysql mysql  12582912 Jun 28 11:20 ibtmp1
drwx------. 2 mysql mysql     16384 Jun 28 11:19 lost+found
-rw-rw----. 1 mysql mysql         0 Jun 28 11:19 multi-master.info
drwx------. 2 mysql mysql      4096 Jun 28 11:19 mysql
srwxrwxrwx. 1 mysql mysql         0 Jun 28 11:20 mysql.sock
-rw-rw----. 1 mysql mysql        16 Jun 28 11:19 mysql_upgrade_info
drwx------. 2 mysql mysql      4096 Jun 28 11:19 performance_schema
[ec2-user@ip-172-31-37-48 ~]$
[ec2-user@ip-172-31-37-48 ~]$ sudo systemctl status mariadb
● mariadb.service - MariaDB 10.5 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
     Active: active (running) since Wed 2023-06-28 11:20:09 UTC; 19min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 1986 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 9 (limit: 1114)
     Memory: 85.3M
        CPU: 446ms
     CGroup: /system.slice/mariadb.service
             └─1986 /usr/libexec/mariadbd --basedir=/usr

Jun 28 11:20:08 ip-172-31-37-48.ap-south-1.compute.internal systemd[1]: Starting mariadb.service - MariaDB 10.5 databas>
Jun 28 11:20:08 ip-172-31-37-48.ap-south-1.compute.internal mariadb-prepare-db-dir[1939]: Database MariaDB is probably >
Jun 28 11:20:08 ip-172-31-37-48.ap-south-1.compute.internal mariadb-prepare-db-dir[1939]: If this is not the case, make>
Jun 28 11:20:08 ip-172-31-37-48.ap-south-1.compute.internal mariadbd[1986]: 2023-06-28 11:20:08 0 [Note] /usr/libexec/m>
Jun 28 11:20:09 ip-172-31-37-48.ap-south-1.compute.internal systemd[1]: Started mariadb.service - MariaDB 10.5 database>
[ec2-user@ip-172-31-37-48 ~]$