INSTALLATION, CONFIGURATION, AND CORE ADMIN TASKS
1.
Introduction to MariaDB
- Overview of MariaDB vs MySQL
- Use cases and community vs
enterprise editions
- Architecture and components
overview
2.
Installation and Setup
- Installing MariaDB on Linux/Windows
- Initial configuration and best
practices
- Connecting to the database using
CLI and GUI tools
3. Server
Configuration and Optimization Basics
- Understanding configuration files
(my.cnf/my.ini)
- Tuning server parameters (buffers,
caches)
- Using system variables and dynamic
changes
4. User and
Privilege Management
- Creating users and managing roles
- GRANT, REVOKE, and privilege levels
- Securing accounts and password
policies
5. Schema
and Data Management
- Creating and managing databases and
tables
- Data types, indexes, and
constraints
- Using the mysql command-line tool
and SQL
6. Basic
Monitoring and Logs
- Using SHOW commands and status
variables
- Understanding error logs, slow
query logs
- Checking server health and resource
usage
BACKUP, RECOVERY, REPLICATION, AND PERFORMANCE
1. Backup
and Recovery Strategies
- Logical backup with mysqldump
- Physical backup using mariabackup
- Restoring data and testing recovery
2. Storage
Engines and File Structures
- InnoDB vs MyISAM and others
- Understanding table storage and
performance
- Managing table formats and file
locations
3.
Performance Tuning and Query Optimization
- Analyzing slow queries
- Using EXPLAIN for query plans
- Index optimization and tuning
4.
Replication Fundamentals
- Setting up Master-Slave replication
- Configuration files and binlog
settings
- Monitoring and managing replication
status
5. Security
Best Practices
- Securing MariaDB server and ports
- SSL connections and encrypted data
- Preventing SQL injection and data
leaks
6.
Troubleshooting and Maintenance
- Common issues and how to resolve
them
- Maintenance routines and best
practices
- Upgrade paths and version
management
7. Final
Review and Q&A
- Summary of key concepts
- Hands-on troubleshooting scenarios
- Certification guidance and further
resources
