Popular MySQL Servers
Oracle MySQL, MariaDB, Percona MySQL are forks of original
MySQL AB
MariaDB Provides: Columnar Storage, Temporal Tables, Transaction
replay, non-blocking backups, Oracle Compatible, Pluggable Storage
Engines
Percona Provides: XtraDB Cluster, Percona-Toolkit, XtraBackup,
TokuDB, MyRocks Storage Engine, InnoDB Full-Text Search,
Compressed Columns
Oracle MySQL Provides: HeatWave, mysqlcheck, Scalability, Dual
Passwords, High Performance, Bob, the DBA
MYSQL INSTALLATION
PROJECT: MySQL Installation
ASSIGNMENT: Install latest MySQL 8 community edition on a RHEL
system.
ASSIGNEE: Bob, The Ultimate DBA
MYSQL INSTALLATION
STEPS: MySQL Installation
❖ Download MySQL 8 Repository Package
❖ Install the MySQL Community Server Repo
❖ Install MySQL Server
❖ Enable MySQL Server to Auto-Start on Boot
❖ Start MySQL Server
❖ Verify if MySQL is running
MariaDB INSTALLATION
PROJECT: MariaDB Installation
ASSIGNMENT: Install MariaDB community edition on a RHEL system.
ASSIGNEE: Bob, The Ultimate DBA
MariaDB INSTALLATION
STEPS: MariaDB Installation
❖ Most Distributions already have MariaDB repo
❖ Install MariaDB Server
❖ Enable MariaDB Server to Auto-Start on Boot
❖ Start MariaDB Server
❖ Verify if MariaDB is running
Percona MySQL
INSTALLATION
PROJECT: Percona MySQL Installation
ASSIGNMENT: Install latest Percona MySQL 8 community edition.
ASSIGNEE: Bob, The Ultimate DBA
Percona MySQL
INSTALLATION
STEPS: Percona flavor of MySQL Installation
❖ Download Percona Release Repository Package
❖ Install Percona Release Repository Package
❖ Install Percona MySQL Server
❖ Enable MySQL Server to Auto-Start on Boot
❖ Start MySQL Server
❖ Verify if MySQL is running
MySQL UNINSTALLATION
PROJECT: Uninstall MySQL
ASSIGNMENT: Remove MySQL binaries and data files from host.
ASSIGNEE: Bob, The Ultimate DBA
MySQL UNINSTALLATION
STEPS: Removing MySQL Installation
❖ Search for all installed packages
❖ Remove Release Repository Package
❖ Remove MySQL Server, Client, Shared, etc.
❖ Remove mysql user
❖ Remove any leftover mysql-related file
❖ Verify MySQL is no more present
Custom MySQL
INSTALLATION
PROJECT: Install Specific Version of MySQL
ASSIGNMENT: Install 8.0.26-16.1 Version of MySQL 8.
ASSIGNEE: Bob, The Ultimate DBA
Percona MySQL
INSTALLATION
STEPS: Percona flavor of MySQL Installation
❖ Download Percona Release Repository Package
❖ Install Percona Release Repository Package
❖ Enable Percona Server 8 Repository
❖ Set Environment Variable VERSION=8.0.26-16.1
❖ Install Percona Server Packages as:
➢ percona-server-server-$VERSION.el7.x86_64
➢ percona-server-client-$VERSION.el7.x86_64
➢ percona-server-shared-$VERSION.el7.x86_64
➢ percona-server-shared-compat-$VERSION.el7.x86_64
❖ Enable MySQL Server to Auto-Start on Boot
❖ Start MySQL Server
❖ Verify if MySQL is running
MYSQL SECURE
INSTALLATION
PROJECT: MySQL Secure Installation
ASSIGNMENT: Improve the MySQL Server Security
ASSIGNEE: Bob, The Ultimate DBA
MYSQL SECURE
INSTALLATION
Program: mysql_secure_installation
❖ A shell script available on Unix systems, use to improve MySQL
security
❖ An executable script in binary format - can’t view it
❖ Source code:
[Link]
_secure_installation.sh
❖ Sets password for root account
❖ Disallows root login from remote locations
❖ Removes anonymous users
❖ Removes test database
LINUX
UTILITIES/PACKAGES
pidof:
❖ Unix command-line utility to find the process-id of a running process.
❖ It is not a rpm package
❖ Does not require sudo privilege
netstat:
❖ Print network connection, listening ports, open sockets
❖ Part of basic networking tools package net-tools
❖ Requires sudo privilege
Lsof:
❖ List all open files
❖ Part of lsof package
❖ Requires sudo privilege