# Server Management

- [Deployment](/docs/server/server-management/install-and-upgrade-mariadb.md): Learn to install and upgrade MariaDB Server. This section provides detailed instructions and best practices for setting up new instances and seamlessly upgrading existing ones to newer versions.
- [General Deployment Instructions](/docs/server/server-management/install-and-upgrade-mariadb/deployment-general-installing-and-upgrading-instructions.md): Find general instructions for installing and upgrading MariaDB Server deployments. This section offers fundamental guidance applicable across various installation methods and environments.
- [Best Practices](/docs/server/server-management/install-and-upgrade-mariadb/deployment-general-installing-and-upgrading-instructions/best-practices.md): A guide outlining essential recommendations for stable MariaDB deployments, covering backup strategies, change management, security controls, and pre-production testing.
- [Deployment Methods](/docs/server/server-management/install-and-upgrade-mariadb/deployment-general-installing-and-upgrading-instructions/deployment-methods.md): Overview of different deployment architectures (single-node, primary/replica) & methods, including manual installation via repositories or tarballs, and automated deployment with tools like Ansible.
- [Installing Enterprise Server](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server.md)
- [Customer Download Token](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/token.md): Instructions on how to retrieve and use a Customer Download Token to access MariaDB Enterprise Server packages and binaries.
- [MariaDB Enterprise Server Upgrade Paths](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths.md): Provides an overview of supported upgrade paths for MariaDB Enterprise Server, linking to specific guides for upgrading between major versions.
- [MariaDB Enterprise Server 11.8](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.8.md): Upgrade guide for MariaDB Enterprise Server 11.8, highlighting significant performance improvements in transactional throughput, new vector search optimizations, and enhanced observability features.
- [Upgrade to MariaDB Enterprise Server 11.8](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.8/upgrade-to-mariadb-enterprise-server-11.8.md): Upgrade guide for MariaDB Enterprise Server 11.8, highlighting significant performance improvements in transactional throughput, new vector search optimizations, and enhanced observability features.
- [Upgrading from MariaDB Enterprise Server 10.6 to 11.8](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.8/upgrading-from-mariadb-enterprise-server-10.6-to-11.8.md)
- [MariaDB Enterprise Server 11.4](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.4.md): Instructions for upgrading to MariaDB Enterprise Server 11.4, which introduces new data types like UUID and INET4, advanced JSON functions, and non-blocking online schema changes.
- [Upgrade to MariaDB Enterprise Server 11.4](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.4/upgrade-to-mariadb-enterprise-server-11.4.md): Instructions for upgrading to MariaDB Enterprise Server 11.4, which introduces new data types like UUID and INET4, advanced JSON functions, and non-blocking online schema changes.
- [Upgrade MariaDB Enterprise Server from 11.4.X to 11.4.Y](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.4/upgrade-mariadb-enterprise-server-from-11.4.x-to-11.4.y.md): Instructions for upgrading to MariaDB Enterprise Server 11.4, which introduces new data types like UUID and INET4, advanced JSON functions, and non-blocking online schema changes.
- [Upgrade MariaDB Enterprise Server from 10.6 to 11.4](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.4/upgrade-mariadb-enterprise-server-from-10.6-to-11.4.md)
- [Upgrade from MariaDB Community Server to MariaDB Enterprise Server 11.4](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-11.4/upgrade-from-mariadb-community-server-to-mariadb-enterprise-server-11.4.md): Instructions for upgrading to MariaDB Enterprise Server 11.4, which introduces new data types like UUID and INET4, advanced JSON functions, and non-blocking online schema changes.
- [MariaDB Enterprise Server 10.6](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-10.6.md): Upgrade documentation for MariaDB Enterprise Server 10.6, featuring Atomic DDL support, JSON\_TABLE function, improved Oracle compatibility modes, and the removal of older storage engines.
- [Upgrade to MariaDB Enterprise Server 10.6](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-10.6/upgrade-to-mariadb-enterprise-server-10.6.md): Upgrade documentation for MariaDB Enterprise Server 10.6, featuring Atomic DDL support, JSON\_TABLE function, improved Oracle compatibility modes, and the removal of older storage engines.
- [Upgrade MariaDB Enterprise Server from 10.6.X to 10.6.Y](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-10.6/upgrade-mariadb-enterprise-server-from-10.6.x-to-10.6.y.md): Upgrade documentation for MariaDB Enterprise Server 10.6, featuring Atomic DDL support, JSON\_TABLE function, improved Oracle compatibility modes, and the removal of older storage engines.
- [Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.6](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/mariadb-enterprise-server-10.6/upgrade-from-mariadb-community-server-to-mariadb-enterprise-server-10.6.md): Upgrade documentation for MariaDB Enterprise Server 10.6, featuring Atomic DDL support, JSON\_TABLE function, improved Oracle compatibility modes, and the removal of older storage engines.
- [Archived Upgrade Guides (Unmaintained/EOL ES Versions)](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived.md): A collection of upgrade guides for older, end-of-life versions of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [MariaDB Enterprise Server 10.5](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.5.md): A collection of upgrade guides for older, end-of-life versions of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade to MariaDB Enterprise Server 10.5](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.5/upgrade-to-mariadb-enterprise-server-10.5.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade MariaDB Enterprise Server from 10.5.X to 10.5.Y](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.5/upgrade-mariadb-enterprise-server-from-10.5.x-to-10.5.y.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.5](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.5/upgrade-from-mariadb-community-server-to-mariadb-enterprise-server-10.5.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Compatibility and Breaking Changes for MariaDB Enterprise Server 10.5](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.5/compatibility-and-breaking-changes-for-mariadb-enterprise-server-10.5.md)
- [MariaDB Enterprise Server 10.4](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.4.md): A collection of upgrade guides for older, end-of-life versions of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade to MariaDB Enterprise Server 10.4](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.4/upgrade-to-mariadb-enterprise-server-10.4.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade MariaDB Enterprise Server from 10.4.X to 10.4.Y](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.4/upgrade-mariadb-enterprise-server-from-10.4.x-to-10.4.y.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.4](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.4/upgrade-from-mariadb-community-server-to-mariadb-enterprise-server-10.4.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [MariaDB Enterprise Server 10.3](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.3.md): A collection of upgrade guides for older, end-of-life versions of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade to MariaDB Enterprise Server 10.3](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.3/upgrade-to-mariadb-enterprise-server-10.3.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade MariaDB Enterprise Server from 10.3.X to 10.3.Y](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.3/upgrade-mariadb-enterprise-server-from-10.3.x-to-10.3.y.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.3](/docs/server/server-management/install-and-upgrade-mariadb/installing-enterprise-server/upgrade-paths/archived/mariadb-enterprise-server-10.3/upgrade-from-mariadb-community-server-to-mariadb-enterprise-server-10.3.md): An upgrade guide for an older, end-of-life version of MariaDB Enterprise Server, kept for reference purposes for legacy systems.
- [Installing Community Server](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb.md): Learn how to install MariaDB Server on various platforms. This section provides detailed guides and considerations for setting up your database environment, from simple installations to complex deploy
- [MariaDB ID Sign Up](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/mariadb-id-sign-up.md): Information on creating a free MariaDB ID account to access software downloads, including binary packages and repositories.
- [MariaDB Binary Packages](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages.md): Provides details on using MariaDB binary packages (tarballs, RPMs, DEBs) for installation, including repository configuration scripts.
- [MariaDB Package Repository Setup and Usage](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/mariadb-package-repository-setup-and-usage.md): Complete guide to MariaDB package repositories. Complete setup instructions for APT, YUM, Zypper with GPG keys and configurations for production use.
- [GPG](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/gpg.md): Information about the GPG keys used to sign MariaDB packages and repositories, including how to import them for verification.
- [Installing MariaDB .deb Files](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files.md): Complete .deb installation guide: add repo via mariadb\_repo\_setup, import GPG keys, apt install mariadb-server galera-4, and APT configuration.
- [Installing MariaDB RPM Files](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm.md): Install and manage MariaDB Server using RPM packages. This section provides detailed instructions for deploying and upgrading MariaDB on RPM-based Linux distributions.
- [About the MariaDB RPM Files](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/about-the-mariadb-rpm-files.md): Provides an overview of the RPM packages available for MariaDB, listing the various RPMs such as server, client, backup, and shared libraries, and explaining their contents and dependencies.
- [Installing MariaDB with yum/dnf](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/yum.md): How to install MariaDB on systems that use the yum or dnf package managers
- [Installing MariaDB with zypper](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/installing-mariadb-with-zypper.md): Detailed steps for installing MariaDB on SLES and OpenSUSE using the \`zypper\` package manager, including repository configuration and package installation.
- [Checking MariaDB RPM Package Signatures](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/checking-mariadb-rpm-package-signatures.md): Instructions on how to verify the integrity of MariaDB RPM packages using GPG signatures, including importing the public key and running \`rpm --checksig\`.
- [Installing MariaDB With the rpm Tool](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/installing-mariadb-with-the-rpm-tool.md): A guide to installing MariaDB using the low-level \`rpm\` command, suitable for situations where package managers like \`yum\` or \`dnf\` are not available or preferred.
- [MariaDB for DirectAdmin Using RPMs](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/mariadb-for-directadmin-using-rpms.md): Specific instructions for installing MariaDB RPMs on servers running the DirectAdmin control panel, including necessary configuration edits to prevent conflicts.
- [MariaDB Installation via RPMs on CentOS 7](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/mariadb-installation-version-10121-via-rpms-on-centos-7.md): A detailed walkthrough for installing a specific legacy version of MariaDB (10.1.21) on CentOS 7 using individual RPM packages, including dependency resolution.
- [Troubleshooting MariaDB Installs on RHEL / CentOS](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/troubleshooting-mariadb-installs-on-rhel-centos.md): Solutions for common installation issues on RHEL and CentOS, such as conflicts with existing MySQL installations and handling configuration file backups (.rpmsave).
- [Why Source RPMs (SRPMs) Aren't Packaged For Some Platforms](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/why-source-rpms-srpms-arent-packaged-for-some-platforms.md): Explains the limitations in providing Source RPMs (SRPMs) for certain platforms due to CMake version requirements and build system dependencies.
- [Installing MariaDB Alongside MySQL](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-alongside-mysql.md): Instructions for installing MariaDB on the same server as an existing MySQL installation, useful for migration testing or running multiple versions.
- [Installing MariaDB Binary Tarballs](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-binary-tarballs.md): A guide to installing MariaDB from pre-compiled binary tarballs on Linux, allowing for flexible installation paths and multiple versions.
- [Installing MariaDB MSI Packages on Windows](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-msi-packages-on-windows.md): Complete MariaDB installation guide. Complete setup instructions for Linux, Windows, and macOS with configuration and verification for production use.
- [Installing MariaDB on macOS](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-on-macos-using-homebrew.md): How to install MariaDB Server on macOS using the Homebrew package manager, including starting the service and securing the installation.
- [Installing MariaDB on macOS (PKG)](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-server-pkg-packages-on-macos.md): How to install MariaDB Server on macOS. This is possible using Homebrew.
- [Installing MariaDB Windows ZIP Packages](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-windows-zip-packages.md): Instructions for manually installing MariaDB on Windows from a ZIP archive, useful for portable installations or advanced configuration needs.
- [Deploy with Package Tarballs](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/package-tarballs.md): Explains the benefits and use cases for deploying MariaDB using package tarballs (containing RPMs or DEBs) for offline or custom installations.
- [Deploy with Local Package Repository Mirrors](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/repo-mirror.md): Learn how to create and maintain local mirrors of MariaDB package repositories for secure or air-gapped deployments.
- [Installing System Tables](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/installing-system-tables-mariadb-install-db.md): Explains the necessity of initializing system tables (using mariadb-install-db) after installation and troubleshooting startup issues related to missing tables.
- [Installing System Tables on Unix](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/installing-system-tables-mariadb-install-db/installing-system-tables-on-unix.md): Instructions for running the \`mariadb-install-db\` script on Unix-like systems to initialize the MariaDB data directory and system tables.
- [Installing System Tables on Windows](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/installing-system-tables-mariadb-install-db/mariadb-install-db-exe.md): Details the use of \`mariadb-install-db.exe\` on Windows to create new database instances, set the root password, and register Windows services.
- [Troubleshooting Installation Issues](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues.md): A guide to diagnosing and resolving common installation and connection problems, such as socket errors, permission denied messages, and configuration conflicts.
- [Error: symbol mysql\_get\_server\_name, version libmysqlclient\_16 not defined](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/error-symbol-mysql_get_server_name-version-libmysqlclient_16-not-defined.md): Troubleshooting guide for a specific linker error involving \`mysql\_get\_server\_name\` and \`libmysqlclient\_16\`, typically occurring due to library version mismatches.
- [Installation issues on Windows](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-windows.md): Common installation problems on Windows, such as issues with User Account Control (UAC) or unsupported Windows versions, and their solutions.
- [Installation Issues with PHP5](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-with-php5.md): Addresses compatibility issues between MariaDB and older PHP5 client libraries, specifically regarding header and library version mismatches.
- [Installing on an Old Linux Version](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installing-on-an-old-linux-version.md): Guidance for dealing with glibc or shared library errors when attempting to install modern MariaDB binaries on older Linux distributions.
- [Installation Issues on Debian and Ubuntu](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-debian-and-ubuntu.md): A collection of troubleshooting articles specific to Debian and Ubuntu deployments, covering upgrade failures, repository conflicts, and migration issues.
- [apt-upgrade Fails, But the Database is Running](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-debian-and-ubuntu/apt-upgrade-fails-but-the-database-is-running.md): Solutions for when \`apt-get upgrade\` hangs or fails because the MariaDB service takes too long to start, triggering a timeout in the init script.
- [Differences in MariaDB in Debian (and Ubuntu)](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-debian-and-ubuntu/differences-in-mariadb-in-debian-and-ubuntu.md): Explains the differences between official Debian/Ubuntu repository packages and those from MariaDB.org, particularly regarding library linking and configuration defaults.
- [MariaDB 5.5.33 Debian and Ubuntu Installation Issues](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-debian-and-ubuntu/mariadb-5533-debian-and-ubuntu-installation-issues.md): Specific instructions for resolving dependency breakage that occurred with the release of MariaDB 5.5.33 on Debian and Ubuntu systems.
- [MariaDB Debian Live Images](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-debian-and-ubuntu/mariadb-debian-live-images.md): Information about using MariaDB Debian Live images for testing and offline installation, including boot options and default credentials.
- [Moving from MySQL to MariaDB in Debian 9](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-debian-and-ubuntu/moving-from-mysql-to-mariadb-in-debian-9.md): A guide on migrating from MySQL 5.5 to MariaDB 10.1 during an operating system upgrade to Debian 9 (Stretch).
- [Installing MariaDB on IBM Cloud](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/installing-mariadb-on-ibm-cloud.md): Step-by-step instructions for deploying MariaDB on IBM Cloud Kubernetes Service, including provisioning clusters and configuring storage.
- [Compiling MariaDB From Source](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source.md): Instructions for compiling MariaDB Server from source code using CMake, including obtaining the source and installing dependencies.
- [Compiling MariaDB From Source: The Master Guide](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/compiling-mariadb-from-source-the-master-guide.md): Complete step-by-step guide for compiling and building MariaDB from source on various flavors of Linux and on macOS.
- [Building MariaDB on Windows](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/building_mariadb_on_windows.md): Guide to building MariaDB on Windows using Visual Studio, CMake, and Git, including creating ZIP and MSI packages.
- [Cross-compiling MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/cross-compiling-mariadb.md): Instructions for cross-compiling MariaDB for different architectures, including using Buildroot and CMake toolchain files.
- [Compiling MariaDB with Extra Modules/Options](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/compiling-mariadb-with-extra-modulesoptions.md): Compile MariaDB Server with extra modules and options. This section details how to customize your build from source, enabling specific features or optimizations for your deployment.
- [Specifying Which Plugins to Build](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/compiling-mariadb-with-extra-modulesoptions/specifying-which-plugins-to-build.md): Explains how to use CMake options like \`PLUGIN\_xxx\` to control which plugins are built statically, dynamically, or not at all during compilation.
- [Using MariaDB with TCMalloc or jemalloc](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/compiling-mariadb-with-extra-modulesoptions/using-mariadb-with-tcmalloc-or-jemalloc.md): Instructions on building and configuring MariaDB to use alternative memory allocators like TCMalloc or jemalloc for improved performance and profiling.
- [Legacy Guides](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides.md): This section holds building-MariaDB-from-source instructions for building old versions of MariaDB. Recent instructions are in the Compiling MariaDB From Source: The Master Guide page.
- [Build Environment Setup for macOS](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/build_environment_setup_for_mac.md): Instructions for setting up the build environment on macOS, including installing dependencies via Homebrew and configuring CMake.
- [Building MariaDB on Gentoo](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building_mariadb_on_gentoo.md): Instructions for building MariaDB on Gentoo Linux using the \`emerge\` command.
- [Creating a Debian Repository](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/creating_a_debian_repository.md): Instructions on how to create a custom Debian repository for MariaDB packages using \`dpkg-scanpackages\`.
- [Creating the MariaDB Source Tarball](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/creating_the_mariadb_source_tarball.md): Explains how to generate a source tarball from the MariaDB build environment using \`automake\` and \`make dist\`.
- [Build Environment Setup for Linux](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/build-environment-setup-for-linux.md): Lists required tools and dependencies for building MariaDB on Linux, and how to install them using package managers.
- [Building MariaDB from a Source RPM](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-mariadb-from-a-source-rpm.md): Instructions for building MariaDB binaries from a source RPM package using tools like \`rpmbuild\`, \`yum\`, or \`dnf\`.
- [Building MariaDB From Source Using musl-based GNU/Linux](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-mariadb-from-source-using-musl-based-gnulinux.md): Guide for compiling MariaDB on Alpine Linux or other musl-based systems, noting limitations like TokuDB support.
- [Building MariaDB on CentOS](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/source-building-mariadb-on-centos.md): Instructions for building MariaDB on CentOS, including installing build dependencies with \`yum-builddep\`.
- [Building MariaDB on Debian](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-mariadb-on-debian.md): Step-by-step guide for compiling MariaDB on Debian, including installing build dependencies via \`apt-get\` and using \`autobake-deb.sh\`.
- [Building MariaDB on Fedora](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-mariadb-on-fedora.md): Instructions for building MariaDB on Fedora, using \`dnf builddep\` to install dependencies and CMake to configure the build.
- [Building MariaDB on FreeBSD](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-mariadb-on-freebsd.md): Instructions for building MariaDB on FreeBSD using Ports or Poudriere, including configuring build options.
- [Building MariaDB on Solaris and OpenSolaris](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-mariadb-on-solaris-and-opensolaris.md): Notes and configuration tips for building MariaDB on Solaris and OpenSolaris platforms, including buildbot setup.
- [Building MariaDB on Ubuntu](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-mariadb-on-ubuntu.md): Step-by-step guide for compiling MariaDB on Ubuntu, covering build dependencies installation and using source repositories.
- [Building RPM Packages From Source](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/building-rpm-packages-from-source.md): Explains how to generate RPM packages from the MariaDB source code using CMake with the \`-DRPM\` flag.
- [Compile and Using MariaDB with Sanitizers (ASAN, UBSAN, TSAN, MSAN)](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/compile-and-using-mariadb-with-sanitizers-asan-ubsan-tsan-msan.md): Guide on compiling MariaDB with various sanitizers like ASAN and UBSAN for debugging and error detection.
- [Creating the MariaDB Binary Tarball](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/creating-the-mariadb-binary-tarball.md): How to generate a binary tarball from compiled source using \`make package\`, enabling portable distribution.
- [Compiling with the InnoDB Plugin from Oracle](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/compiling-with-the-innodb-plugin-from-oracle.md): Historical guide on compiling older MariaDB versions with the original Oracle InnoDB plugin instead of XtraDB.
- [Compiling MariaDB with Vanilla XtraDB](/docs/server/server-management/install-and-upgrade-mariadb/compiling-mariadb-from-source/legacy-guides/compiling-mariadb-with-vanilla-xtradb.md): A guide for compiling older versions of MariaDB (specifically 5.3) with the original XtraDB engine from Percona Server, useful for testing purposes.
- [Configuring MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb.md): Learn how to configure MariaDB Server. This section covers essential configuration options, system variables, and best practices for tuning your database for optimal performance and security.
- [Configuring MariaDB with Option Files](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files.md): Complete guide to MariaDB option files. Complete my.cnf reference with configuration groups, parameter syntax, and file hierarchy for production use.
- [MariaDB Environment Variables](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-environment-variables.md): Complete MariaDB environment variables: MYSQL\_HOME, LD\_PRELOAD, my.cnf search path precedence, and interaction with option files/command-line options.
- [Advanced Configuration](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations.md): Dive into advanced configurations for MariaDB Server performance. This section covers in-depth tuning parameters, optimization strategies, and best practices to maximize speed and efficiency.
- [Atomic Write Support](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/atomic-write-support.md): Explains the concept of atomic writes in MariaDB, which improve performance and data integrity on SSDs by bypassing the InnoDB doublewrite buffer, supported on devices like Fusion-io and Shannon SSDs.
- [Configuring Linux for MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/configuring-linux-for-mariadb.md): Guidance on tuning Linux kernel settings for MariaDB performance, including I/O schedulers (using \`none\` or \`mq-deadline\`), open file limits, and core file sizes.
- [Configuring MariaDB for Optimal Performance](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/configuring-mariadb-for-optimal-performance.md): Complete MariaDB performance tuning: innodb\_buffer\_pool\_size, aria\_pagecache\_buffer\_size, thread\_handling configuration, and SHOW GLOBAL STATUS monitoring.
- [Configuring Swappiness](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/configuring-swappiness.md): Recommendations for setting the Linux \`vm.swappiness\` kernel parameter (ideally to 1) to prevent the OS from swapping out MariaDB memory pages, which degrades performance.
- [Fusion-io](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/fusion-io.md): Introduction to using Fusion-io flash memory cards with MariaDB to significantly boost I/O throughput and reduce latency, including benefits like atomic write support.
- [Fusion-io Introduction](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/fusion-io/fusion-io-introduction.md): Fusion-io develops PCIe based NAND flash memory cards and related software that can be used to speed up MariaDB databases.
- [Upgrading MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/upgrading.md): Complete MariaDB upgrade guide. Complete migration reference with version compatibility, backup procedures, and rollback strategies for production use.
- [Platform Specific Upgrade Guides](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides.md): Provides tailored instructions for upgrading MariaDB on different operating systems, including Linux and Windows, and within specific environments like Galera Cluster.
- [Upgrading on Linux](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-on-linux.md): Guide to upgrading MariaDB on Linux.
- [Upgrading Between Major MariaDB Versions](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-on-linux/upgrading-between-major-mariadb-versions.md): Complete MariaDB upgrade guide. Complete migration reference with version compatibility, backup procedures, and rollback strategies for production use.
- [Upgrading Between Minor MariaDB Versions](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-on-linux/upgrading-between-minor-versions-on-linux.md): Steps for minor version upgrades (e.g., 10.5.8 to 10.5.9) on Linux, which typically involve package manager updates and a service restart.
- [Upgrading MariaDB on Windows](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-mariadb-on-windows.md): Guide to upgrading MariaDB on Windows using the MSI installer, supporting both minor upgrades and major version migrations using the upgrade wizard.
- [MariaDB Community Server Upgrade Paths](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths.md): An overview of supported upgrade paths for MariaDB Community Server, linking to specific guides for upgrading between major versions like 10.x and 11.x.
- [Upgrading from MariaDB 11.4 to MariaDB 11.8](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-11-4-to-mariadb-11-8.md): Upgrade guide for moving from MariaDB 11.4 to 11.8, covering new features like vector search, optimizer improvements, and data type enhancements.
- [Upgrading from MariaDB 11.3 to MariaDB 11.4](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-11-3-to-mariadb-11-4.md): Instructions for upgrading from the rolling release 11.3 to the long-term support release 11.4, detailing package updates and system table upgrades.
- [Upgrading from MariaDB 10.11 to MariaDB 11.4](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-10-11-to-mariadb-11-4.md): Guide for upgrading from the previous LTS version 10.11 to 11.4, highlighting major optimizer changes, replication improvements, and SSL defaults.
- [Upgrading from MariaDB 10.6 to MariaDB 10.11](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-10-6-to-mariadb-10-11.md): Complete MariaDB 10.6 to 10.11 upgrade: repository config, apt-get/yum/zypper remove+install, my.cnf option changes, and run mariadb-upgrade.
- [Upgrading from MariaDB 10.5 to MariaDB 10.6](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-10-5-to-mariadb-10-6.md): Instructions for upgrading to MariaDB 10.6, noting significant changes like the default character set switch to \`utf8mb3\` and atomic DDL support.
- [Archived Guides (Unmaintained CS Versions)](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases.md): Upgrading guides for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 11.2 to MariaDB 11.3](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-11-2-to-mariadb-11-3.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 11.1 to MariaDB 11.2](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-11-1-to-mariadb-11-2.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 11.0 to MariaDB 11.1](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-11-0-to-mariadb-11-1.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.11 to MariaDB 11.0](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-11-to-mariadb-11-0.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.7 to MariaDB 10.8](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-7-to-mariadb-10-8.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.6 to MariaDB 10.7](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-6-to-mariadb-10-7.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.4 to MariaDB 10.5](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-4-to-mariadb-10-5.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.3 to MariaDB 10.4](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-103-to-mariadb-104.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.2 to MariaDB 10.3](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-102-to-mariadb-103.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.1 to MariaDB 10.2](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-101-to-mariadb-102.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 10.0 to MariaDB 10.1](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-100-to-mariadb-101.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [Upgrading from MariaDB 5.3 to MariaDB 5.5](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-53-to-mariadb-55.md): An upgrading guide for unmaintained versions of MariaDB Community Server.
- [General Upgrade Information](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/general-upgrade-information.md)
- [Downgrading MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/downgrading-between-major-versions-of-mariadb.md): Information on how to downgrade MariaDB Server to a lower release series, including version-specific incompatibility notes, backup and restore fallbacks, and a secure replica-based process.
- [Migrating to MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb.md): Learn how to migrate your existing databases to MariaDB Server. This section provides comprehensive guides and best practices for a smooth and successful data transfer.
- [Differences Between MariaDB and Other DBMSs](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/differences-between-mariadb-and-other-dbmss.md): A high-level comparison of MariaDB's architecture, including its pluggable storage engines, transaction log handling, and buffer pool management versus other databases.
- [DDL Export Guide](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/ddl-export.md): Learn how to export SQL DDL to MariaDB from database management systems like Oracle Database, Microsoft SQL Server, MySQL, and IBM DB2.
- [Migrating to MariaDB from MySQL](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/moving-from-mysql.md): Complete MySQL to MariaDB migration: mysqldump/mysql import steps, SQL syntax compatibility, user/privilege migration, and replication configuration.
- [MySQL to MariaDB Migration: The Master Guide](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/moving-from-mysql/mysql-to-mariadb-migration-the-master-guide.md): Mastering the MySQL to MariaDB transition? This guide covers migrations from MySQL 5.7, 8.0, and 8.4 LTS to MariaDB 11.8/12.3, featuring a full Compatibility Matrix and safe dump/restore workflows.
- [MySQL to MariaDB Compatibility Matrix](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/moving-from-mysql/mysql-to-mariadb-compatibility-matrix.md)
- [Migrating Galera Cluster](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/moving-from-mysql/migration-from-mysql-to-mariadb-cluster-using-replication.md): A strategy for migrating from a MySQL Galera Cluster to a MariaDB Galera Cluster by setting up the new cluster as an asynchronous replica, minimizing downtime.
- [Migrating from MySQL to MariaDB Galera Cluster (Node-by-Node In-Place)](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/moving-from-mysql/migration-from-mysql-to-mariadb-cluster-node-by-node-in-place.md): Instructions for a rolling migration where individual nodes in a MySQL cluster are taken offline, wiped, and replaced with MariaDB nodes, eventually forming a new cluster.
- [Migrating to MariaDB from PostgreSQL](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-postgresql.md): Strategies for moving data from PostgreSQL to MariaDB, using the CONNECT storage engine with ODBC/JDBC or foreign data wrappers.
- [Migrating to MariaDB from Oracle](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-oracle.md): Migrate from Oracle to MariaDB Server. This section provides detailed guidance, tools, and best practices for a smooth and efficient transition of your databases and applications.
- [Oracle XE 11.2. and MariaDB 10.1 integration on Ubuntu 14.04 and Debian systems](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-oracle/oracle-xe-112-and-mariadb-101-integration-on-ubuntu-1404-and-debian-systems.md): Migrate from Oracle to MariaDB Server. This page provides detailed guidance, tools, and best practices for a smooth and efficient transition of your databases and applications.
- [Migrating to MariaDB from SQL Server](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server.md): Migrate from SQL Server to MariaDB. This section provides detailed guidance, tools, and best practices for a smooth and efficient transition of your databases and applications to MariaDB.
- [MariaDB Backups Overview for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-backups-overview-for-sql-server-users.md): Maps SQL Server backup concepts like differential and transaction log backups to MariaDB equivalents such as \`mariadb-backup\` (hot backups) and binary logs for incremental recovery.
- [Understanding MariaDB Architecture](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/understanding-mariadb-architecture.md): An architectural overview for SQL Server DBAs, covering MariaDB's storage engines (InnoDB), transaction logs (undo/redo), buffer pool, and system databases.
- [MariaDB Features Not Available in SQL Server](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-features-not-available-in-sql-server.md): Highlights features unique to MariaDB, such as pluggable storage engines, dynamic columns, and Flashback, which can offer advantages after migration.
- [SQL Server Features Not Available in MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/sql-server-features-not-available-in-mariadb.md): Features available in Microsoft SQL Server that aren't available in MariaDB.
- [SQL Server Features Implemented Differently in MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/sql-server-features-implemented-differently-in-mariadb.md): Differences between features in Microsoft SQL Server and MariaDB.
- [SQL Server and MariaDB Types Comparison](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/sql-server-and-mariadb-types-comparison.md): A reference guide mapping SQL Server data types (e.g., \`money\`, \`bit\`) to their MariaDB equivalents, highlighting differences in precision and storage.
- [Syntax Differences between MariaDB and SQL Server](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/syntax-differences-between-mariadb-and-sql-server.md): Details syntax variations between the two systems, such as string quoting, NULL handling, and DDL statement differences, with advice on using \`sql\_mode='MSSQL'\`.
- [MariaDB Authorization and Permissions for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-authorization-and-permissions-for-sql-server-users.md): Complete MariaDB authorization for SQL Server users: 'user'@'host' accounts, CREATE USER/GRANT syntax, IDENTIFIED VIA plugins, TLS/X509, and role management.
- [MariaDB Replication Overview for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-replication-overview-for-sql-server-users.md): An introduction to MariaDB's asynchronous replication and Galera Cluster for SQL Server users, explaining concepts like binary logs, relay logs, and group commit.
- [MariaDB Transactions and Isolation Levels for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-transactions-and-isolation-levels-for-sql-server-users.md): Complete transaction isolation for SQL Server users: START TRANSACTION/COMMIT/ROLLBACK, tx\_isolation levels, WITH CONSISTENT SNAPSHOT, innodb\_lock\_wait\_timeout.
- [Moving Data Between SQL Server and MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/moving-data-between-sql-server-and-mariadb.md): Provides methods for transferring data from SQL Server to MariaDB, including generating CSV files, using \`mariadb-dump\`, or leveraging the CONNECT storage engine with ODBC.
- [Repairing MariaDB Tables for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/repairing-mariadb-tables-for-sql-server-users.md): Explains how to check and repair tables in MariaDB using \`CHECK TABLE\` and \`REPAIR TABLE\`, noting that InnoDB typically handles corruption by crashing to prevent data loss.
- [Setting Up MariaDB for Testing for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/setting-up-mariadb-for-testing-for-sql-server-users.md): From selecting a MariaDB version to setting it up on Windows, using various packages or Docker, this page covers multiple scenarios.
- [MariaDB on Amazon RDS](/docs/server/server-management/install-and-upgrade-mariadb/mariadb-on-amazon-rds.md): While specific documentation content was not returned, this section typically covers the specifics of running MariaDB as a managed service on AWS RDS, including version support and configuration.
- [Starting & Stopping](/docs/server/server-management/starting-and-stopping-mariadb.md): Complete Starting & Stopping guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples and.
- [Starting and Stopping Overview](/docs/server/server-management/starting-and-stopping-mariadb/starting-and-stopping-mariadb-automatically.md): Complete Starting and Stopping Overview guide for MariaDB. Complete reference documentation for implementation, configuration, and usage for production use.
- [launchd (macOS)](/docs/server/server-management/starting-and-stopping-mariadb/launchd.md): Instructions for configuring MariaDB to start automatically on macOS using a launchd plist file in /Library/LaunchDaemons.
- [systemd (Linux)](/docs/server/server-management/starting-and-stopping-mariadb/systemd.md): Complete MariaDB systemd reference: mariadb.service/mariadb@.service units, systemctl commands, TimeoutStartSec/EXTEND\_TIMEOUT\_USEC, and drop-in configs.
- [sysVinit](/docs/server/server-management/starting-and-stopping-mariadb/sysvinit.md): Describes how to manage MariaDB using SysVinit scripts (mysql.server), common on older Linux distributions, using commands like \`service\` and \`chkconfig\`.
- [mariadbd-safe](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-safe.md): Details the \`mariadbd-safe\` wrapper script, which adds safety features like auto-restart upon crash and error logging to syslog.
- [mariadbd-multi](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-multi.md): Explains how to use \`mariadbd-multi\` to manage multiple MariaDB server processes on a single host using GNR groups in the configuration file.
- [mariadbd Options](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options.md): A reference list of command-line options available for the \`mariadbd\` server binary, covering configuration, replication, and service installation.
- [mariadbd](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd.md): Describes the \`mariadbd\` binary (formerly \`mysqld\`), which is the core database server executable.
- [mysql.server](/docs/server/server-management/starting-and-stopping-mariadb/mysql-server.md): Documentation for the \`mysql.server\` script, a SysVinit-style wrapper used to start and stop \`mariadbd-safe\`.
- [Running MariaDB From the Build Directory](/docs/server/server-management/starting-and-stopping-mariadb/running-mariadb-from-the-build-directory.md): Instructions for developers on how to run MariaDB directly from the source build directory without installing it to system paths.
- [Running Multiple MariaDB Server Processes](/docs/server/server-management/starting-and-stopping-mariadb/running-multiple-mariadb-server-processes.md): A guide on configuring and running multiple independent MariaDB instances on the same machine by isolating data directories, ports, and sockets.
- [Specifying Permissions for Schema (Data) Directories and Tables](/docs/server/server-management/starting-and-stopping-mariadb/specifying-permissions-for-schema-data-directories-and-tables.md): Explains default file permissions for data directories and how to customize them using \`UMASK\` and \`UMASK\_DIR\` environment variables.
- [Switching Between Different Installed MariaDB Versions](/docs/server/server-management/starting-and-stopping-mariadb/switching-between-different-installed-mariadb-versions.md): Techniques for managing parallel installations of different MariaDB versions, typically using symlinks and separate data directories for testing.
- [What to Do if MariaDB Doesn't Start](/docs/server/server-management/starting-and-stopping-mariadb/what-to-do-if-mariadb-doesnt-start.md): Complete What to Do if MariaDB Doesn't Start guide for MariaDB. Complete reference documentation for implementation, configuration, and usage.
- [Automated Deployment & Administration](/docs/server/server-management/automated-mariadb-deployment-and-administration.md): An overview of automation tools and strategies for deploying MariaDB, comparing systems like Ansible, Puppet, and Kubernetes, and discussing "Infrastructure as Code" principles.
- [Why to Automate MariaDB Deployments and Management](/docs/server/server-management/automated-mariadb-deployment-and-administration/why-to-automate-mariadb-deployments-and-management.md): Explains the benefits of automating database deployment and management, such as consistency, scalability, and the adoption of Infrastructure as Code principles.
- [Comparison Between Automation Systems](/docs/server/server-management/automated-mariadb-deployment-and-administration/a-comparison-between-automation-systems.md): Compares different automation tools like Ansible and Puppet, highlighting differences in their architecture (agentless vs. agent-based) and code structure to help users choose the right tool.
- [Automating MariaDB Tasks with Events](/docs/server/server-management/automated-mariadb-deployment-and-administration/automating-mariadb-tasks-with-events.md): Describes how to use the MariaDB Event Scheduler to automate recurring SQL tasks directly within the database server, similar to cron jobs.
- [Automating Upgrades with MariaDB.Org Downloads REST API](/docs/server/server-management/automated-mariadb-deployment-and-administration/automating-upgrades-with-mariadborg-downloads-rest-api.md): A guide on using the MariaDB Downloads REST API to programmatically retrieve information about software versions, facilitating automated upgrade scripts.
- [HashiCorp Vault and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/hashicorp-vault-and-mariadb.md): Discusses the integration of HashiCorp Vault with MariaDB for managing secrets, including using MariaDB as a storage backend for Vault.
- [Orchestrator Overview](/docs/server/server-management/automated-mariadb-deployment-and-administration/orchestrator-overview.md): An introduction to Orchestrator, a tool for managing MySQL and MariaDB replication topologies, providing high availability and automated failover capabilities.
- [Ansible and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb.md): Provides general information and resources for using Ansible to automate the deployment and configuration of MariaDB servers using playbooks.
- [Ansible Overview for MariaDB Users](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/ansible-overview-for-mariadb-users.md): Introduction to core Ansible concepts such as inventories, playbooks, and roles, with specific examples of how to structure them for MariaDB deployments like Galera Clusters and replicas.
- [Deploying Docker Containers with Ansible](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/deploying-docker-containers-with-ansible.md): Explains how to use Ansible's Docker modules to automate the deployment and configuration of MariaDB containers, serving as an alternative to Docker Compose.
- [Deploying to Remote Servers with Ansible](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/deploying-to-remote-servers-with-ansible.md): A guide to executing Ansible commands and playbooks on remote servers via SSH, covering basic connectivity tests (ping) and the application of roles to specific host groups.
- [Existing Ansible Modules and Roles for MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/existing-ansible-modules-and-roles-for-mariadb.md): Lists and describes the standard Ansible modules available for managing MariaDB, such as \`mysql\_db\`, \`mysql\_user\`, and \`mysql\_variables\`, highlighting their idempotent nature.
- [Installing MariaDB .deb Files with Ansible](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/installing-mariadb-deb-files-with-ansible.md): Detailed instructions for automating the installation of MariaDB on Debian/Ubuntu systems, including tasks for adding repositories, importing GPG keys, and installing packages.
- [Managing Secrets in Ansible](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/managing-secrets-in-ansible.md): Best practices for handling sensitive information like database passwords and SSH keys within Ansible, recommending the use of \`ansible-vault\` to encrypt secrets.
- [Running mariadb-tzinfo-to-sql with Ansible](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/running-mariadb-tzinfo-to-sql-with-ansible.md): Demonstrates how to automate the loading of time zone data into MariaDB using the \`mysql\_tzinfo\_to\_sql\` utility, with techniques to ensure the task is idempotent.
- [Puppet and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb.md): General information and hints on how to automate MariaDB deployments and configuration with Puppet, an open source tool for deployment, configuration, and operations.
- [Puppet Overview](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/puppet-overview-for-mariadb-users.md): Introduction to Puppet's architecture (agent-master vs. standalone), concepts like manifests and catalogs, and how it can be used for configuration management of MariaDB servers.
- [Deploying Docker Containers with Puppet](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/deploying-docker-containers-with-puppet.md): A guide to managing Docker container lifecycles using Puppet's \`docker\` resource type, covering image pulling, container execution, and upgrades for MariaDB.
- [Existing Puppet Modules for MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/existing-puppet-modules-for-mariadb.md): Lists available Puppet modules for MariaDB from the Puppet Forge and GitHub, noting that while no official module exists, community and generic MySQL modules are often used.
- [Puppet hiera Configuration System](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/puppet-hiera-configuration-system.md): Explains how to use Hiera, Puppet's hierarchical key/value lookup tool, to separate MariaDB configuration data from code and manage environment-specific settings.
- [Bolt Examples](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/bolt-examples.md): Demonstrates how to use Bolt, an orchestration tool in the Puppet ecosystem, to run ad-hoc commands, scripts, and tasks on remote MariaDB servers without a permanent agent.
- [MariaDB Containers](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb.md): Discusses running MariaDB in Docker containers, covering the benefits of isolation and ease of deployment for development and testing environments.
- [Adding Plugins to the MariaDB Docker Official Image](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/adding-plugins-to-the-mariadb-docker-official-image.md): Instructions on how to extend the official MariaDB Docker image by installing additional plugins and dependencies using a custom Dockerfile.
- [Benefits of Managing MariaDB Containers with Orchestration Software](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/benefits-of-managing-mariadb-containers-with-orchestration-software.md): Explains the advantages of using orchestration tools like Kubernetes or Docker Swarm for managing MariaDB containers, including automated failover, scaling, and rolling updates.
- [Container Backup and Restoration](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/container-backup-and-restoration.md): Complete container backup guide: docker volume create, mariadb-dump --all-databases, mariadb-backup --backup/--prepare/--copy-back operations.
- [Container Security](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/container-security-concerns.md): Discusses security best practices for running MariaDB in containers, addressing topics like root user privileges, volume permissions, and network isolation.
- [Creating a Custom Container Image](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/creating-a-custom-container-image.md): Guide to building a custom MariaDB container image to include specific configuration files, scripts, or pre-loaded data.
- [Deploy MariaDB Enterprise Server with Docker](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/deploy-mariadb-enterprise-server-with-docker.md): Instructions for deploying MariaDB Enterprise Server using the official enterprise Docker images, including handling license keys and entitlements.
- [MariaDB Enterprise Docker Registry for MariaDB Enterprise Server](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/mariadb-enterprise-docker-registry-for-mariadb-enterprise-server.md): How to authenticate with and pull images from the private MariaDB Enterprise Docker Registry.
- [Docker and AWS EC2](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-and-aws-ec2.md): Specific considerations and steps for running MariaDB Docker containers on Amazon EC2 instances.
- [Docker and Google Cloud](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-and-google-cloud.md): Guide for deploying MariaDB containers on Google Cloud Platform (GCP) compute resources.
- [Docker and Microsoft Azure](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-and-microsoft-azure.md): Instructions for running MariaDB containers within the Microsoft Azure ecosystem.
- [Docker Official Image Frequently Asked Questions](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-official-image-frequently-asked-questions.md): Answers to common questions regarding the official MariaDB image, covering versioning, tagging, and default configurations.
- [Installing and Using MariaDB via Docker](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/installing-and-using-mariadb-via-docker.md): Complete guide to MariaDB in Docker. Complete resource for container deployment, volume management, networking, and environment setup for production use.
- [MariaDB Container Cheat Sheet](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/mariadb-container-cheat-sheet.md): A concise reference of common Docker commands and environment variables used with MariaDB containers.
- [MariaDB Server Docker Official Image Environment Variables](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/mariadb-server-docker-official-image-environment-variables.md): Complete guide to MariaDB in Docker. Complete resource for container deployment, volume management, networking, and environment setup for production use.
- [Setting Up a LAMP Stack with Docker Compose](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/setting-up-a-lamp-stack-with-docker-compose.md): Complete LAMP stack Docker Compose: define docker-compose.yml services (web/mariadb), set volumes/env vars (${MARIADB\_VERSION}), docker-compose up/down.
- [Using Healthcheck](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/using-healthcheck-sh.md): Complete healthcheck.sh Docker reference: --connect, --innodb\_initialized, --replication\_\* checks, .my-healthcheck.cnf config, and environment variables.
- [Kubernetes and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/kubernetes-and-mariadb.md): General information and hints on deploying MariaDB Kubernetes (K8s) containers, an open source container orchestration system which automates deployments, horizontal scaling, configuration, and operat
- [Kubernetes Operators for MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/kubernetes-and-mariadb/kubernetes-operators-for-mariadb.md): Official Kubernetes Operators for MariaDB: Enterprise Operator for MariaDB Server+MaxScale, CRDs/controllers, HA topologies, and backup/restore automation.
- [Kubernetes Overview for MariaDB Users](/docs/server/server-management/automated-mariadb-deployment-and-administration/kubernetes-and-mariadb/kubernetes-overview-for-mariadb-users.md): Introduction to core Kubernetes concepts relevant to database administrators, such as StatefulSets, Persistent Volumes, and Services, and how they apply to MariaDB storage and networking.
- [Vagrant and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb.md): Vagrant is an open source tool to quickly setup machines that can be used for development and testing. They can be local virtual machines, Docker containers, AWS EC2 instances, and so on
- [Creating a Vagrantfile](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb/creating-a-vagrantfile.md): A guide on creating and configuring a \`Vagrantfile\` to define the characteristics of a MariaDB virtual machine, including box selection and provisioning steps.
- [Vagrant Overview for MariaDB Users](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb/vagrant-overview-for-mariadb-users.md): Introduction to Vagrant's workflow and terminology for database administrators, explaining how it simplifies the creation of reproducible MariaDB development environments.
- [Vagrant Security](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb/vagrant-security-concerns.md): Discusses security considerations when using Vagrant with MariaDB, such as default insecure keys, port forwarding risks, and ensuring production-grade settings are not used in dev boxes.
- [Server Monitoring & Logs](/docs/server/server-management/server-monitoring-logs.md): Learn about MariaDB Server monitoring and logs. This section guides you through using various logs & monitoring tools to track database activity, troubleshoot issues, and ensure optimal performance.
- [Overview of MariaDB Logs](/docs/server/server-management/server-monitoring-logs/overview-of-mariadb-logs.md): An introductory guide to the various logs available in MariaDB, including the Error Log, General Query Log, Slow Query Log, and Binary Log, and how to enable or disable them.
- [Securing MariaDB Logs](/docs/server/server-management/server-monitoring-logs/securing-mariadb-logs.md): Learn how to harden MariaDB log files by implementing at-rest encryption, TLS for transit, strict OS permissions, and automated rotation to ensure data integrity and regulatory compliance.
- [Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log.md): Understand the binary log in MariaDB Server. This section explains its role in replication and point-in-time recovery, detailing its format, management, and use for data integrity.
- [Overview of the Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log/overview-of-the-binary-log.md): Introduction to the purpose and structure of the binary log, explaining how it records data changes (DML) and structure changes (DDL) for replication and recovery.
- [Activating the Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log/activating-the-binary-log.md): Instructions for enabling the binary log using the --log-bin option and configuring the log file basename and index file.
- [Binary Log Formats](/docs/server/server-management/server-monitoring-logs/binary-log/binary-log-formats.md): Detailed comparison of the three binary logging formats: Statement-based (SBR), Row-based (RBR), and Mixed, including their pros, cons, and configuration via binlog\_format.
- [Using and Maintaining the Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log/using-and-maintaining-the-binary-log.md): Complete binary log maintenance: PURGE BINARY LOGS/RESET MASTER, expire\_logs\_days & binlog\_expire\_logs\_seconds, FLUSH BINARY LOGS, and SHOW SLAVE STATUS.
- [Row Binlog Events](/docs/server/server-management/server-monitoring-logs/binary-log/row-binlog-events.md)
- [InnoDB-Based Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log/innodb-based-binary-log.md): MariaDB 12.3 introduces a new binary log implementation that stores binlog events directly into InnoDB-managed tablespaces instead of separate flat files on disk.
- [Compressing Events to Reduce Size of the Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log/compressing-events-to-reduce-size-of-the-binary-log.md): Guide to using the \`log\_bin\_compress\` system variable to compress binary log events, reducing storage usage and network bandwidth during replication.
- [Flashback](/docs/server/server-management/server-monitoring-logs/binary-log/flashback.md): Explains how to use the Flashback feature (via \`mysqlbinlog --flashback\`) to rollback transactions by reversing the binary log events, useful for recovering from accidental data modifications.
- [Group Commit for the Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log/group-commit-for-the-binary-log.md): Describes the group commit optimization, which improves performance by committing multiple transactions to the binary log in a single disk I/O operation.
- [Relay Log](/docs/server/server-management/server-monitoring-logs/binary-log/relay-log.md): Overview of the relay log, a set of log files created by a replica server to store events received from the primary's binary log before executing them.
- [Selectively Skipping Replication of Binlog Events](/docs/server/server-management/server-monitoring-logs/binary-log/selectively-skipping-replication-of-binlog-events.md): Learn techniques to bypass specific replication events. This guide explains how to ignore individual transactions or errors to restore replication flow after a stoppage.
- [Error Log](/docs/server/server-management/server-monitoring-logs/error-log.md): Complete Error Log guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples and best.
- [General Query Log](/docs/server/server-management/server-monitoring-logs/general-query-log.md): Complete General Query Log guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples.
- [MyISAM Log](/docs/server/server-management/server-monitoring-logs/myisam-log.md): Explains the MyISAM log (\`myisam.log\`), a specialized log for recording changes to MyISAM tables for debugging purposes, enabled via the \`--log-isam\` option.
- [Rotating Logs on Unix and Linux](/docs/server/server-management/server-monitoring-logs/rotating-logs-on-unix-and-linux.md): A guide to using the \`logrotate\` utility on Linux to manage MariaDB log files, ensuring they don't consume excessive disk space by rotating, compressing, and archiving them.
- [Slow Query Log](/docs/server/server-management/server-monitoring-logs/slow-query-log.md): Utilize the slow query log in MariaDB Server. This section helps you identify and optimize inefficient queries, improving overall database performance and responsiveness.
- [Slow Query Log Overview](/docs/server/server-management/server-monitoring-logs/slow-query-log/slow-query-log-overview.md): Complete Slow Query Log Overview guide for MariaDB. Complete reference documentation for implementation, configuration, and usage for production use.
- [EXPLAIN in the Slow Query Log](/docs/server/server-management/server-monitoring-logs/slow-query-log/explain-in-the-slow-query-log.md): Describes how to configure MariaDB to automatically write the \`EXPLAIN\` plan for slow queries to the log using the \`log\_slow\_verbosity\` system variable.
- [log\_slow\_always\_query\_time System Variable](/docs/server/server-management/server-monitoring-logs/slow-query-log/log_slow_always_query_time-system-variable.md): Documentation for the \`log\_slow\_always\_query\_time\` variable, which forces queries executed by a specific function or user to be logged regardless of their execution time.
- [SQL Error Log Plugin](/docs/server/server-management/server-monitoring-logs/sql-error-log-plugin.md): Documentation for the SQL Error Log Plugin, which allows logging of errors sent to clients to a file, enabling analysis of application-side errors that might otherwise be missed.
- [Transaction Coordinator Log](/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log.md): Explains the Transaction Coordinator Log (tc.log), used to maintain consistency in distributed transactions (XA) across multiple storage engines or servers.
- [Transaction Coordinator Log Overview](/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log/transaction-coordinator-log-overview.md): Explains the purpose of the Transaction Coordinator (TC) log (\`tc.log\`), which maintains consistency for XA transactions that affect multiple storage engines, and how to configure it.
- [Heuristic Recovery with the Transaction Coordinator Log](/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log/heuristic-recovery-with-the-transaction-coordinator-log.md): Describes the process of heuristic recovery using the TC log to resolve "in-doubt" transactions that may occur after a server crash during a 2-phase commit.
- [Writing Logs Into Tables](/docs/server/server-management/server-monitoring-logs/writing-logs-into-tables.md): Instructions on directing the General Query Log and Slow Query Log to tables (\`mysql.general\_log\`, \`mysql.slow\_log\`) instead of files using the \`log\_output=TABLE\` system variable.
- [Variables and Modes](/docs/server/server-management/variables-and-modes.md): Explore MariaDB Server variables and modes. This section explains how to configure global and session variables, and how different SQL modes influence database behavior and compatibility.
- [Options, System & Status Variables](/docs/server/server-management/variables-and-modes/full-list-of-mariadb-options-system-and-status-variables.md): A comprehensive, alphabetical reference list of all server command-line options, system variables, and status variables available in MariaDB.
- [Server Status Variables](/docs/server/server-management/variables-and-modes/server-status-variables.md): Documentation for server status variables, which provide information about the server's current state and operation (e.g., \`Aborted\_connects\`, \`Uptime\`), accessed via \`SHOW STATUS\`.
- [Server System Variables](/docs/server/server-management/variables-and-modes/server-system-variables.md): Complete server system variables reference for MariaDB. Complete guide for connection handling, caching, logging, and performance tuning for production use.
- [NEW\_MODE](/docs/server/server-management/variables-and-modes/new_mode.md): Explains the \`NEW\_MODE\` system variable, introduced in MariaDB 11.4, which allows users to opt-in to new, potentially incompatible behaviors or optimizations that will become default in future version
- [OLD\_MODE](/docs/server/server-management/variables-and-modes/old_mode.md): Describes the \`OLD\_MODE\` system variable, used to revert specific behaviors to match older MariaDB or MySQL versions for compatibility purposes during upgrades.
- [SQL\_MODE](/docs/server/server-management/variables-and-modes/sql_mode.md): Complete SQL\_MODE reference: set via SET/SET GLOBAL/--sql-mode, view @@SQL\_MODE, STRICT\_TRANS\_TABLES, ANSI\_QUOTES, TRADITIONAL, and database emulation.