MariaDB Server Documentation

Using MariaDB Server

• SQL Statements & Structure

  SQL statements, structure, and rules.
• Built-in Functions

  under: » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Statements
  Functions and procedures in MariaDB.
• Clients & Utilities

  Client and utility programs for MariaDB.
• 1

  create master and slave server

  how to create master 192.168.0.201 and slave 192.168.0.220 back up

MariaDB Administration

• Getting, Installing, and Upgrading MariaDB

  Getting, installing, and upgrading MariaDB Server and related software.
• User & Server Security

  Creating users, granting privileges, and encryption.
• Backing Up and Restoring Databases

  Tools and methods for backing up and restoring databases.
• Server Monitoring & Logs

  Monitoring MariaDB Server and enabling and using logs.
• Partitioning Tables

  Splitting huge tables into multiple table files.
• MariaDB Audit Plugin

  under: » MariaDB Server 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 primary and replica replication.
• MariaDB Galera Cluster

  MariaDB Galera Cluster is a virtually synchronous multi-master cluster.
• Optimization and Tuning

  Using indexes, writing better queries and adjusting variables for better performance.
• Connection Redirection Mechanism in the MariaDB Client/Server Protocol

  Connection Redirection Mechanism in the MariaDB Client/Server Protocol.
• Multi Master in maria db

  Can we configure Multi Master in Maria Db. I have testing three node A, B, ...
• Multi master replication and deadlock detection in Galera with Mariadbs

  Hi, We have multi master Galera replication setup where three master maria...

Columns, Storage Engines, and Plugins

• Data Types

  Data types for columns in MariaDB tables.
• Character Sets and Collations

  under: » MariaDB Server Documentation » Columns, Storage Engines, and Plugins » Data Types » String Data Types
  Setting character set and collation for a language.
• Storage Engines

  Various storage engines available for MariaDB.
• Plugins

  Documentation on MariaDB Server plugins.

Programming & Customizing MariaDB

• Programmatic & Compound Statements

  Compound SQL statements for stored routines and in general.
• Stored Routines

  Stored procedures and functions.
• 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.
• 1

  assertion

  how to create assertion in mariadb?

MariaDB Enterprise Server

• Differences in MariaDB Enterprise Server 10.6

  MariaDB Enterprise Server 10.6 vs. MariaDB Community Server 10.6
• Differences in MariaDB Enterprise Server 10.5

  MariaDB Enterprise Server 10.5 vs. MariaDB Community Server 10.5
• Differences in MariaDB Enterprise Server 10.4

  MariaDB Enterprise Server 10.4 vs. MariaDB Community Server 10.4