MariaDB Documentation

• SQL Statements & Structure

  SQL Statements, Structure, and Rules.
• Built-in Functions

  Functions and Procedures in MariaDB
• Clients & Utilities

  Client and Utility Programs for MariaDB.
• Migrating to MariaDB

  Compatibility and Differences between MariaDB and Other Database Systems.

MariaDB Administration

• Getting, Installing, and Upgrading MariaDB

  Getting, Installing, and Upgrading MariaDB Server and Related Software.
• User & Server Security

  Creating Users and Granting Privileges, as well as Encryption.
• Backing Up and Restoring Databases

  Tools and Methods for Backing Up and Restoring Databases.
• Server Monitoring & Logs

  Monitoring the MariaDB Server and Enabling and Using Logs.
• Partitioning Tables

  Splitting Huge Tables into Multiple Table Files.
• MariaDB Audit Plugin

  under: » Library » MariaDB Documentation » Columns, Storage Engines, and Plugins » Plugins
  Logging User Activity with the MariaDB Audit Plugin.
• Variables and Modes

  Server Variables and SQL Modes.
• 1

  Copying Tables Between Different MariaDB Databases and MariaDB Servers

  Copy table files.

High Availability & Performance Tuning

• MariaDB Replication

  Documentation on Standard Master and Slave Replication.
• MariaDB Galera Cluster

  MariaDB Galera Cluster is a synchronous multi-master cluster.
• MariaDB MaxScale

  under: » MariaDB Enterprise
  Database Proxy for Forwarding of SQL Statements to Multiple Database Servers.
• Optimization and Tuning

  Using Indexes, Writing Better Queries and Adjusting Variables for Better Performance.

Columns, Storage Engines, and Plugins

• Data Types

  Data Types for Columns in MariaDB Tables.
• Character Sets and Collations

  under: » Library » MariaDB Documentation » Columns, Storage Engines, and Plugins » Data Types » String Data Types
  Setting Characters and Collation for a Language.
• Storage Engines

  Various Storage Engines Available for MariaDB.
• Plugins

  Documentation on Plugins for the MariaDB Server.

Programming & Customizing MariaDB

• Programmatic & Compound Statements

  Compound SQL Statements for Stored Routines and in General.
• Stored Routines

  Stored Procedures and Functions, as well as Triggers and Events.
• Triggers & Events

  Creating Triggers and Scheduled Events within MariaDB.
• Views

  Stored Queries for Generating a Virtual Table.
• User-Defined Functions

  Extending MariaDB with Custom Functions.