Mastering of MariaDB: MariaDB Administration

Name: Mastering of MariaDB: MariaDB Administration
Rating: 4.7 (255 reviews)

MariaDB Administration and Development

Highest Rated

Created byDatabase Center

Last updated 8/2025

English

What you'll learn

Install and configure MariaDB effectively for optimized performance and security
Understand MariaDB's architecture and utilize it for efficient database management
Perform backups, monitor databases, and audit activity to ensure data integrity
Implement data encryption techniques to protect sensitive information
Transfer data to MariaDB and set up replication for improved data availability.
Create and manage database objects like tables, views, and indexes for efficient data organization
Create and manage a MariaDB cluster to enhance high availability and scalability
Installing and configuring MaxScale for high availability functionality and cluster management

Course content

16 sections • 58 lectures • 11h 0m total length

Introduction2:39

What is MariaDB?5:49
Explore MariaDB, an open source relational database management system forked from MySQL, designed for speed, stability, and scalability. Understand how tables, keys, SQL, and ACID govern reliable data.
MariaDB Storage Design7:39
Design a MariaDB storage layout on Linux with three separate mount points for data, binlog, and backups on dedicated disks to boost performance and enable replication and point-in-time recovery.
Architecture of MariaDB19:50
Explore the architecture of MariaDB, including client authentication, query processing, and the pluggable storage engine model with InnoDB and binary log.

How to Connect to MariaDB4:17
How to Create a Database21:32
Create User12:08
Grant Privileges25:50
Learn to grant privileges in MariaDB at global, database, table, and column levels, using grant statements and revoke commands, with the grant option to delegate rights.
Create Role7:42
Binary Log10:23
Activate binary log to support replication and data recovery; configure mixed bin log format, set server ID, and max bin log size, and use expire log days.

Server System variables10:31
Basic Configuration21:20
More Advanced Configuration20:24
Explore redo and undo logs and InnoDB buffer pool and flush settings in MariaDB to understand durability, performance, and crash recovery.
What is Benchmarking?18:53
Explore benchmarking in MariaDB using Sysbench to evaluate performance under OLTP workloads, covering fair setup, reproducible tests, and interpreting transactions per second and latency.

Create Table19:42
Create Index15:44
Create Routine14:28
Master how to create and manage MariaDB routines, including definer and invoker sql security, in/out parameters, and the difference between procedures and functions.
Create Event2:10
Create Trigger7:56
Discover how triggers in MariaDB automatically enforce rules, log changes, and cascade actions, with a before update trigger example that blocks salary changes beyond 10 percent.
Create View4:12

Data Types5:18
String Functions5:18
Date and Time Functions15:40
Numeric Functions1:42
Explore numeric functions in MariaDB, including greatest and maximum values, smallest and minimum values, truncate to decimal places without rounding, and ceil and floor operations for precise decimal control.
Other Important Functions4:57
Explore MariaDB's important operators and functions, including case, if, if null, nvl and nvl two, null if, and utilities like connection_id, current_user, current_role, database, schema, and version.

Partitioning14:44
Learn how partitioning in MariaDB divides large tables into partitions by range, such as by year or date, to speed queries, simplify purging, optimize storage, and ease maintenance.
Altering Partitions3:59
Learn to alter partitions in MariaDB by converting a partition to a table and a table to a partition, drop partitions, and remove partitioning while preserving data.
Reorganizing2:29

Audit Plugin9:57
Information Schema5:34
Explore how information schema in MariaDB provides metadata on schema, objects, permissions, and configurations to support database management, auditing, and documentation, and is safe to use for ongoing database monitoring.
Performance Schema12:11
Monitoring Tool5:53
Explore how to monitor a Mariadb server using dashboards that show CPU, RAM, hit rates, connections and threads, and compare free and paid options with Prometheus, Grafana, and other tools.

Requirements

Basic Linux skills
Basic SQL skills
Basic knowledge of relational databases

Description

This comprehensive course on MariaDB administration and Development is designed for developers and database administrators looking to master the skills needed for effective MariaDB management.

From setting up and configuring MariaDB to understanding its unique architecture, you’ll gain hands-on knowledge essential for building and managing robust databases.

Throughout the course, we’ll dive into critical topics such as benchmarking, creating databases and objects, and performing efficient user and role management to secure your environment. You’ll also learn essential backup and recovery strategies, along with auditing and monitoring practices to ensure data integrity and optimal performance.

Security is a focus, with modules covering data encryption techniques to safeguard sensitive information from unauthorized access. Additionally, we’ll explore database and table cloning, which can help you to build a dynamic environment for the database developers.

I’ll also guide you through clustering in MariaDB, a powerful technique for achieving higher availability and scalability. You’ll learn how to set up and manage MariaDB clusters, ensuring your database can handle increased workloads and minimize downtime.

Whether you're new to MariaDB or looking to deepen your expertise, this course will equip you with the tools and techniques needed to handle complex database environments effectively. By the end, you’ll have a thorough understanding of MariaDB, ready to tackle real-world challenges and drive performance in any organization.

Enroll today and start mastering MariaDB administration to enhance your database skills and advance your career in the dynamic field of database management!

* This course is still evolving, and new videos will be added in the future to cover even more advanced topics and techniques, ensuring you stay up to date with the latest in MariaDB administration.

Who this course is for:

Database Developers and Administrators

Mastering of MariaDB: MariaDB Administration

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Installing MariaDB1 lecture • 22min

Architecture of MariaDB3 lectures • 33min

Basic Administration6 lectures • 1hr 22min

Configuration4 lectures • 1hr 11min

Create Objects6 lectures • 1hr 4min

Data and Functions5 lectures • 33min

Partitioning3 lectures • 21min

Transaction2 lectures • 23min

Auditing and Monitoring4 lectures • 34min

Requirements

Description

Who this course is for: