MySQL / MariaDB DBA

 Install sysbench and Test , get reports.. ---------------------------------------------------- Installation  ---------------- [root@ip-172-31-62-204 ~]# curl -s https://packagecloud.io/install/repositories/akopytov/sysbench/script.rpm.sh | sudo bash [root@ip-172-31-62-204 ~]# yum search sysbench [root@ip-172-31-62-204 ~]# yum install sysbench [root@ip-172-31-62-204 ~]# which sysbench /usr/bin/sysbench [root@ip-172-31-62-204 ~]# [root@ip-172-31-62-204 ~]# ls -ltr /usr/share/sysbench -rwxr-xr-x. 1 root root  2114 Apr 24  2020 select_random_ranges.lua -rwxr-xr-x. 1 root root  1915 Apr 24  2020 select_random_points.lua -rwxr-xr-x. 1 root root  1436 Apr 24  2020 oltp_write_only.lua -rwxr-xr-x. 1 root root  1123 Apr 24  2020 oltp_update_non_index.lua -rwxr-xr-x. 1 root root  1114 Apr 24  2020 oltp_update_index.lua -rwxr-xr-x. 1 root root  1820 Apr 24  2020 oltp_read_write.lua -rwxr-xr-x. 1 root root  1645 Apr 24 ...

  PMM Server , Client Setup [ Complete Document ]   In this Example , I have taken 2 MariaDB servers and 1 PMM Server. Deployed 3 RHEL 8 Versions for PMM setup [ EC2 ]   MariaDB server 1 è vasu-maria1-pmm-poc è 172.31.22.44 [Private IP Address] MariaDB server 2 è vasu-maria2-pmm-poc è 172.31.16.154[Private IP Address ] PMM server        è vasu-pmm-poc   è 172.31.17.0 [ Private IP Address ]   Security Group = Default VPC             = Default   Reference Link = https://www.percona.com/software/pmm/quickstart#   ##################################################################### Step - 1 :- Install MariaDB on Both servers #####################################################################   DB Version = 10.3.12   [root@ip-172-31-22-44 ~]# groupadd mysql [root@ip-172-31-22-44 ~]# useradd mysql -g mysql [root@ip-172-31-22-...