Skip to main content
Have a personal or library account? Click to login
Mastering MariaDB Cover

Mastering MariaDB

Debug, secure, and back up your data for optimum server performance with MariaDB

Publisher:Packt Publishing Limited
Paid access
|Oct 2025
Product purchase options
Description

Key Features

    Book Description

    This book is intended for intermediate users who want to learn how to administrate a MariaDB server or a set of servers. It is aimed at MariaDB users, and hence working knowledge of MariaDB is a prerequisite.

    What you will learn

    • Identify inefficient queries using logs and log analysis tools
    • Design your indexes and optimize your queries to produce efficient query plans
    • Tune MariaDB and InnoDB configuration to achieve a stabilized degree of performance and reliability
    • Create and manage users, roles, and permissions
    • Perform regular backups and restore data
    • Share your data through several partitions, disks, or servers using techniques such as replication to make operations faster
    • Set up, maintain, and troubleshoot a replication environment as well as a database cluster

    Who this book is for

    Table of Contents

    1. Understanding the Essentials
    2. Debugging
    3. Optimizing queries
    4. Transactions and locks
    5. Users and connections
    6. Caches
    7. InnoDB compression
    8. Backup and disaster recovering
    9. Replication
    10. Table partitioning
    11. Data sharding
    12. MariaDB Galera Cluster
    PDF ISBN: 978-1-78398-155-7
    Publisher: Packt Publishing Limited
    Copyright owner: © 2014 Packt Publishing Limited
    Publication date: 2025
    Language: English
    Pages: 384
    Related subjects:
    General interest

    People also read

    Getting Started with MariaDB
    Book

    Getting Started with MariaDB

    MariaDb Essentials
    Book

    MariaDb Essentials

    MariaDB Cookbook
    Book

    MariaDB Cookbook

    MariaDB High Performance
    Book

    MariaDB High Performance

    Querying MariaDB
    Book

    Querying MariaDB

    Adam Aspin
    MySQL Cookbook
    Book

    MySQL Cookbook

    Elias Negrin
    Building a Web Application with PHP and MariaDB: A Reference Guide
    Book

    Building a Web Application with PHP and MariaDB: A Reference Guide

    MySQL Admin Cookbook LITE: Replication and Indexing
    Book

    MySQL Admin Cookbook LITE: Replication and Indexing

    MySQL 8 Cookbook
    Book

    MySQL 8 Cookbook

    Karthik Appigatla
    High Availability MySQL Cookbook
    Book

    High Availability MySQL Cookbook

    Alexander Davies