KAHIBARO Bookshelves
Discord Login Register

5.2.1. MySQL/MariaDB

Overview

MySQL and MariaDB are relational database management systems that store data in tables, use SQL as their query language, and are widely used on Linux servers. They are typically used as backends for web applications, internal business systems, and many open source tools. MariaDB began as a fork of MySQL and remains largely compatible with it, which is why they are often grouped together in administration tasks.

From a Linux server perspective, administering MySQL or MariaDB involves installing the server, securing it, managing users and permissions, creating and tuning databases, and planning for performance, backup, and replication. This chapter focuses on practical administration tasks and concepts that are specific to MySQL and MariaDB themselves, not general database theory.

Installation and Service Management

On most Linux distributions, MySQL or MariaDB is installed with the native package manager. MariaDB often replaces MySQL as the default in many distributions, while others provide both.

On Debian and Ubuntu, you typically install MariaDB with apt:

sudo apt update
sudo apt install mariadb-server

On Fedora and RHEL compatible systems, you install with dnf:

sudo dnf install mariadb-server

Some distributions offer mysql-server instead or as an alternative. You should check which server is provided and supported by your distribution and by the applications you plan to run.

Once installed, the database server is a systemd service that you control with systemctl. Common commands include:

sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb

If you are using MySQL instead, the service might be named mysqld or mysql depending on the packaging. You must always verify the actual unit name with systemctl list-units | grep -i mysql or mariadb.

Ensuring the service starts at boot is critical for production servers. You use systemctl enable only after confirming that the server starts correctly and there are no obvious errors in the logs.

Initial Security Configuration

After installation, a default configuration may leave the database server with weak security. Most MySQL and MariaDB packages provide a helper script, typically mysql_secure_installation, that guides you through basic hardening steps.

When you run:

sudo mysql_secure_installation

you are typically asked to set the root password for the database server, remove anonymous users, disallow remote root login, remove the test database, and reload the privilege tables. You should answer in a way that enforces least privilege and reduces attack surface.

Always set a strong, unique password for the MySQL or MariaDB root user and disable remote root logins in production environments.

Some distributions may use the Linux root account authentication (for example via unix_socket plugin) instead of a separate password. In this case, you connect as database root by using sudo mysql without specifying a password, and you might not want to replace this mechanism unless your security policy requires it.

Connecting to the Server

On a Linux server, you administer MySQL or MariaDB primarily through the command line client, usually called mysql. To connect as the database root user, you might use:

sudo mysql

if socket-based authentication is enabled, or:

mysql -u root -p

if the root user uses a password. For application-level users, you typically specify the database user and database name:

mysql -u appuser -p appdb

For remote administrative access, you use the -h option to specify the host:

mysql -h dbserver.example.com -u adminuser -p

Remote access requires that network binding is configured in the server configuration, the appropriate firewall rules are set, and the user account is granted access from the connecting host. In secure environments, remote access is often tunneled through SSH rather than exposing the MySQL or MariaDB port directly.

Basic Administrative SQL

Within the mysql client, you perform administrative tasks using SQL or special administrative statements. To see which databases exist, you run:

SHOW DATABASES;

To create a database:

CREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Choosing utf8mb4 is typical for modern applications because it supports the full range of Unicode characters.

To inspect the tables inside a database, you switch to it and then list its tables:

USE appdb;
SHOW TABLES;

To see how a particular table is defined, you can use:

DESCRIBE users;

or:

SHOW CREATE TABLE users\G

The \G format prints the output vertically, which is more readable for longer definitions.

For global server status and variables, you use:

SHOW GLOBAL STATUS;
SHOW GLOBAL VARIABLES;

You can filter by variable or status name:

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
SHOW STATUS LIKE 'Threads_connected';

These commands are essential for performance monitoring and tuning.

User Accounts and Authentication

MySQL and MariaDB use their own user system, distinct from Linux system users. A database user is identified by both a username and a host component. For example, appuser@localhost and appuser@'%' are considered different accounts.

To create a user account, you use CREATE USER. A simple example is:

CREATE USER 'appuser'@'localhost'
  IDENTIFIED BY 'strong_password_here';

Using localhost restricts this account to connections originating from the same machine, which is suitable for local applications. To allow connections from any host, you might use:

CREATE USER 'appuser'@'%'
  IDENTIFIED BY 'strong_password_here';

However, granting access from any host is usually not recommended unless paired with network controls. It is more secure to specify exact hostnames or IP ranges when possible.

MariaDB and more recent MySQL versions support additional authentication plugins, such as unix_socket or PAM. For example, using socket authentication you can map a database user to a Linux user without a separate password. This is often limited to local administrative roles to simplify secure access management.

To view existing users and their host components, you can query the internal tables:

SELECT User, Host FROM mysql.user;

Privileges and Access Control

Privileges in MySQL and MariaDB define what a user can do. They can be granted globally, per database, per table, and even per column in some cases. Common privileges include SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, and ALTER. Administrative privileges include SUPER, RELOAD, PROCESS, and others.

To give a user full access to a single database, you typically run:

GRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'localhost';
FLUSH PRIVILEGES;

You should prefer more limited grants when possible. For example, if an application only needs to read data, you can grant only SELECT:

GRANT SELECT ON appdb.* TO 'reportuser'@'localhost';

FLUSH PRIVILEGES is required in older versions or when you manipulate privilege tables directly. With normal GRANT and REVOKE statements in current versions, privilege changes are applied immediately.

To inspect what privileges a particular user has, you can use:

SHOW GRANTS FOR 'appuser'@'localhost';

This is useful for auditing and for diagnosing permission errors that applications encounter.

Never grant ALL PRIVILEGES on . to application users, and avoid giving SUPER or other administrative privileges to nonadministrative accounts.

Common Configuration Files and Options

MySQL and MariaDB configuration is usually stored in files such as /etc/my.cnf or /etc/mysql/my.cnf, with additional configuration snippets included from a directory like /etc/mysql/conf.d/ or /etc/my.cnf.d/. You must check your distribution for the exact paths.

These configuration files use sections, with [mysqld] for server options, [client] for client default options, and other sections for specific tools. An example minimal server configuration snippet might look like:

[mysqld]
bind-address = 127.0.0.1
max_connections = 200
innodb_buffer_pool_size = 2G

The bind-address option controls which network interface and IP address the server listens on. 127.0.0.1 limits connections to localhost. Setting it to 0.0.0.0 allows connections on all interfaces, which must be paired with proper firewalling and secure user grants.

The innodb_buffer_pool_size defines how much memory is allocated for caching InnoDB data and indexes. For InnoDB-focused workloads, this is one of the most important performance settings. A common starting heuristic for dedicated database servers is to allocate a significant fraction of RAM to this buffer, but you must leave sufficient memory for the operating system and other processes.

After changing configuration files, you must restart or at least reload the server:

sudo systemctl restart mariadb

In some cases, you can use SQL statements like:

SET GLOBAL max_connections = 500;

to apply changes without editing configuration files. However, such changes are temporary and last only until the server is restarted. Persistent configuration belongs in the configuration files.

Storage Engines and Table Types

MySQL and MariaDB support storage engines, which provide different ways to store and manage table data. The most important engine for modern usage is InnoDB, which provides transactions, row-level locking, and crash recovery. Other engines exist, such as MyISAM, MEMORY, ARCHIVE, and more specialized or plugin engines.

To see which storage engines are available, you can run:

Views: 0

Comments

Please login to add a comment.

Don't have an account? Register now!

Where to Move

Move chapter:

  • ☰ 1. PART I — Linux Fundamentals (Beginner)
    • ☰ 1.1. What Is Linux?
      • ☰ 1.1.1. What is an operating system
        • ☰ 1.1.2. History of Unix and Linux
          • ☰ 1.1.3. The Linux kernel
            • ☰ 1.1.4. GNU and the Free Software Foundation
              • ☰ 1.1.5. Open source philosophy
                • ☰ 1.1.6. Where Linux is used today
                  • ☰ 1.1.7. Desktop vs server vs embedded Linux
                  • ☰ 1.2. Choosing a Linux Distribution
                    • ☰ 1.2.1. What is a distribution?
                      • ☰ 1.2.2. Package formats (deb, rpm, pacman)
                        • ☰ 1.2.3. Popular distributions
                          • ☰ 1.2.3.1. Ubuntu
                            • ☰ 1.2.3.2. Debian
                              • ☰ 1.2.3.3. Fedora
                                • ☰ 1.2.3.4. Arch Linux
                                  • ☰ 1.2.3.5. openSUSE
                                  • ☰ 1.2.4. Rolling vs fixed release
                                    • ☰ 1.2.5. Choosing the right distribution
                                    • ☰ 1.3. Installing Linux
                                      • ☰ 1.3.1. Creating a bootable USB
                                        • ☰ 1.3.2. Installing on real hardware
                                          • ☰ 1.3.3. Dual booting with Windows
                                            • ☰ 1.3.4. Installing in a virtual machine
                                              • ☰ 1.3.5. Partitioning
                                                • ☰ 1.3.5.1. `/` (root)
                                                  • ☰ 1.3.5.2. `/home`
                                                    • ☰ 1.3.5.3. Swap
                                                    • ☰ 1.3.6. First-time setup
                                                    • ☰ 1.4. First Steps After Installation
                                                      • ☰ 1.4.1. Desktop environment basics
                                                        • ☰ 1.4.2. Updating the system
                                                          • ☰ 1.4.3. Installing essential tools
                                                            • ☰ 1.4.4. Setting up drivers
                                                              • ☰ 1.4.5. Using the software center
                                                              • ☰ 1.5. Linux Filesystem Hierarchy
                                                                • ☰ 1.5.1. Overview of the root filesystem
                                                                  • ☰ 1.5.2. Important directories
                                                                    • ☰ 1.5.2.1. `/etc`
                                                                      • ☰ 1.5.2.2. `/var`
                                                                        • ☰ 1.5.2.3. `/usr`
                                                                          • ☰ 1.5.2.4. `/tmp`
                                                                            • ☰ 1.5.2.5. `/dev`
                                                                              • ☰ 1.5.2.6. `/proc`
                                                                                • ☰ 1.5.2.7. `/sys`
                                                                                • ☰ 1.5.3. File types
                                                                                  • ☰ 1.5.4. Absolute vs relative paths
                                                                                  • ☰ 1.6. The Linux Graphical Environment
                                                                                    • ☰ 1.6.1. GNOME
                                                                                      • ☰ 1.6.2. KDE Plasma
                                                                                        • ☰ 1.6.3. XFCE
                                                                                          • ☰ 1.6.4. File managers
                                                                                            • ☰ 1.6.5. System settings
                                                                                              • ☰ 1.6.6. Workspaces and window management
                                                                                            • ☰ 2. PART II — Command Line Essentials
                                                                                              • ☰ 2.1. Terminal and Shell Basics
                                                                                                • ☰ 2.1.1. What is a shell?
                                                                                                  • ☰ 2.1.2. Bash vs Zsh vs Fish
                                                                                                    • ☰ 2.1.3. Command structure
                                                                                                      • ☰ 2.1.4. Environment variables
                                                                                                        • ☰ 2.1.5. Getting help
                                                                                                          • ☰ 2.1.6. Command history and autocomplete
                                                                                                          • ☰ 2.2. Files and Directories
                                                                                                            • ☰ 2.2.1. Listing files
                                                                                                              • ☰ 2.2.2. Navigating directories
                                                                                                                • ☰ 2.2.3. File operations
                                                                                                                  • ☰ 2.2.4. Wildcards and globbing
                                                                                                                    • ☰ 2.2.5. Searching files
                                                                                                                    • ☰ 2.3. Viewing and Editing Text Files
                                                                                                                      • ☰ 2.3.1. Viewing tools
                                                                                                                        • ☰ 2.3.2. Editing with nano
                                                                                                                          • ☰ 2.3.3. Introduction to vim
                                                                                                                            • ☰ 2.3.4. Input/output redirection
                                                                                                                            • ☰ 2.4. Users, Permissions, and Ownership
                                                                                                                              • ☰ 2.4.1. Users and groups
                                                                                                                                • ☰ 2.4.2. Permission types (r, w, x)
                                                                                                                                  • ☰ 2.4.3. Changing permissions
                                                                                                                                    • ☰ 2.4.4. Changing ownership
                                                                                                                                      • ☰ 2.4.5. Using sudo
                                                                                                                                      • ☰ 2.5. Package Management
                                                                                                                                        • ☰ 2.5.1. Software repositories
                                                                                                                                          • ☰ 2.5.2. APT (Debian/Ubuntu)
                                                                                                                                            • ☰ 2.5.3. DNF (Fedora/RHEL)
                                                                                                                                              • ☰ 2.5.4. Pacman (Arch Linux)
                                                                                                                                                • ☰ 2.5.5. Snap, Flatpak, AppImage
                                                                                                                                                  • ☰ 2.5.6. System upgrades
                                                                                                                                                  • ☰ 2.6. Working with Processes
                                                                                                                                                    • ☰ 2.6.1. What is a process?
                                                                                                                                                      • ☰ 2.6.2. Viewing processes
                                                                                                                                                        • ☰ 2.6.3. Killing processes
                                                                                                                                                          • ☰ 2.6.4. Foreground and background jobs
                                                                                                                                                            • ☰ 2.6.5. System services and daemons
                                                                                                                                                            • ☰ 2.7. Introduction to Shell Scripting
                                                                                                                                                              • ☰ 2.7.1. Writing your first script
                                                                                                                                                                • ☰ 2.7.2. Variables
                                                                                                                                                                  • ☰ 2.7.3. Conditionals
                                                                                                                                                                    • ☰ 2.7.4. Loops
                                                                                                                                                                      • ☰ 2.7.5. Functions
                                                                                                                                                                        • ☰ 2.7.6. Making scripts executable
                                                                                                                                                                      • ☰ 3. PART III — Intermediate System Administration
                                                                                                                                                                        • ☰ 3.1. Systemd and Service Management
                                                                                                                                                                          • ☰ 3.1.1. What is systemd?
                                                                                                                                                                            • ☰ 3.1.2. Managing services (systemctl)
                                                                                                                                                                              • ☰ 3.1.3. Boot targets
                                                                                                                                                                                • ☰ 3.1.4. System logs (journalctl)
                                                                                                                                                                                  • ☰ 3.1.5. Creating custom services
                                                                                                                                                                                  • ☰ 3.2. Storage and Filesystems
                                                                                                                                                                                    • ☰ 3.2.1. Devices and partitions
                                                                                                                                                                                      • ☰ 3.2.2. Filesystems (EXT4, XFS, Btrfs)
                                                                                                                                                                                        • ☰ 3.2.3. Mounting and unmounting
                                                                                                                                                                                          • ☰ 3.2.4. Disk usage tools
                                                                                                                                                                                            • ☰ 3.2.5. Archiving and compression (tar, gzip, xz)
                                                                                                                                                                                            • ☰ 3.3. Networking Fundamentals
                                                                                                                                                                                              • ☰ 3.3.1. IP addressing
                                                                                                                                                                                                • ☰ 3.3.2. Subnets and routing
                                                                                                                                                                                                  • ☰ 3.3.3. DNS and hostnames
                                                                                                                                                                                                    • ☰ 3.3.4. Networking tools (ip, ss, ping)
                                                                                                                                                                                                      • ☰ 3.3.5. Editing network configuration files
                                                                                                                                                                                                      • ☰ 3.4. User and Group Administration
                                                                                                                                                                                                        • ☰ 3.4.1. User information files
                                                                                                                                                                                                          • ☰ 3.4.2. Creating and removing users
                                                                                                                                                                                                            • ☰ 3.4.3. Password policies
                                                                                                                                                                                                              • ☰ 3.4.4. Managing groups
                                                                                                                                                                                                                • ☰ 3.4.5. Shell configuration
                                                                                                                                                                                                                • ☰ 3.5. System Monitoring
                                                                                                                                                                                                                  • ☰ 3.5.1. CPU and memory monitoring
                                                                                                                                                                                                                    • ☰ 3.5.2. Disk and I/O monitoring
                                                                                                                                                                                                                      • ☰ 3.5.3. Log files in /var/log
                                                                                                                                                                                                                        • ☰ 3.5.4. Boot performance
                                                                                                                                                                                                                          • ☰ 3.5.5. Monitoring running services
                                                                                                                                                                                                                          • ☰ 3.6. Backup and Restore
                                                                                                                                                                                                                            • ☰ 3.6.1. Backup strategies
                                                                                                                                                                                                                              • ☰ 3.6.2. Using rsync
                                                                                                                                                                                                                                • ☰ 3.6.3. Creating tar archives
                                                                                                                                                                                                                                  • ☰ 3.6.4. Using snapshot systems
                                                                                                                                                                                                                                    • ☰ 3.6.5. Automating backups
                                                                                                                                                                                                                                    • ☰ 3.7. Basic System Security
                                                                                                                                                                                                                                      • ☰ 3.7.1. Firewalls (UFW, firewalld)
                                                                                                                                                                                                                                        • ☰ 3.7.2. Authentication policies
                                                                                                                                                                                                                                          • ☰ 3.7.3. SSH security basics
                                                                                                                                                                                                                                            • ☰ 3.7.4. SELinux and AppArmor overview
                                                                                                                                                                                                                                              • ☰ 3.7.5. Intrusion detection basics
                                                                                                                                                                                                                                            • ☰ 4. PART IV — Advanced Linux Skills
                                                                                                                                                                                                                                              • ☰ 4.1. Advanced Shell Scripting
                                                                                                                                                                                                                                                • ☰ 4.1.1. Script structure
                                                                                                                                                                                                                                                  • ☰ 4.1.2. Error handling
                                                                                                                                                                                                                                                    • ☰ 4.1.3. Debugging scripts
                                                                                                                                                                                                                                                      • ☰ 4.1.4. Scheduled tasks (cron)
                                                                                                                                                                                                                                                      • ☰ 4.2. The Linux Boot Process
                                                                                                                                                                                                                                                        • ☰ 4.2.1. BIOS vs UEFI
                                                                                                                                                                                                                                                          • ☰ 4.2.2. Understanding GRUB2
                                                                                                                                                                                                                                                            • ☰ 4.2.3. Kernel loading
                                                                                                                                                                                                                                                              • ☰ 4.2.4. initramfs
                                                                                                                                                                                                                                                                • ☰ 4.2.5. Troubleshooting boot issues
                                                                                                                                                                                                                                                                • ☰ 4.3. Kernel Management
                                                                                                                                                                                                                                                                  • ☰ 4.3.1. What is the kernel?
                                                                                                                                                                                                                                                                    • ☰ 4.3.2. Kernel modules
                                                                                                                                                                                                                                                                      • ☰ 4.3.3. Kernel parameters
                                                                                                                                                                                                                                                                        • ☰ 4.3.4. Compiling a custom kernel
                                                                                                                                                                                                                                                                          • ☰ 4.3.5. Kernel versioning and updates
                                                                                                                                                                                                                                                                          • ☰ 4.4. Advanced Filesystems and Storage
                                                                                                                                                                                                                                                                            • ☰ 4.4.1. LVM concepts
                                                                                                                                                                                                                                                                              • ☰ 4.4.2. Logical volumes
                                                                                                                                                                                                                                                                                • ☰ 4.4.3. RAID levels
                                                                                                                                                                                                                                                                                  • ☰ 4.4.4. Full disk encryption (LUKS)
                                                                                                                                                                                                                                                                                    • ☰ 4.4.5. Snapshots and rollbacks
                                                                                                                                                                                                                                                                                    • ☰ 4.5. Network Services
                                                                                                                                                                                                                                                                                      • ☰ 4.5.1. SSH server configuration
                                                                                                                                                                                                                                                                                        • ☰ 4.5.2. NFS
                                                                                                                                                                                                                                                                                          • ☰ 4.5.3. Samba
                                                                                                                                                                                                                                                                                            • ☰ 4.5.4. FTP/SFTP
                                                                                                                                                                                                                                                                                              • ☰ 4.5.5. Firewalls in depth
                                                                                                                                                                                                                                                                                              • ☰ 4.6. Logging and Auditing
                                                                                                                                                                                                                                                                                                • ☰ 4.6.1. Systemd logging
                                                                                                                                                                                                                                                                                                  • ☰ 4.6.2. Traditional logs in /var/log
                                                                                                                                                                                                                                                                                                    • ☰ 4.6.3. Auditd
                                                                                                                                                                                                                                                                                                      • ☰ 4.6.4. Log rotation
                                                                                                                                                                                                                                                                                                        • ☰ 4.6.5. Creating custom logs
                                                                                                                                                                                                                                                                                                        • ☰ 4.7. Virtualization and Containers
                                                                                                                                                                                                                                                                                                          • ☰ 4.7.1. Virtual machines (KVM/QEMU)
                                                                                                                                                                                                                                                                                                            • ☰ 4.7.2. Linux containers (LXC/LXD)
                                                                                                                                                                                                                                                                                                              • ☰ 4.7.3. Docker fundamentals
                                                                                                                                                                                                                                                                                                                • ☰ 4.7.4. Podman vs Docker
                                                                                                                                                                                                                                                                                                                  • ☰ 4.7.5. Container networking
                                                                                                                                                                                                                                                                                                                • ☰ 5. PART V — Server Administration (Expert)
                                                                                                                                                                                                                                                                                                                  • ☰ 5.1. Web Servers
                                                                                                                                                                                                                                                                                                                    • ☰ 5.1.1. Apache basics
                                                                                                                                                                                                                                                                                                                      • ☰ 5.1.2. Nginx basics
                                                                                                                                                                                                                                                                                                                        • ☰ 5.1.3. Virtual hosts
                                                                                                                                                                                                                                                                                                                          • ☰ 5.1.4. SSL/HTTPS
                                                                                                                                                                                                                                                                                                                            • ☰ 5.1.5. Reverse proxy concepts
                                                                                                                                                                                                                                                                                                                            • ☰ 5.2. Database Servers
                                                                                                                                                                                                                                                                                                                              • ☰ 5.2.1. MySQL/MariaDB
                                                                                                                                                                                                                                                                                                                                • ☰ 5.2.2. PostgreSQL
                                                                                                                                                                                                                                                                                                                                  • ☰ 5.2.3. Database backup strategies
                                                                                                                                                                                                                                                                                                                                    • ☰ 5.2.4. Database hardening
                                                                                                                                                                                                                                                                                                                                    • ☰ 5.3. Email Services
                                                                                                                                                                                                                                                                                                                                      • ☰ 5.3.1. SMTP fundamentals
                                                                                                                                                                                                                                                                                                                                        • ☰ 5.3.2. Configuring Postfix
                                                                                                                                                                                                                                                                                                                                          • ☰ 5.3.3. IMAP/POP3 with Dovecot
                                                                                                                                                                                                                                                                                                                                            • ☰ 5.3.4. Spam filtering systems
                                                                                                                                                                                                                                                                                                                                              • ☰ 5.3.5. Email routing concepts
                                                                                                                                                                                                                                                                                                                                              • ☰ 5.4. DNS and DHCP
                                                                                                                                                                                                                                                                                                                                                • ☰ 5.4.1. Understanding DNS
                                                                                                                                                                                                                                                                                                                                                  • ☰ 5.4.2. Setting up BIND
                                                                                                                                                                                                                                                                                                                                                    • ☰ 5.4.3. DNS zones and records
                                                                                                                                                                                                                                                                                                                                                      • ☰ 5.4.4. DHCP server configuration
                                                                                                                                                                                                                                                                                                                                                        • ☰ 5.4.5. DNS troubleshooting
                                                                                                                                                                                                                                                                                                                                                        • ☰ 5.5. Load Balancing
                                                                                                                                                                                                                                                                                                                                                          • ☰ 5.5.1. HAProxy fundamentals
                                                                                                                                                                                                                                                                                                                                                            • ☰ 5.5.2. Nginx as a load balancer
                                                                                                                                                                                                                                                                                                                                                              • ☰ 5.5.3. Session persistence
                                                                                                                                                                                                                                                                                                                                                                • ☰ 5.5.4. High availability concepts
                                                                                                                                                                                                                                                                                                                                                                • ☰ 5.6. Clustering and High Availability
                                                                                                                                                                                                                                                                                                                                                                  • ☰ 5.6.1. Failover principles
                                                                                                                                                                                                                                                                                                                                                                    • ☰ 5.6.2. Pacemaker
                                                                                                                                                                                                                                                                                                                                                                      • ☰ 5.6.3. Corosync
                                                                                                                                                                                                                                                                                                                                                                        • ☰ 5.6.4. Cluster resource management
                                                                                                                                                                                                                                                                                                                                                                          • ☰ 5.6.5. Distributed filesystems
                                                                                                                                                                                                                                                                                                                                                                        • ☰ 6. PART VI — DevOps and Cloud
                                                                                                                                                                                                                                                                                                                                                                          • ☰ 6.1. Linux for Developers
                                                                                                                                                                                                                                                                                                                                                                            • ☰ 6.1.1. Compiler toolchains (gcc, make)
                                                                                                                                                                                                                                                                                                                                                                              • ☰ 6.1.2. Git fundamentals
                                                                                                                                                                                                                                                                                                                                                                                • ☰ 6.1.3. Debugging tools (gdb, strace)
                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 6.1.4. Build automation (Makefile, CMake)
                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 6.2. DevOps on Linux
                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 6.2.1. CI/CD principles
                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 6.2.2. YAML basics
                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 6.2.3. GitHub Actions
                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 6.2.4. GitLab CI/CD
                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 6.2.5. Automated testing
                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 6.3. Configuration Management
                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 6.3.1. Ansible basics
                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 6.3.2. Playbooks and inventories
                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 6.3.3. Puppet overview
                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 6.3.4. Chef overview
                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 6.4. Infrastructure as Code
                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 6.4.1. Terraform fundamentals
                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 6.4.2. Providers and resources
                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 6.4.3. Modules
                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 6.4.4. Cloud provisioning with Terraform
                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 6.5. Cloud Computing with Linux
                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 6.5.1. Linux on AWS
                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 6.5.2. Linux on Azure
                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 6.5.3. Linux on GCP
                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 6.5.4. Cloud networking basics
                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 6.5.5. Scaling and monitoring
                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 7. PART VII — Master Topics
                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 7.1. Hardening a Linux System
                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 7.1.1. Hardening principles
                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 7.1.2. Kernel hardening
                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 7.1.3. File integrity monitoring
                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 7.1.4. Vulnerability scanning
                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 7.2. Forensics and Incident Response
                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 7.2.1. Collecting evidence
                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 7.2.2. Log and file recovery
                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 7.2.3. Analyzing suspicious processes
                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 7.2.4. Incident response workflow
                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 7.3. Performance Tuning
                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 7.3.1. CPU tuning
                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 7.3.2. Memory tuning
                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 7.3.3. Disk and I/O optimization
                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 7.3.4. Profiling tools
                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 7.4. Writing Linux Tools
                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 7.4.1. Bash-based tools
                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 7.4.2. Python command-line tools
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 7.4.3. Writing tools in C
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 7.4.4. Using Linux system APIs
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 7.5. Linux Internals
                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 7.5.1. Process lifecycle
                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 7.5.2. Memory management
                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 7.5.3. Signals and IPC
                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 7.5.4. Namespaces
                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 7.5.5. cgroups
                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 7.6. Becoming a Linux Expert
                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 7.6.1. Career paths
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 7.6.2. Certifications (RHCE, LFCS, LPIC)
                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 7.6.3. Building a homelab
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 7.6.4. Contributing to open source