MariaDB Administration Training in Kuala Lumpur, Malaysia

This course provides a practical introduction to administering MariaDB databases. Participants will learn how to install, configure, secure, manage, and troubleshoot MariaDB. The training includes hands-on labs and exercises to build real-world administration skills.

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