Table of Contents

• About this Documentation
  • Front Matter
  • Enterprise-Ready Platform
  • Enterprise-Ready Documentation
  • Contents and Structure
  • Documentation Features
• Critical Success Factors
  • Testing
  • Vendor Support
  • Design
  • Adaptation and Integration
  • Planning
• Feature Summary
  • MariaDB Platform
    • How to Obtain MariaDB Platform
    • Components of MariaDB Platform
    • MariaDB Platform Use Cases
    • Key Features
  • Enterprise Lifecycle
    • Enterprise Builds
    • Enterprise Releases
    • Enterprise Support
  • Enterprise Release Schedule
    • Next Scheduled Release
    • Scheduled Releases
    • Prior Releases
    • Obtaining MariaDB Enterprise Server
  • MariaDB Enterprise Server
    • Vendor Support
    • Reliability and Scaling
    • Security
    • Modern SQL Features
    • Procedural Languages
    • What's New in MariaDB Enterprise Server 10.4?
    • What's New in MariaDB Enterprise Server 10.3?
    • What's New in MariaDB Enterprise Server 10.2?
  • MariaDB MaxScale
    • Architecture Solutions
    • Hybrid Transactional/Analytical Processing (HTAP)
    • Automatic Failover
    • Traffic Controls
    • What's New in MaxScale 2.4?
    • What's New in MaxScale 2.3?
  • MariaDB ColumnStore
    • Benefits of Columnar Storage
    • Hybrid Transactional and Analytical Processing
    • S3 Storage Manager
    • Scalability
    • High Availability
    • Connectors to BI Tools
    • Data Ingestion Tools
    • UDAF C++ API
    • New in ColumnStore 1.4
  • MariaDB Connectors
    • Language Support
  • Obtaining Support
  • Document History
    • Changes
• Deployment Guide
  • Deployment Planning
    • Supported Products and Versions
    • MariaDB Platform Deployment Process
    • MariaDB Platform Overview
    • OS Compatibility
    • Hardware Compatibility
    • Deployment Methods
    • Recommended Versions
  • Instructions by Objective
    • Deployment Targets
    • Deploy a Single Standalone Server
    • Deploy a Primary Server
    • Deploy a Replica Server
    • Deploy a Cluster Node
    • Deploy a MaxScale Instance
    • Deploy a Single ColumnStore Instance
    • Deploy a Multi-Node ColumnStore Deployment
    • Deploy a HTAP Deployment
    • Upgrade MariaDB Enterprise Server
    • Upgrade a MaxScale Instance
    • Upgrade a Single ColumnStore Instance
    • Upgrade a Multi-Node ColumnStore Deployment
    • Pending Deployment Targets
  • Instructions by OS
  • Instructions by Product
  • Deployment Support
    • Best Practices
    • Customer Download Token
    • Critical Success Factors
    • Get Support
    • Document History
• Application Development Guide
  • MariaDB Platform Overview
    • Available Documentation
    • Platform Capabilities
    • Platform Components
  • Critical Success Factors
    • Testing
    • Vendor Support
    • Design
    • Adaptation and Integration
    • Planning
  • Application Development
    • Real-time Flexibility and Personalization
    • Available Everywhere
    • Ready for Agile Lifecycle
  • Client Connections
  • Databases
  • Transactions
  • Functions
  • Triggers
  • Temporal Tables
    • System-Versioned Tables
    • Application-Time Period Tables
    • Bitemporal Tables
    • Backing up Temporal Tables
    • MariaDB Replication
    • Data Retention Strategies
    • Reference
  • SQL/PL
    • Migration Assistance
  • JSON
  • MariaDB Connector/C
    • Installation
  • MariaDB Connector/Python
    • Installation
    • Connection
    • Basic Operations
    • Transactions
    • Connection Pooling
    • Field Information
  • Obtaining Support
  • Document History
    • Changes
• Recovery Guide
  • MariaDB Platform Overview
    • Available Documentation
    • Platform Capabilities
    • Platform Components
  • Critical Success Factors
    • Testing
    • Vendor Support
    • Design
    • Adaptation and Integration
    • Planning
  • Forming a Backup Strategy
    • Data Inventory
    • Recovery Objectives
    • Achieving RPO
    • Achieving RTO
    • Replication Considerations
    • Encryption Considerations
    • Backup Storage Considerations
    • Backup Testing
  • MariaDB Enterprise Backup
    • Storage Engines and Backup Types
    • Non-blocking Backups
    • Understanding Recovery
    • Creating the Backup User
    • Full Backup and Restore
    • Incremental Backup and Restore
    • Partial Backup and Restore
    • Point-in-Time Recoveries
  • Backup Optimization
    • Scheduling of Restore Preparation
    • Moving Restored Data
    • Multi-threading
    • Incrementing an Incremental Backup
    • Storage Snapshots
  • Obtaining Support
  • Document History
    • Changes
• Security Guide
  • MariaDB Platform Overview
    • Available Documentation
    • Platform Capabilities
    • Platform Components
  • Critical Success Factors
    • Testing
    • Vendor Support
    • Design
    • Adaptation and Integration
    • Planning
  • Authentication and Authorization
  • Encryption
  • Logging
  • MariaDB Enterprise Audit
    • General Operation
    • Audit Log Considerations
    • Enabling the Audit Plugin
    • Starting, Stopping, and Monitoring the Audit Plugin
    • Additional Points of Control
    • Audit Filters
    • Audit Log Output Formats
    • Error Handling on Startup
    • Upgrades
  • Security
    • Additional Resources
  • Fixed Security Vulnerabilities
  • Obtaining Support
  • Document History
    • Changes
• Solutions Guide
  • MariaDB Platform Overview
    • Available Documentation
    • Platform Capabilities
    • Platform Components
  • Critical Success Factors
    • Testing
    • Vendor Support
    • Design
    • Adaptation and Integration
    • Planning
  • High Availability
  • Hybrid Transactional-Analytical Processing (HTAP)
  • Instant ALTER
  • Load Balancing
  • MariaDB Enterprise Cluster
    • How it Works
    • Architecture
    • Cluster Configuration
    • Cluster Replication
    • Scale-out
    • Failover
    • Backups
    • Encryption
  • MariaDB Replication
  • Optimizer Trace
  • Partitions
    • Additional Resources
  • Plugins
  • Sharding
  • Storage Engines
  • Obtaining Support
  • Document History
    • Changes
• What is SkySQL?
  • Services
  • Operational Benefits
  • For more information
• Reference
  • MariaDB Enterprise Server 10.4
    • Data Types in 10.4
    • SQL Statements in 10.4
    • SQL Operators in 10.4
    • Functions in 10.4
    • System Variables in 10.4
    • Status Variables in 10.4
    • System Tables in 10.4
    • Plugins in 10.4
    • Performance Schema in 10.4
    • Information Schema in 10.4
    • wsrep Provider Options in 10.4
    • Error Codes in 10.4
    • Reserved Words in 10.4
    • Command-Line Reference for 10.4
  • MariaDB Enterprise Server 10.3
    • Data Types in 10.3
    • SQL Statements in 10.3
    • SQL Operators in 10.3
    • Functions in 10.3
    • System Variables in 10.3
    • Status Variables in 10.3
    • System Tables in 10.3
    • Plugins in 10.3
    • Performance Schema in 10.3
    • Information Schema in 10.3
    • wsrep Provider Options in 10.3
    • Error Codes in 10.3
    • Reserved Words in 10.3
    • Command-Line Reference for 10.3
  • MariaDB Enterprise Server 10.2
    • Data Types in 10.2
    • SQL Statements in 10.2
    • SQL Operators in 10.2
    • Functions in 10.2
    • System Variables in 10.2
    • Status Variables in 10.2
    • System Tables in 10.2
    • Plugins in 10.2
    • Performance Schema in 10.2
    • Information Schema in 10.2
    • wsrep Provider Options in 10.2
    • Error Codes in 10.2
    • Reserved Words in 10.2
    • Command-Line Reference for 10.2
  • MariaDB MaxScale 2.4
    • MaxCtrl Commands in 2.4
    • Authenticators in 2.4
    • Filters in 2.4
    • Monitors in 2.4
    • Protocols in 2.4
    • Routers in 2.4
    • Global Parameters in 2.4
    • Command-Line Reference for 2.4
  • MariaDB MaxScale 2.3
    • MaxCtrl Commands in 2.3
    • Authenticators in 2.3
    • Filters in 2.3
    • Monitors in 2.3
    • Protocols in 2.3
    • Routers in 2.3
    • Global Parameters in 2.3
    • Command-Line Reference for 2.3
  • MariaDB ColumnStore 1.4
    • mcsadmin Commands in 1.4
    • System Variables in 1.4
    • Command-Line Reference for 1.4
  • MariaDB Connector/Python 1.0
    • Connector/Python API
• Release Notes
• Support
• Feedback