MariaDB Database

  1. Installation and Initial Setup
    1. System Requirements
      1. Hardware Recommendations
        1. CPU Requirements
          1. Memory Requirements
            1. Disk Space and I/O Considerations
            2. Supported Operating Systems
              1. Linux Distributions
                1. Windows
                  1. macOS
                    1. Other Platforms
                  2. Installation Methods
                    1. Using Package Managers
                      1. yum on CentOS/RHEL
                        1. apt on Debian/Ubuntu
                          1. Repository Configuration
                          2. Using Binary Tarballs
                            1. Downloading Binaries
                              1. Extracting and Installing
                              2. Compiling from Source
                                1. Source Code Acquisition
                                  1. Build Dependencies
                                    1. Compilation Steps
                                    2. Using Docker Containers
                                      1. Official MariaDB Images
                                        1. Container Configuration
                                          1. Data Persistence
                                        2. Post-Installation Security Script
                                          1. mariadb-secure-installation
                                            1. Setting Root Password
                                              1. Removing Anonymous Users
                                                1. Disabling Remote Root Login
                                                  1. Removing Test Database
                                                2. Server Startup and Shutdown
                                                  1. systemd and service commands
                                                    1. Starting the Server
                                                      1. Stopping the Server
                                                        1. Restarting the Server
                                                          1. Checking Server Status
                                                          2. mariadbd-safe and mariadb-admin
                                                            1. Safe Startup Options
                                                              1. Administrative Utilities
                                                            2. The MariaDB Client (mariadb)
                                                              1. Connecting to the Server
                                                                1. Connection Parameters
                                                                  1. Authentication Methods
                                                                  2. Basic Command-Line Usage
                                                                    1. Executing SQL Statements
                                                                      1. Using Input and Output Files
                                                                        1. Interactive and Batch Modes
                                                                      2. Core Configuration
                                                                        1. The my.cnf Configuration File
                                                                          1. File Structure and Syntax
                                                                            1. Common Sections
                                                                              1. [mysqld] Section
                                                                                1. [client] Section
                                                                                  1. [mysql] Section
                                                                                    1. [mariadb] Section
                                                                                  2. Configuration File Locations and Order
                                                                                    1. System-wide vs. User-specific Files
                                                                                      1. File Precedence
                                                                                      2. Essential Server System Variables
                                                                                        1. Setting Variables in my.cnf
                                                                                          1. Dynamic vs. Static Variables
                                                                                            1. Commonly Tuned Variables

                                                                                        Previous

                                                                                        1. Introduction to MariaDB

                                                                                        Go to top

                                                                                        Next

                                                                                        3. SQL Fundamentals